Moni
Kuchokera kwondichitikira kwanga ndikulankhula chinthu chimodzi chodziwikiratu: ogwiritsa ntchito ambiri omwe amawagwiritsa ntchito amatsanzira Excel (ndipo ndinganene kuti iwo amanyalanyaza kwambiri). Mwinamwake ndikuweruza kuchokera pa zomwe ndinakumana nazo (pamene sindinali kuwonjezera nambala 2) ndipo sindinalingalire chifukwa chake ndinkafunikira Excel, ndikukhala "wosasamala" ntchito mu Excel - Ndinkatha kuthetsa nthawi zambiri zomwe ndinkakonda "kuganiza" ...
Cholinga cha nkhaniyi: osati kungosonyeza momwe mungachitire chinthu china, komanso kusonyeza mwayi wopezeka pulogalamu ya ogwiritsa ntchito osamvetsetsa omwe sakudziwa ngakhale pang'ono za iwo. Ndipotu, kukhala ndi luso loyamba la ntchito ku Excel (monga ndanenera kale) - mungathe kufulumira ntchito yanu kangapo!
Zophunzira ndizochepa malangizo othandizira kuti achite. Ndinasankha nkhani za maphunziro potsatira mafunso omwe nthawi zambiri ndimayankha.
Nkhani Za phunziro: kusanthula mndandanda ndi ndondomeko yofunikira, kupukusa manambala (sum formula), kufukula mizera, kupanga tebulo ku Excel, kupanga girasi (chithunzi).
Excel 2016 Maphunziro
1) Momwe mungasankhire mndandanda wa alfabeti, mu kukwera dongosolo (molingana ndi ndime / ndime yomwe mukufunikira)
Ntchito zoterozo zimapezeka nthawi zambiri. Mwachitsanzo, pali tebulo ku Excel (kapena inu mwaijambula pamenepo) ndipo tsopano mukufunika kuyisanthula ndi mzere wina / column (mwachitsanzo, tebulo ngati Fanizo 1).
Tsopano ntchito: ndibwino kuti muyipange ndi kuchulukitsa mu December.
Mkuyu. 1. Chitsanzo cha tebulo kuti musankhe
Choyamba muyenera kusankha tebulo ndi batani lamanzere: ndemanga yomwe muyenera kusankha mazenera ndi zikhomo zomwe mukufuna kufufuza (iyi ndi mfundo yofunikira: Mwachitsanzo, ngati sindinasankhe ndime A (ndi maina a anthu) ndikukonzekera ndi "December" - ndiye ziyeso kuchokera pa ndime B zikanatayika poyerekeza ndi mayina m'gawo A. Ndiko, kugwirizana kungasweka, ndipo Albina sangakhale kuchokera ku "1", koma kuchokera ku "5", mwachitsanzo).
Pambuyo posankha tebulo, pitani ku gawo lotsatira: "Deta / Sungani" (onani figani 2).
Mkuyu. 2. Mndandanda wamasewera +
Kenaka muyenera kukonza kusankha: sankhani ndime yomwe mungakonze ndikuyendetsa: kukwera kapena kutsika. Palibe chinthu chapadera kuyankhapo (onani mkuyu 3).
Mkuyu. 3. Sungani makonzedwe
Ndiye mudzawona momwe tebuloyi inakonzedweratu ndikukwera pamtundu wofunikira! Choncho, tebulo ikhoza kusankhidwa mosavuta ndi mzere uliwonse (onani mkuyu 4)
Mkuyu. 4. Zotsatira zosankha
2) Momwe mungawonjezere manambala angapo patebulo, ndondomeko ya chiwerengerocho
Komanso chimodzi mwa ntchito zotchuka kwambiri. Ganizirani momwe mungathetsere mwamsanga. Tiyerekeze kuti tikufunika kuwonjezera miyezi itatu ndikupeza ndalama zomaliza kwa ophunzira aliyense (onani f. 5).
Timasankha selo limodzi limene tikufuna kulandira (mumasamba 5 - izi zidzakhala "Albina").
Mkuyu. 5. Kusankhidwa kwa magulu
Kenaka pitani ku gawo: "Ma formula / Masamu / SUM" (ichi ndi chiwerengero chomwe chikuwonjezera maselo onse omwe mumasankha).
Mkuyu. 6. Chiwerengero cha ndalama
Kwenikweni, muwindo lomwe likuwonekera, muyenera kufotokoza (sankhani) maselo omwe mukufuna kuwonjezera. Izi zakhala zosavuta kwambiri: sankhani batani lamanzere, ndipo panikizani "Bwino" (onani tsamba 7).
Mkuyu. 7. Chidule cha maselo
Pambuyo pake, mudzawona zotsatira mu selo losankhidwa kale (onani mkuyu 7 - zotsatira zake ndi "8").
Mkuyu. 7. Zotsatira zake
Mwachidule, ndalama zoterozo zimafunikanso kwa aliyense wophunzira. Choncho, kuti musalowetsenso ndondomekoyi pamanja - mungathe kuijambula mumaselo omwe mukufuna. Ndipotu, zonse zimawoneka zophweka: sankhani selo (mkuyu 9 - iyi ndi E2), pambali ya selo iyi padzakhala tizilombo tating'ono - "tulutsani" kumapeto kwa tebulo lanu!
Mkuyu. 9. Mphindi ya mizere yotsalayo
Chotsatira chake, Excel idzawerengera kuchuluka kwa wophunzira aliyense (onani Chithunzi 10). Chilichonse chiri chosavuta komanso chokhazikika!
Mkuyu. 10. Zotsatira
3) Kuwonetsa: chotsani mizere yokha yomwe mtengo uli waukulu (kapena uli ndi ...)
Pambuyo pa chiwerengerocho, kawirikawiri, amafunikira kuchoka okhawo omwe adakwaniritsa choletsera china (mwachitsanzo, anapanga zoposa 15). Kwa Excel iyi ili ndi mbali yapadera - fyuluta.
Choyamba muyenera kusankha tebulo (onani mkuyu 11).
Mkuyu. 11. Kuwonetsa tebulo
Kuwonjezera pa mapulogalamu apamwamba lotseguka: "Deta / fyuluta" (monga Mkuputala 12).
Mkuyu. 12. Fyuluta
Ziyenera kuoneka ngati "mivi" 
. Ngati inu mutsegula pa izo, mapulogalamu a fyuluta adzatsegulidwa: mungathe kusankha, mwachitsanzo, mafayilo a nambala ndikukonzekera mizere yomwe mungasonyeze (mwachitsanzo, fyuluta "yowonjezera" idzachoka okhawo omwe ali ndi chiwerengero chachikulu mu chigawo ichi kuposa momwe mukufotokozera).
Mkuyu. 13. Zosefera
Mwa njira, zindikirani kuti fyuluta ikhoza kukhazikitsidwa pa gawo lililonse! Malo omwe pali malemba (mwa ife, maina a anthu) adzasankhidwa ndi mafayilo ena angapo: kutanthauza kuti, palibe kenanso (mofanana ndi ma filters), koma "akuyamba" kapena "ali". Mwachitsanzo, mu chitsanzo changa ndinayambitsa fyuluta kwa maina omwe ayambira ndi kalata "A".
Mkuyu. 14. Dzina lolemba lili ndi (kapena likuyamba ndi ...)
Samalani chinthu chimodzi: zipilala zomwe fyuluta imagwira zimatchulidwa mwachindunji (onani mitsinje yobiriwira pa Mkuyu 15).
Mkuyu. Fyuluta yatha
Kawirikawiri, fyuluta ndi chida champhamvu komanso chothandiza kwambiri. Pogwiritsa ntchito njirayi, kuti muthe kutsegula, pamwamba pa Excel menyu - yesani batani la dzina lomwelo.
4) Momwe mungapangire tebulo mu Excel
Kuchokera ku funso loterolo, nthawi zina ndimataika. Chowonadi ndi chakuti Excel ndi tebulo limodzi lalikulu. Zoona, ziribe malire, palibe mapepala, ndi zina zotero (monga ziri mu Mawu - ndipo izi zikusocheretsa ambiri).
Nthawi zambiri, funsoli limatanthauza kulengedwa kwa malire a tebulo (kujambula pa tebulo). Izi zapangidwa mosavuta: choyamba musankhe tebulo lonse, kenako pitani ku gawo: "Kunyumba / Mafomu monga tebulo." Muwindo lamasewera mumasankha zojambula zomwe mukufuna: mtundu wa chimango, mtundu wake, ndi zina zotero (onani mkuyu 16).
Mkuyu. 16. Pangani monga tebulo
Zotsatira za kupanga maonekedwe zikuwonetsedwa mkuyu. 17. Mu mawonekedwe awa, tebulo ili likhoza kusamutsidwa, mwachitsanzo, ku chikalata cha Mawu, kupanga chithunzi chowonekera bwino, kapena kungowonjezera pazenera pa omvera. Mu mawonekedwe awa, n'zosavuta kuti "werengani."
Mkuyu. 17. Gome lopangidwa
5) Mmene mungapangire grafu / tchati mu Excel
Kuti mumange tchati, mufunikira tebulo lokonzekera (kapena osachepera 2 ma data). Choyamba, muyenera kuwonjezera tchati, kuti muchite izi, dinani: "Dongosolo la Insert / pie / volumetric pie" (mwachitsanzo). Kusankha kwa tchati kumadalira zofunikira (zomwe mumatsatira) kapena zomwe mumakonda.
Mkuyu. 18. Ikani tchati cha pie
Kenaka mungasankhe kalembedwe ndi kapangidwe kawo. Ndikupangira kuti musagwiritse ntchito mitundu yofooka ndi yofewa (kuwala kofiira, chikasu, etc.) muzojambula. Chowonadi ndi chakuti kawirikawiri chithunzi chimapangidwa kuti chiwonetsetse - ndipo mitundu iyi sizimawoneka bwino ponse pazenera ndipo ikasindikizidwa (makamaka ngati chosindikiza si chabwino).
Mkuyu. 19. Zojambula
Kwenikweni, imangotsala kuti iwonetsetse deta ya tchati. Kuti muchite izi, dinani ndi batani lamanzere: pamwamba, mu Excel menyu, gawo la "Working with Charts" liyenera kuwonekera. M'chigawo chino, dinani "Tsamba Dongosolo" (onani Chithunzi 20).
Mkuyu. 20. Sankhani deta yanu
Kenaka sankhani ndimeyo ndi deta yomwe mukufunikira (ndi batani lamanzere) (sankhani, palibe chofunika).
Mkuyu. 21. Kusankhidwa kwa deta - 1
Kenako gwiritsani chingwe cha CTRL ndipo sankhani malembawo (mwachitsanzo) - onani mkuyu. 22. Kenako, dinani "Chabwino."
Mkuyu. 22. Kusankha kwa deta - 2
Muyenera kuwona chithunzi chojambula (onani tsamba 23). Mu mawonekedwe awa, ndizosangalatsa kufotokoza zotsatira za ntchito ndikuwonetsa momveka bwino nthawi zina.
Mkuyu. 23. Chithunzi chotsatira
Kwenikweni, pa chithunzichi ndi chithunzichi ndikufotokoza mwachidule zotsatira. M'nkhani imene ndasonkhanitsa (ikuwoneka ngati ine), mafunso ofunika kwambiri omwe amapezeka kwa ogwiritsa ntchito ntchito. Pokhala mutagwirizana ndi zigawo izi - inu nokha simudzawona mmene "chips" zatsopano ziyamba kuyendera mwamsanga ndi mofulumira.
Podziwa kugwiritsa ntchito njira zowonjezera 1-2, njira zina zambiri zidzakhala "kulengedwa" mwanjira yomweyo!
Kuonjezera apo, ndikupangira oyamba kumene nkhani ina:
Mwamwayi 🙂
