Ukusebenza ku-Microsoft Excel, okubaluleke kakhulu kuqala ukuthi ufunde ukufaka imigqa namakholomu etafuleni. Ngaphandle kwaleli khono, cishe akunakwenzeka ukusebenza ngedatha ye-tabular. Ake sibheke ukuthi singeza kanjani ikholomu ku-Excel.
Isifundo: Ungayifaka kanjani ikholamu kuspredishithi seMicrosoft Word
Faka ikholomu
E-Excel, kunezindlela eziningi zokufaka ikholomu eshidini. Iningi lazo lilula impela, kepha umsebenzisi we-novice kungenzeka angakuqondi konke ngokushesha. Ngaphezu kwalokho, kukhona inketho yokufaka ngokuzenzakalela imigqa kwesokudla kwetafula.
Indlela yoku-1: faka ngokusebenzisa iphaneli yokuhlanganisa
Enye yezindlela ezilula zokufaka ukufaka iphaneli yokuqondisa ye-Excel ovundlile.
- Sichofoza kuphaneli yokuqondisa evundlile enamagama wekholamu emkhakheni kwesokunxele lapho ufuna ukufaka ikholamu. Kulokhu, ikholamu liqokonyiswe ngokuphelele. Qhafaza kwesokudla. Kumenyu evelayo, khetha Namathisela.
- Ngemuva kwalokho, ngokushesha kufakwa ikholomu entsha kwesobunxele sendawo ekhethiwe.
Indlela 2: engeza amaseli ngemenyu yokuqukethwe
Ungawenza lo msebenzi ngendlela ehluke kakhulu, okungukuthi ngemenyu yokuqukethwe yeseli.
- Sichofoza kunoma yisiphi iseli elise kholamu ngakwesokudla kwekholomu ehlelelwe ukungezwa. Sichofoza kule nto ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe evela, khetha "Namathisela ...".
- Okwamanje ukungezwa akwenzeki ngokuzenzakalelayo. Kuvulwa iwindi elincane lapho udinga ukucacisa khona ukuthi umsebenzisi uzofaka ini ngempela:
- Ikholomu
- Intambo;
- Iseli ngokushintsha phansi;
- Iseli elisekudla liye kwesokudla.
Sishintsha switch siye esikhundleni Ikholomu bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalezi zinyathelo, kuzongezwa ikholamu.
Indlela 3: Inkinobho YeRibbon
Amakholomu angafakwa usebenzisa inkinobho ekhethekile kubambo.
- Khetha iseli ngakwesobunxele ohlela ukufaka ikholamu. Ukuba kuthebhu "Ikhaya", chofoza isithonjana ngesimo sonxantathu olungene ngaphakathi esenkingeni Namathisela ebhokisini lamathuluzi "Amaseli" ekhasethini. Kumenyu evulayo, khetha Faka Amakholomu ngeshidi ngalinye.
- Ngemuva kwalokho, ikholomu izongezwa ngakwesobunxele sento ekhethiwe.
Indlela 4: faka ama-hotkeys
Ungangeza futhi ikholamu entsha usebenzisa ama-hotkeys. Ngaphezu kwalokho, kunezindlela ezimbili ongazengeza
- Enye yazo ifana nendlela yokuqala yokufaka. Udinga uchofoze lo mkhakha kuphaneli yokuqondisa evundlile etholakala ngakwesokunene sendawo efakiwe ehlongozwayo bese uthayipha kwinhlanganisela yokhiye I-Ctrl ++.
- Ukuze usebenzise inketho yesibili, kufanele uchofoze kunoma isiphi iseli kwikholamu kwesokudla kwendawo yokufaka. Bese uthayipha kukhibhodi I-Ctrl ++. Ngemuva kwalokho, lelo windi elincane lizovela nokukhethwa kohlobo lokufaka oluchazwe ngendlela yesibili yokwenza ukuhlinzwa. Izenzo ezengeziwe ziyafana impela: khetha into Ikholomu bese uchofoza inkinobho "Kulungile".
Isifundo: Izitolo ezishisayo
Indlela yesi-5: Faka Amakholomu Amaningi
Uma ufuna ukufaka amakholomu ambalwa ngasikhathi sinye, khona-ke e-Excel asikho isidingo sokwenza umsebenzi ohlukile wento ngayinye, ngoba le nqubo ingahlanganiswa yenze isenzo esisodwa.
- Kufanele uqale ukhethe amaseli amaningi emugqeni ovundlile noma imikhakha yephaneli yokuhlanganisa njengoba amakholomu amaningi edinga ukungezwa.
- Ngemuva kwalokho sebenzisa isenzo esisodwa ngemenyu yokuqukethwe noma usebenzisa izinkinobho ezishisayo ezichazwe ngezindlela ezedlule. Inani elihambisanayo lekholomu lizongezwa ngakwesobunxele sendawo ekhethiwe.
Indlela 6: engeza ikholamu ekugcineni kwetafula
Zonke izindlela ezingenhla zilungele ukwengeza amakholomu ekuqaleni naphakathi kwetafula. Ungawasebenzisa futhi ukufaka amakholamu ekugcineni kwetafula, kepha kulokhu kuzofanela ukufometha kahle. Kepha kunezindlela zokufaka ikholamu ekugcineni kwetafula ukuze kubonakale ngokushesha ngohlelo njengengxenye yalo ngokushesha. Ukuze wenze lokhu, udinga ukwenza itafula elibizwa ngokuthi “smart”.
- Sikhetha ibanga lethebula esifuna ukuliguqula libe yitafula “elihle”.
- Ukuba kuthebhu "Ikhaya"chofoza inkinobho "Fometha njengetafula"etholakala kwibhulokhi yamathuluzi Izitayela ekhasethini. Kuluhlu olwehliswayo, khetha eyodwa yohlu olukhulu lwezitayela zokuklama kwetafula ngokubona kwethu.
- Ngemuva kwalokho, kuvulwa iwindi lapho kuboniswa khona izixhumanisi zendawo ekhethiwe. Uma ukhethe okuthile ngokungalungile, khona-ke lapha ungenza ukuhlela. Into esemqoka edinga ukwenziwa ngalesi sinyathelo ukubheka ukuthi ngabe uphawu lokuhlola luyahlolwa eduze kwepharamitha Ithebula Lokuqondisa. Uma itafula lakho linonhlokweni (futhi ezimeni eziningi likhona), kepha akukho luphawu lokuhlola le nto, khona-ke kuzodingeka ulufake. Uma wonke amasethingi esethwe kahle, mane uchofoza inkinobho "Kulungile".
- Ngemuva kwalezi zenzo, ibanga elikhethiwe lahlelwa njengethebula.
- Manje, ukuze kufakwe ikholomu entsha kuleli thebula, kwanele ukugcwalisa noma isiphi iseli ngakwesokunene saso nedatha. Ikholomu elitholakala kulo leli seli liba yithebula ngokushesha.
Njengoba ukwazi ukubona, kunezindlela eziningi zokufaka amakholomu amasha kwiphepha lokusebenzela le-Excel, kokubili phakathi kwetafula namabanga aphezulu. Ukwenza ukwengeza kube lula futhi kube lula ngangokunokwenzeka, kungcono ukudala itafula elibizwa ngokuthi le-smart. Kulokhu, lapho kungezwa idatha kububanzi ngakwesokudla kwetafula, izofakwa ngokuzenzakalelayo kuyo ngendlela yekholamu entsha.
