Sawubona.
Ngokwazi kwami engizokusho ngizokusho into eyodwa esobala: abasebenzisi abaningi be-novice ababukeli phansi i-Excel (futhi, ngingathi, bayayibukela phansi kakhulu). Mhlawumbe ngizahlulela ngokwazi kwami (lapho ngangehluleka ukufaka izinombolo ezi-2 ngaphambili) futhi angicabanganga ukuthi kungani i-Excel idingeka, bese ngiba umsebenzisi "wesandla esiphakathi" ku-Excel - ngikwazi ukuxazulula imisebenzi esheshayo ephindwe kayishumi ebengihlala kuyo futhi ngicabanga "...
Inhloso yalesi sihloko: hhayi ukukhombisa ukuthi ungasenza kanjani lesi senzo noma leso senzo, kodwa futhi ukukhombisa izici ezingaba khona zohlelo lwabasebenzisi be-novice abangazi ngisho nangabo. Ngemuva kwakho konke, ukuba namakhono ayisisekelo kakhulu e-Excel (njengoba ngishilo ngaphambili) - ungasheshisa umsebenzi wakho kaningana!
Izifundo zingumyalo omfushane ekusebenzeni kwesenzo. Ngikhethe izihloko zezifundo ngokwami, ngokuya ngemibuzo engivame ukuphendula ngayo.
Izindikimba zezifundo: ukuhlunga uhlu ngekholomu oyifunayo, ukungeza izinombolo (ifomula yama-sum), imigqa yokuhlunga, ukudala itafula ku-Excel, ukudweba igrafu (ishadi).
Okokufundisa Oku-Excel 2016
1) Ungaluhluza kanjani uhlu ngokwe-alfabhethi, ukhuphuka (ikholamu / ikholomu edingekayo)
Izinkinga ezinje zivame kakhulu. Isibonelo, kunethebula ku-Excel (noma ulikopishe lapho) futhi manje udinga ukulihlunga ngekholamu / ikholomu ethile (isibonelo, itafula elifana noMfanekiso 1).
Manje umsebenzi: kungaba kuhle ukuwuhlela ngokwenyuka amanani ngoDisemba.
U-fig. 1. Ithebula lesampula lokuhlunga
Okokuqala udinga ukukhetha itafula ngenkinobho yegundane kwesobunxele: Qaphela ukuthi udinga ukukhetha amakholomu namakholomu ofuna ukuwahlela (leli phuzu elibalulekile: ngokwesibonelo, ukube angikhethanga ikholomu A (enamagama abantu) futhi ihlelwe “ngoDisemba” - khona-ke amanani avela kukholamu B azolahleka ngokuhambisana namagama asekholamu A. Okusho ukuthi, izixhumanisi bezizophulwa, bese u-Albina engeke abe no- "1", kepha nge "5", ngokwesibonelo).
Ngemuva kokukhetha itafula, iya esigabeni esilandelayo: "Idatha / Hlunga" (bheka. Fig. 2).
U-fig. 2. Ukukhetha kwetafula + ukuhlunga
Ngemuva kwalokho udinga ukulungiselela ukuhlelwa kokukhetha: khetha ikholomu ongayihlunga nokuqondisa: ukhuphuka noma wehla. Akukho okukhethekile ukuphawula ngalo (bheka umdwebo 3).
U-fig. 3. Hlunga izilungiselelo
Okulandelayo uzobona ukuthi itafula lahlelwa kanjani ngokuqinisekile likhuphuka yikholomu oyifunayo! Ngakho-ke, itafula lingaxazululwa ngokushesha futhi kalula nganoma iyiphi ikholamu (bheka Fig. 4)
U-fig. 4. Hlunga umphumela
2) Ungazifaka kanjani izinombolo ezimbalwa etafuleni, ifomula yesamba
Futhi omunye wemisebenzi edumile. Cabanga ukuthi ungayixazulula kanjani ngokushesha. Ake sithi kudingeka sengeze izinyanga ezintathu futhi sithole inani lalowo ohlanganyele (bheka umdwebo 5).
Khetha iseli elilodwa esifuna ukuthola inani kulo (ku-Fig. 5 - lizoba yi- "Albina").
U-fig. 5. Ukukhetha kweseli
Okulandelayo, iya esigabeni: "Amafomula / izibalo / i-SUM" (le ifomula yesamba ezohlanganisa wonke amaseli owakhethile).
U-fig. 6. Inani lefomula
Empeleni, ewindini elivele, udinga ukucacisa (ukugqamisa) amaseli ofuna ukuwafaka. Lokhu kwenziwa kalula nje: khetha inkinobho yegundane kwesobunxele bese ucindezela inkinobho ethi "Kulungile" (bheka. Fig. 7).
U-fig. 7. Ingqamuzana lamaseli
Ngemuva kwalokho, uzobona umphumela kuseli elikhethwe ngaphambilini (bheka. Umd. 7 - umphumela ngu- "8").
U-fig. 7. Umphumela wenani
Ngomqondo, inani elinjalo livame ukudingeka kumhlanganyeli ngamunye etafuleni. Ngakho-ke, ukuze ungafaki ifomula futhi ngesandla, ungamane ukopishe kumaseli owathandayo. Eqinisweni, konke kubukeka kulula: khetha iseli (ku-Fig. 9 yi-E2), kuzoba noxande oluncane ekhoneni lalesi sitokisi - “yelula” kuze kube sekupheleni kwetafula lakho!
U-fig. 9. Isamba semigqa esele
Ngenxa yalokhu, i-Excel izobala inani lomuntu ngamunye obambe iqhaza (bheka. Umdwebo 10). Konke kulula futhi kushesha!
U-fig. 10. Umphumela
3) Ukuhlunga: shiya kuphela leyo migqa lapho inani likhulu khona (noma lapho liqukethe ...)
Ngemuva kokuthi inani libaliwe, kaningi kakhulu, kuyadingeka ukushiya kuphela labo abaye baqeda isithiyo esithile (ngokwesibonelo, esenziwe ngaphezu kwe-15). Kulokhu, i-Excel inesici esikhethekile - isihlungi.
Okokuqala udinga ukukhetha itafula (bheka. Fig. 11).
U-fig. 11. Ukukhetha kwetafula
Ngemuva kwalokho vula imenyu ephezulu: "Idatha / Isihlungi" (njengaku-Fig. 12).
U-fig. 12. Hlunga
Imicibisholo emincane kufanele ivele . Uma uchofoza kukho, imenyu yokuhlunga iyavula: ungakhetha, isibonelo, izihlungi zamanani bese ulungiselela ukuthi imiphi imigqa yokubonisa (ngokwesibonelo, isihlungi "esengeziwe" sizoshiya imigqa kuphela lapho kuzoba nezinamba eziningi kule kholamu kunalokho oyicacisile).
U-fig. 13. Izilungiselelo zokuhlunga
Ngendlela, qaphela ukuthi isihlungi singasethwa ikholomu ngayinye! Ikholomu lapho kunemininingwane yombhalo (kithi, amagama abantu) izohlungwa ngamanye amafiltha ambalwa: okuwukuthi, akusekho okuncane futhi okuncane (njengasekuhlungweni kwezinombolo), kepha "kuyaqala" noma "kuqukethe". Isibonelo, ngokwesibonelo sami, ngethula isihlungi samagama aqala ngohlamvu oluthi "A".
U-fig. 14. Umbhalo wegama uqukethe (noma uqala nge ...)
Naka iphuzu elilodwa: amakholomu lapho kusebenza khona isihlungi kumakwe ngendlela ekhethekile (bheka imicibisholo eluhlaza ku-Fig. 15).
U-fig. 15. Ukuhlunga kuqediwe
Ngokuvamile, isihlungi siyithuluzi elinamandla futhi eliwusizo. Ngendlela, ukuze uyicishe, vele ucindezele inkinobho yegama elifanayo kwimenyu ephezulu ye-Excel.
4) Ungawakha kanjani itafula ku-Excel
Ukusuka kumbuzo onjalo, kwesinye isikhathi ngiyalahleka. Iqiniso ngukuthi i-Excel yithebula elilodwa elikhulu. Kuliqiniso, ayinayo imingcele, akunakubekwa kweshidi, njll (njengoba kunjalo eZwini - futhi lokhu kudukisa abaningi).
Kaningi kunokuthi, lo mbuzo usho ukudala imingcele yetafula (ukufometha kwetafula). Lokhu kwenziwa kalula: qala ukhethe itafula lonke, bese uye esigabeni: "Ikhaya / Ifomethi njengethebula". Ewindows pop-up, ukhetha umklamo owudingayo: uhlobo lohlaka, umbala walo, njll. (Bheka. Fig. 16).
U-fig. 16. Fometha njengetafula
Umphumela wokufometha uboniswa ku-Fig. 17. Kuleli fomu, leli tafula lingadluliselwa, ngokwesibonelo, kudokhumenti le-iZwi, lenziwe isithombe-skrini salo, noma limakwe nje esikrinini izilaleli. Ngale fomu, kulula kakhulu "ukufunda."
U-fig. 17. Itafula elakhiwe
5) Ungayakha kanjani igrafu / ishadi ku-Excel
Ukwakha ishadi, uzodinga itafula elenziwe ngomumo (noma okungenani amakholomu edatha angu-2). Okokuqala, udinga ukufaka umdwebo, ngoba lokhu kuchofoza: "Faka / ipayi / ishadi lephayi yevolumu" (ngokwesibonelo). Ukuzikhethela kweshadi kuya ngezidingo (ozilandelayo) noma okuthandayo.
U-fig. 18. Faka ishadi likaphayi
Ngemuva kwalokho ungakhetha isitayela nokuklama kwakhe. Ngincoma ukuthi ungasebenzisi imibala ebuthakathaka futhi ibuthaka kumidwebo (ukukhanya okupinki, ophuzi, njll.). Iqiniso ngukuthi imvamisa kwenziwa umdwebo ukuze uyikhombise - kanti le mibala ayibonwa kahle esibukweni nalapho iphrinta (ikakhulukazi uma iphrinta ingeyona ehamba phambili).
U-fig. 19. Isikimu sombala
Empeleni, kuhlala kuphela ukukhombisa idatha eshadini. Ukuze wenze lokhu, chofoza ngakwesobunxele kukho: ngaphezulu, kumenyu ye-Excel, kufanele kuvele isigaba esithi "Work With Charts". Kulesi sigaba, khetha ithebhu "Khetha Idatha" (bheka Umdwebo 20).
U-fig. 20. Khetha idatha eshadini
Bese uchofoza ngakwesobunxele kwikholamu nedatha oyidingayo (vele uyikhethe, awudingi ukuthi uchofoze okunye).
U-fig. 21. Ukukhethwa komthombo wedatha - 1
Ngemuva kwalokho bamba ukhiye we-CTRL bese ukhetha ikholomu enamagama (ngokwesibonelo) - bheka umkhiwane. 22. Bese uqhafaza "Kulungile."
U-fig. 22. Ukukhethwa komthombo wedatha - 2
Kufanele ubone umdwebo owakhiwe (bheka ku-Fig. 23). Kuleli fomu, kulula kakhulu ukufingqa umsebenzi futhi kukhombise ngokusobala ukwenzeka okuthile.
U-fig. 23. Ishadi eliphumela
Empeleni, kulokhu nakulo mdwebo ngizofingqa. Ku-athikili engiqoqe (njengoba kubonakala kimi), yonke imibuzo eyisisekelo ephakama yabasebenzisi be-novice. Ngemuva kokuthola lezi zici eziyisisekelo, ngokwakho ngeke uqaphele ukuthi uzoqala kanjani ukufunda “amaqhinga” amasha ngokushesha nangokushesha.
Ngokufunda ukusebenzisa amafomula angu-1-2, amanye amafomula amaningi "azokwakhelwa" ngendlela efanayo!
Ngaphezu kwalokho, ngincoma kwabaqalayo esinye i-athikili: //pcpro100.info/kak-napisat-formulu-v-excel-obuchenie-samyie-nuzhnyie-formulyi/
Inhlanhla 🙂
