I-Excel

Esinye sezici ezithakazelisayo kunazo zonke ku-Microsoft Excel nguSesha isisombululo. Noma kunjalo, kufanele kuqashelwe ukuthi leli thuluzi alikwazi ukubhekwa kubasebenzisi abadume kakhulu kulolu hlelo lokusebenza. Futhi kuyize. Phela, lo msebenzi, usebenzisa idatha yangempela, nge-iteration, uthola isisombululo esihle kunawo wonke sawo wonke.

Ukubingelela kubo bonke kubhulogi. Isihloko samanje sinikezelwe ematafuleni abantu abaningi abasebenza nabo lapho besebenza kukhompyutha (Ngicela uxolise nge-tautology). Abasebenzisi abaningi be-novice bavame ukubuza umbuzo ofanayo: "... kodwa ukuthi ungakha kanjani itafula ku-Excel ngokulingana okulingana no-cm. Lapha eZwini konke kulula kakhulu," kuthatha "umbusi, wabona uhlaka lweshidi futhi ludonse ...".

Ifomathi yeseli ohlelweni lwe-Excel lisetha kuphela ukubukeka kwedatha lokubonisa idatha, kodwa futhi ikhombisa ohlelweni ukuthi kufanele lucutshungulwe kanjani: njengombhalo, njengezinombolo, njengosuku, njll. Ngakho-ke, kubaluleke kakhulu ukusetha kahle lo mkhuba wohlu oluzofakwa ngalo idatha. Esimweni esiphikisanayo, zonke izibalo zizobe zingalungile.

Ngezinhloso ezithile, abasebenzisi badinga ukuthi isihloko setafula ngaso sonke isikhathi sibonakale, ngisho noma ishidi liphelela phansi. Ngaphezu kwalokho, kuvame ukudingwa ukuthi uma idokhumenti ishicilelwe esikhulwini esingokomzimba (iphepha), ukubhekwa kwetafula kukhonjiswa ekhasini ngalinye eliphrintiwe.

Phakathi kwemisebenzi eminingi iMicrosoft Excel esebenza nayo, umsebenzi we-IF kufanele uqokonyiswe. Lona kulawa ma-operators abasebenzisi abasebenzisa kakhulu lapho benza imisebenzi kuhlelo lokusebenza. Ake sibone ukuthi yimuphi umsebenzi "IF", nokuthi ungasebenza kanjani nayo. Incazelo ejwayelekile kanye nezinhloso ze- "IF" kuyisici esijwayelekile se-Microsoft Excel.

I-ODS ifomethi yespredishithi ethandwayo. Singasho ukuthi lokhu kuyindlela yokuphikisana namafomethi we-Excel xls no-xlsx. Ngaphezu kwalokho, i-ODS, ngokungafani nemifanekiso engenhla, ifomethi evulekile, okungukuthi, ingasetshenziswa mahhala futhi ngaphandle kwemingcele. Kodwa-ke, kwenzeka nokuthi idokhumenti ene-ODS isandiso idinga ukuvulwa ku-Excel.

Igrafu ikuvumela ukuthi ubuke ngokubukeka ukuxhomeka kwedatha kwizinkomba ezithile, noma amandla abo. AmaGrafu asetshenziselwa kokubili emsebenzini wesayensi noma ocwaningweni, nangethuba. Ake sibheke indlela yokwakha igrafu ku-Microsoft Excel. Ukwakha igrafu Kungenzeka ukuthi udwebe igrafu ku-Microsoft Excel kuphela emva kwetafula nedatha ilungile, ngesisekelo sayo esizokwakhiwa.

Uhlelo lwe-Microsoft Excel lunikeza amathuba okusebenza kuphela ngemininingwane yamanani, kodwa futhi inikeza ngamathuluzi wokwakha ngesisekelo semingcele yokufaka imidwebo. Ngesikhathi esifanayo, ukuboniswa kwabo okubonakalayo kungahluka ngokuphelele. Ake sibone ukuthi singasebenzisa kanjani i-Microsoft Excel ukudweba izinhlobo ezahlukene zamashadi.

Mhlawumbe, abasebenzisi abaningi abangenalwazi bazama ukukopisha idatha ku-Excel, kodwa ngenxa yezenzo ababenayo ihluke ngokuphelele noma iphutha. Lokhu kungenxa yokuthi ifomula yayisekhompyutheni eyinhloko yekhophi, futhi kwakuyifomula efakiwe, hhayi inani.

Ngokuvamile kunoma iyiphi inhlangano yokuhweba, into ebalulekile yomsebenzi ukuhlanganisa uhlu lwamanani wezimpahla noma amasevisi anikeziwe. Kungadalwa besebenzisa izixazululo ezihlukahlukene zesofthiwe. Kodwa, njengoba kungamangalisi kwabanye abantu, lokhu kungabonakala sengathi kuyindlela elula futhi elula kakhulu yokwakha uhlu lwamanani usebenzisa ispredishithi evamile ye-Microsoft Excel.

