Omunye wemibuzo abasebenzisi abaningi abazibuza yona lapho besebenza nama-spreadsheet ngu- ungayilungisa kanjani ikholomu ehamba phambili. Futhi hhayi kuphela amakholomu, kepha futhi nemigqa namaseli. Umbuzo uvela ikakhulukazi lapho usebenza ngenani elikhulu lemininingwane futhi kufanele ubuyele kaninginingi kukholamu / umugqa / iseli lesethenjwa.
Imvamisa lawo esifuna ukuthi abonakale ngaso sonke isikhathi amakholomu nemigqa equkethe izihloko noma izihloko, yize leli qhinga lingasetshenziswa neminye imigqa namakholomu (akudingeki ukuthi kube ngeyokuqala).
Ngaphandle kokusebenzisa indlela yokulungisa ikholomu ye-Excel, ukusebenza ngamaspredishithi kungahamba kancane, kube yisidina futhi kungasheshi. Ngisho ukucasula ngezinye izikhathi. Siyaphoqeleka ukuthi siqhubeke sisebenzise i- pheqa, ukunyakazisa i-blade phezulu naphansi noma eceleni, kuchitha isikhathi esiningi. Futhi isikhathi yinto okungekho muntu okufanele ayigodle.
Ngakho-ke sizochaza ukuthi sikwenza kanjani lokhu kusebenza okulula namandla ngale ndlela sebenza ku Excel ngendlela enethezeke kakhudlwana futhi ephumelelayo.
Lungisa ikholomu ku-Excel
Ukusebenza kokulungisa ikholomu ye-Excel kule hlelo kusukela kunguqulo yayo yonyaka 2007. Isingeniso sayo saba usizo olukhulu kubasebenzisi abasebenza ngamaspredishithi amakhulu futhi baphatha idatha eningi. Futhi kusenjalo nanamuhla. Icebo elandisa umkhiqizo wethu.
Ukwenza kusebenze kahle, lezi yizinyathelo okufanele zilandelwe:
Ukuchofoza inketho ethi "Buka" kuvula izinketho ezintathu zokubamba amakholomu, imigqa namapaneli.
Okokuqala, sichofoza kuthebhu "Ukubona" lokho kuvela phezulu kuspredishithi, lapho wonke amathuluzi aboniswa khona. Lapho sinezinketho ezintathu:
-
- Friza umugqa ophezulu. Ngale nketho umugqa wokuqala wespredishithi "uqandisiwe", ozohlala umile futhi ubonakale ngenkathi sihamba sibheke eshidini.
- Friza ikholomu yokuqala. Isebenza njengenketho yangaphambilini, igcina ikholomu yokuqala yespredishithi ilungisiwe futhi ibukwa ngenkathi siskrola ngokuvundlile kudokhumenti.
- Friza amaphaneli. Le nketho iyinhlanganisela yezimbili ezedlule. Kuyasisiza ukudala ukwahlukana ngokuya ngeseli ebesilikhethe ngaphambilini. Yiyo okufanele siyikhethe uma sifuna ukufriza noma ukulungisa imigqa namakholomu ngasikhathi sinye. Futhi esimweni lapho umugqa noma ikholomu esihlose ukuyisetha akuyona eyokuqala.
Ngokuya ngomsebenzi ozowenza, kufanele ukhethe okukodwa kokukhethwa kukho ezintathu.
Imigqa namakholomu ahlala amisiwe ahlukaniswa ngu umugqa ojiyile weseli obamaka. Kubalulekile ukwazi ukuthi ukulungisa amakholomu we-Excel (noma imigqa noma amapaneli) kuyinsiza yokubona. Ngamanye amazwi, imigqa namakholomu akashintshi isikhundla yoqobo ngaphakathi kwesipredishithi sethu, zibonakala kuphela zibonakala ukusisiza.
Lapho umsebenzi usuphelile, singabuyela emuva "Dedela" imigqa namakholomu afriziwe. Ngalokhu, kuzodingeka ukuthi siphinde singene ku- «Buka» iwindi futhi futhi sisebenzise inketho ebesikhethe phambilini.
Hlukanisa iwindi ku-Excel
Njengoba sibonile, inhloso yokulungisa ikholomu ye-Excel akuyona enye ngaphandle kokwenza lula umsebenzi ngamaspredishithi ngokusebenzisa umbono ocacile futhi onethezekile wedokhumenti. Kepha akulona iqhinga kuphela elizosisiza. Ngokuya ngohlobo lwedokhumende noma umsebenzi, kungasebenza kakhulu inketho yokuhlukanisa iwindi le-Excel.
Ngabe lokhu kusebenza kuqukethe ini? Ngokuyinhloko kumayelana nokuhlukanisa isikrini sespredishithi ukuze thola ukubukwa okuhlukile kwedokhumenti efanayo. Isibonelo, esikrinini esisodwa singabona ikholomu yokuqala nayo yonke imininingwane equkethe, ngenkathi esikrinini sesibili singaphenya kulo lonke idokhumenti.
Isikrini se-Excel sihlukaniswe kabili
Ake sibone ukuthi le nketho ingasetshenziswa kanjani ku-Microsoft Excel:
- Into yokuqala okufanele uyenze, njengokukhethwa kukho kwangaphambilini, kuthebhu "Ukubona".
- Lapho kufanele ukhethe inketho "Hlukanisa". Isikrini sizohlukaniswa ngokuzenzekelayo sibe imikhakha emine.
Ngale ndlela sizothola imibono emine ehlukene yedokhumenti efanayo, ukuze sisebenze ngamunye ngamunye. Futhi ngaphandle kokusebenzisa i- pheqa kaninginingi ukuzulazula phezu kwaso.
Futhi uma izikrini ezine ziningi kakhulu (kwesinye isikhathi ngokuzama ukwenza izinto zibe lula sigcina sizixaka ngokwengeziwe), kunezinye izindlela vele usebenze nesikrini sihlukaniswe kabili. Kulokhu kufanele siqhubeke kanjena:
- Ake sibuyele emuva "Ukubona", yize kulokhu sikhethe inketho ye- "Iwindi elisha".
- Okwamanje singakhetha izindlela ezimbili: "Ukubuka okufanayo" noma okunye "Hlela konke«. Kokubili, isikrini sizovela sihlukaniswe kabili, noma ngabe sikhethe inketho yesibili singakhetha phakathi kwezindlela eziningi zokubonisa: enezingqimba, mpo, KaMose noma cascading. Ngokuthanda kwethu.