Sawubona
Kusukela ekuhlangenwe nakho kwami ngizosho into ecacile: abasebenzisi abaningi abasebenzisa i-novice bayathandeka kakhulu i-Excel (futhi ngithi banganandaba kakhulu). Mhlawumbe ngigweba ngokuhlangenwe nakho kwami (lapho ngingenakwengeza izinombolo ezingu-2 ngaphambili) futhi angicabangi ukuthi kungani ngidinga i-Excel, bese ngiba ngumsebenzisi "ongenasidingo" ku-Excel - Ngikwazi ukuxazulula izikhathi eziningana okusheshayo engangijwayele ukucabanga ngakho "
Inhloso yalesi sihloko akugcini nje ukubonisa indlela yokwenza isenzo esithile, kodwa futhi ukukhombisa amathuba okuba khona kohlelo lwabasebenzisi besikhombisi abangazi lutho ngabo. Ngempela, unayo ngisho namakhono okuqala okusebenza ku-Excel (njengoba ngishilo ekuqaleni) - ungasheshisa umsebenzi wakho izikhathi eziningana!
Izifundo ziyimfundo encane yokwenza isenzo. Ngakhetha izihloko zezifundo ngesisekelo semibuzo engivame ukuphendula.
Izihloko zezifundo: ukuhlunga uhlu ngekholomu edingekayo, izinombolo zokubamba (sum sum), ukuhlunga imigqa, ukudala itafula ku-Excel, ukudala igrafu (ishadi).
I-Excel 2016 Tutorials
1) Indlela yokuhlunga uhlu lwama-alfabhethi, ekukhuphukeni kwe-oda (ngokusho ikholomu / ikholomu oyidingayo)
Imisebenzi enjalo ivame ukuhlangana. Isibonelo, kunetafula ku-Excel (noma uyikopishe khona) futhi manje udinga ukuyihlunga ngenye ikholomu / ikholomu (isibonelo, itafula elifana noFi. 1).
Manje umsebenzi: kungaba kuhle ukuyihlunga ngokukhula kwezinombolo ngoDisemba.
Umdwebo. 1. Ithebula lesampula lokuhlunga
Okokuqala udinga ukukhetha ithebula ngenkinobho yegundane lesokunxele: inothi oyidingayo ukukhetha amakholomu namakholomu ofuna ukuwahlunga (leli phuzu elibalulekile: isibonelo, uma ngingakhethi ikholomu A (ngamagama abantu) futhi uhlele ngo "Disemba" - ke izindinganiso ezivela kukholomu B zizolahleka zihlobene namagama kukholomu A. Okungukuthi, ukuxhumeka kuzophulwa, futhi u-Albina ngeke abe "1", kodwa kusukela "ku-5", isibonelo).
Emva kokukhetha itafula, iya esigabeni esilandelayo: "Idatha / Hlela" (bheka umkhiwane 2).
Umdwebo. 2. Ukukhethwa kwethebula + ukukhetha
Khona-ke udinga ukulungisa ukuhlunga: khetha ikholomu okufanele uhlele futhi uqondise: ukukhuphuka noma ukwehla. Akukho lutho olukhethekile lokuphawula ngalo (bheka Fig. 3).
Umdwebo. 3. Hlunga izilungiselelo
Khona-ke uzobona ukuthi itafula lihlelwe kanjani ngqo likhuphuka ngekholomu elifunayo! Ngakho-ke, itafula lingasetshenziswa ngokushesha futhi kalula nganoma iyiphi ikholomu (bheka Fig. 4)
Umdwebo. 4. Umphumela wokuhlunga
2) Indlela yokwengeza izinombolo eziningana etafuleni, ifomula yesamba
Futhi omunye wemisebenzi ethandwa kakhulu. Cabanga indlela yokuxazulula ngayo ngokushesha. Ake sithi kudingeka sengeze izinyanga ezintathu futhi sithole inani lokugcina lomhlanganyeli ngamunye (bheka, isib. 5).
Sakhetha isisodwa esisodwa esifuna ukuthola isamba (esithombeni 5 - lokhu kuzoba "u-Albina").
Umdwebo. Ukukhethwa kweselula
Okulandelayo, iya esigabeni: "Amafomula / iMathematika / i-SUM" (lokhu kuyimfomula yesamba eseza zonke amangqamuzana ozikhethayo).
Umdwebo. 6. Inani lemali
Eqinisweni, efasiteleni elibonakalayo, udinga ukucacisa (khetha) amaseli ofuna ukuwafaka. Lokhu kwenziwa kalula: khetha inkinobho yegundane lesokunxele bese ucindezela inkinobho ethi "Kulungile" (bheka.
Umdwebo. 7. Isibalo samaseli
Ngemuva kwalokho, uzobona umphumela kuseli elikhethiwe ngaphambilini (bheka Fig. 7 - umphumela "8").
Umdwebo. 7. Umphumela wokubamba
Ngokwalokho, inani elinjalo ngokuvamile lidingwa kumhlanganyeli ngamunye etafuleni. Ngakho-ke, ukuze ungafaki ifomula futhi ngesandla - ungamane ulikopishe kumaseli afunayo. Eqinisweni, konke kubonakala kulula: khetha iseli (ku-Fig. 9 - lokhu ku-E2), ekhoneni laleli seli kuzodingeka i-rectangle encane - "uyihudule" kuze kube sekupheleni kwetafula lakho!
Umdwebo. 9. Isibalo semigqa esele
Ngenxa yalokho, i-Excel izobala inani lomhlanganyeli ngamunye (bheka Umfanekiso 10). Konke kulula futhi kuyashesha!
Umdwebo. Umphumela
3) Ukuhlunga: shiya kuphela leyo migqa lapho inani elikhulu (noma lapho liqukethe ...)
Ngemuva kokuthi isibalo sibalwa, kudingeke ukuba ushiye kuphela labo abaye bafeza isivinini esithile (isibonelo, okwenziwe ngaphezulu kuka-15). Kule Excel inesici esikhethekile - isihlungi.
Okokuqala kudingeka ukhethe ithebula (bheka Fig. 11).
Umdwebo. 11. Ukukhanyisa itafula
Ngokuqhubekayo kwimenyu evulekile evulekile: "Idatha / isihlungi" (njengokwes Fig. 12).
Umdwebo. 12. Isihlungi
Kufanele avele "imicibisholo" encane 
. Uma uchofoza kuso, imenyu yokuhlunga iyovula: ungakhetha, isibonelo, izihlungi zenombolo bese ulungisa ukuthi yiziphi imigqa ezizobonisa (isibonelo, "isihlungi" esengeziwe sizoshiya kuphela labo abanenombolo enkulu kule kholomu ongashiwo).
Umdwebo. 13. Izilungiselelo zohlunga
Ngendlela, phawula ukuthi isihlungi singasethwa kukholomu ngayinye! Ikholomu lapho kukhona idatha yombhalo (kithi, amagama abantu) izohlungwa ngezinye izihlungi eziningana: okungukuthi, akukho okunye nangaphansi (njengokungathi kuhlungi lwamanani), kodwa "uqala" noma "uqukethe". Isibonelo, kusibonelo sami ngethula isihlungi samagama aqala ngencwadi ethi "A".
Umdwebo. 14. Igama lombhalo liqukethe (noma liqala nge ...)
Qaphela into eyodwa: amakholomu lapho isihlungi sisebenza khona sibhalwe ngendlela ekhethekile (bheka imicibisholo eluhlaza kuFi. 15).
Umdwebo. Isihlungi sigcwalisiwe
Ngokuvamile, isihlungi ithuluzi elinamandla kakhulu nelusizo. Ngendlela, ukuze uyikhiphe, nje kwimenyu ephezulu ye-Excel - cindezela inkinobho yegama elifanayo.
4) Indlela yokudala itafula ku-Excel
Kusukela kumbuzo onjalo, ngezinye izikhathi ngilahleka. Iqiniso liwukuthi i-Excel iyithebula elilodwa elikhulu. Kuyiqiniso, ayikho imikhawulo, ayikho isakhiwo sephepha, njll (njengoba kuseZwini - futhi lokhu kuyakhohlisa abaningi).
Ngokuvamile, lo mbuzo ubonisa ukudalwa kwemida yetafula (ukufometha kwetafula). Lokhu kwenziwa kalula: kuqala ukhethe ithebula lonke, bese uye esigabeni: "Ikhaya / Ifomethi njengetafula." Esikhathini sewindi le-pop-up ukhetha ukuklama okudingayo: uhlobo lohlaka, umbala walo, njll (bheka umkhiwane 16).
Umdwebo. 16. Fometha njengetafula
Umphumela wokufometha uboniswa kuFi. 17. Kuleli fomu, leli tafula lingadluliselwa, isibonelo, kumadokhumenti eWiki, yenza isithombe esicacile salo, noma umane usibeke esikrinini sabathengi. Kule fomu, kulula kakhulu "ukufunda."
Umdwebo. 17. Ithebula elifomethiwe
5) Indlela yokwakha igrafu / ishadi ku-Excel
Ukuze wakhe ishadi, uzodinga ithebula elenziwe ngomumo (noma okungenani amakholomu amabili wedatha). Okokuqala, udinga ukwengeza ishadi, ukwenza lokhu, chofoza: "Faka ishadi / i-pie / volumetric pie ishadi" (isibonelo). Ukukhethwa kweshadi kuxhomeke kuzidingo (okulandelayo) noma okuthandayo.
Umdwebo. 18. Faka ishadi lephayi
Khona-ke ungakhetha isitayela nesakhiwo sakhe. Ngincoma ukuthi ungasebenzisi imibala ebuthakathaka futhi enombala (pink elula, ophuzi, njll) kwimidwebo. Iqiniso liwukuthi ngokuvamile umdwebo wenziwa ukuwukhombisa - futhi le mibala ayibonanga kahle kokubili esibukweni futhi uma iphrintiwe (ikakhulukazi uma iphrinta engeyona engcono kakhulu).
Umdwebo. 19. Umbala wokuklama
Eqinisweni, ihlala kuphela ukucacisa idatha yeshadi. Ukwenza lokhu, chofoza kukho inkinobho yegundane lesokunxele: phezulu, kwimenyu ye-Excel, isigaba esithi "Ukusebenza Nge-Charts" kufanele sivele. Kulesi sigaba, chofoza ithebhu ethi "Khetha Idatha" (bheka Umfanekiso 20).
Umdwebo. 20. Khetha idatha yeshadi
Bese ukhetha nje ikholomu nedatha oyidingayo (ngenkinobho yegundane lesokunxele) (khetha nje, akukho okunye okudingekayo).
Umdwebo. 21. Ukukhethwa komthombo wedatha - 1
Bese ubamba ukhiye we-CTRL bese ukhetha ikholomu ngamagama (isibonelo) - bheka umkhiwane. 22. Okulandelayo, chofoza "Kulungile."
Umdwebo. 22. Ukukhethwa komthombo wedatha - 2
Kufanele ubone umdwebo odwetshiwe (bheka umkhiqizo 23). Kule fomu, kulula kakhulu ukuhlanganisa imiphumela yomsebenzi futhi ubonise ngokucacile ukuthi uhlala njalo.
Umdwebo. 23. Umdwebo ophumela
Empeleni, kulokhu nakulo mdwebo ngizofingqa imiphumela. Esihlokweni engiqoqe (kubonakala kimi), yonke imibuzo eyisisekelo ephakanyiselwa abasebenzisi besikhombisi. Ngemva kokubhekana nalezi zici eziyisisekelo - wena ngokwakho ngeke uqaphele ukuthi lezi "chips" ezintsha zizoqala ukuhlola ngokushesha futhi ngokushesha.
Njengoba ufunde ukusebenzisa amafomula angu-1-2, amanye amafomula amaningi "azodalwa" ngendlela efanayo!
Ngaphezu kwalokho, ngincoma abaqalekisi enye i-athikili:
Inhlanhla 🙂