Isidingo sokushintsha ikhodi yombhalo ngokuvamile kubhekene nabasebenzisi bephequluli abasebenzayo, abahleli bombhalo nabacubungula. Kodwa-ke, uma usebenza kwiprosesa ye-Excel spreadsheet, isidingo esinjalo singase siphakamise, ngoba lolu hlelo alusebenzi izinombolo kuphela, kodwa futhi lombhalo. Ake sibone ukuthi singashintsha kanjani ukufaka ikhodi ku-Excel.

Ibha yefomula ingenye yezakhi eziyinhloko ze-Excel. Ngalo, ungenza izibalo uphinde uhlele okuqukethwe kwamaseli. Ngaphezu kwalokho, uma iseli likhethiwe, lapho kuphela inani elibonakala khona, isibalo sizoboniswa kubha yamatomu, besebenzisa ukuthi iyiphi inani elitholakalayo. Kodwa ngezinye izikhathi lesi sici esibonakalayo se-Excel sinyamalalala.

ACCOUNT opharetha ubhekisela kwimisebenzi yezibalo ze-Excel. Umsebenzi walo oyinhloko ukuthi ubale ububanzi obubekiwe bamaseli aqukethe idatha yamanani. Masifunde kabanzi mayelana nezici ezihlukahlukene zokusebenzisa le fomula. Ukusebenza nomqhubi we-akhawunti Umsebenzi we-akhawunti ubhekisela eqenjini elikhulu labaqhubi bezinombolo, okuhlanganisa amagama angamakhulu.

Enye yezindlela zokuxazulula izinkinga zezibalo kubalwa kwesilinganiso sokuzethemba. Isetshenziswe njengendlela ekhethiwe yokukhomba iphuzu ngobukhulu besampula. Kumele kuqashelwe ukuthi inqubo yokubala isikhathi sokuzethemba ngokwayo iyinkimbinkimbi kakhulu. Kodwa amathuluzi ohlelweni lwe-Excel enza kube lula nakakhulu.

Mhlawumbe, bonke abasebenzisi abasebenza njalo nge-Microsoft Excel bayazi ngalolu msebenzi oluwusizo lolu hlelo njengokuhlunga idatha. Kodwa akubona wonke umuntu owazi ukuthi kunezici eziphambili zaleli thuluzi. Ake sibuke ukuthi isiphi isihlungi seMicrosoft Excel esingasenza nokuthi singayisebenzisa kanjani.

I-XML ifomethi yendawo yonke yokusebenza nedatha. Isekelwa izinhlelo eziningi, kuhlanganise nalabo abavela kumkhakha we-DBMS. Ngakho-ke, ukuguqulwa kolwazi ku-XML kubalulekile ngokunembile ngokusebenzisana nokushintshaniswa kwedatha phakathi kwezicelo ezahlukene. I-Excel ingenye yezinhlelo zokusebenza ezisebenzisana namatafula, futhi zingenza ngisho nokwenziwa kwemininingwane yedatha.

Phakathi kwemisebenzi ehlukahlukene ye-Microsoft Excel, umsebenzi we-autofilter kufanele uqashe ngokukhethekile. Kuyasiza ukukhula kolwazi olungadingekile, futhi ushiye kuphela lokho umsebenzisi okwamanje adinga. Ake siyiqonde izici zomsebenzi womsebenzi nezilungiselelo ze-autofilter ku-Microsoft Excel.

Ngokuzenzakalelayo, i-Microsoft Excel ayikhiqiza ukubonakala kweshidi elibonakalayo. Ngesikhathi esifanayo, ezimweni eziningi, ikakhulukazi uma idokhumenti ithunyelwa ukuphrinta, idinga ukubalwa. I-Excel ikuvumela ukuba wenze lokhu usebenzisa izihloko nezinyawo. Ake sibheke izinketho ezihlukahlukene zokuthi ungabhala kanjani amashidi kulolu hlelo lokusebenza.

Lapho usebenza ku-Excel, abasebenzisi ngezinye izikhathi bahlangana nomsebenzi wokukhetha ohlwini lwento ethize bese beka inani elibekiwe ngokusekelwe ohlwini lwayo. Lo msebenzi ulawulwa kahle ngomsebenzi obizwa ngokuthi "Khetha". Masifunde ngokuningiliziwe ukuthi singasebenza kanjani nalena opharetha, futhi yiziphi izinkinga angakwazi ukusingatha.

Bambalwa abantu abazokuthanda isikhathi eside futhi ngokuzenzekelayo bafake uhlobo olufanayo noma olufanayo kwedatha. Lena umsebenzi omuhle kakhulu, uthatha isikhathi esiningi. I-Excel inamandla okuzenzekelayo ukufaka kwedatha enjalo. Ngenxa yalokhu, umsebenzi wezingqamuzana ezizenzakalelayo unikezwa. Ake sibone ukuthi kusebenza kanjani.