5 izindlela zokubulala ukusebenzisa Microsoft Excel
I-Excel yiprogram yespredishithi ye-electronic.
Isipredishithi se-elektroniki uhlelo lwekhompyutha olusetshenziselwa ukugcina, ukuhlela nokuphatha idatha .
Yisiphi i-Excel esetshenziselwa
Izinhlelo zesipredishithi ze-elekthronikhi zisekelwe ekuqaleni kuma-spreadsheets ephepha asetshenziselwa ukubalwa kwezimali. Ngakho-ke, ukusekelwa okuyisisekelo kwama-spreadsheet e-computer kufana nephepha. Idatha ehambisanayo igcinwa ematafuleni - okuyiqoqo lamabhokisi amancane angama-rectangular noma amaseli ahlelwe ngemigqa namakholomu.
Izinguqulo zamanje ze-Excel nezinye izinhlelo zespredishithi zingagcina amakhasi amaningi wepredishithi kwifayili eyodwa yekhompyutha.
Ifayela lekhompyutheni elilondoloziwe livame ukubizwa njengencwadi yokusebenzela kanye nekhasi ngalinye encwadini yokusebenzela liyiphepha lokusebenzela elihlukile.
I-Excel Alternatives
Ezinye izinhlelo zamapredishithi zamanje ezitholakalayo ukusetshenziswa zifaka:
AmaSpredishithi e-Google (noma i-Google Spreadsheets) - uhlelo lokusakaza ispredishithi yamahhala, ewebhu;
I-Excel Online - inguqulo yamahhala, ehlelwe phansi, ewebhu-ye-Excel;
Vula iHhovisi le-Office Calc - uhlelo lwepredishithi olukhululekile, olulandelwe.
AmaSpredishithi Amaseli kanye namaReferensi weselula
Uma ubheka isikrini se-Excel - noma esinye isikrini sesipredishithi - ubona ithebula elixubile noma igridi yemigqa namakholomu , njengoba kuboniswe esithombeni ngenhla.
Kuzinguqulo ezintsha ze-Excel, ishidi ngalinye lomsebenzi liqukethe imigqa eyizigidi kanye namakholomu angaba ngu-16,000, okudinga uhlelo lokubhekana ukuze ulandele ukuthi idatha ikhona kuphi.
Imigqa enezingqimba ibonakala ngezinombolo (1, 2, 3) kanye namakholomu aqondile ngezinhlamvu zezinhlamvu (A, B, C). Amakholomu angaphezu kuka-26, amakholomu abonakala ngamagama amabili noma ngaphezulu afana ne-AA, AB, i-AC noma i-AAA, i-AAB, njll.
Iphuzu lesiphambano phakathi kwekholomu nomugqa, njengoba kukhonjisiwe, ibhokisi elincane elingenxantathu elibizwa ngokuthi iseli.
Iseli iyunithi eyisisekelo yokugcina idatha kushidi lokusebenzela, futhi ngoba ishidi ngalinye liqukethe izigidi zala maseli, ngalinye libhekwa ngereferensi yeseli.
Isithenjwa se-cell yinhlanganisela yombhalo wekholomu nenombolo yomugqa efana ne-A3, B6, ne-AA345. Kulezi zikhombo zeseli, incwadi yekholomu ihlale ibhalwe kuqala.
Izinhlobo Zedata, Amafomula, Nemisebenzi
Izinhlobo zedatha engakwazi ukubamba zihlanganisa:
- Izinombolo;
- Umbhalo;
- Izinsuku nezikhathi;
- Amanani we-Boolean ;
- Amafomula .
Amafomu asetshenziselwa izibalo - ngokuvamile afaka idatha equkethwe kwamanye amaseli. Lawa maseli, kodwa, angase atholakale kumafomethi okusebenza ahlukene noma ezincwadini zokusebenza.
Ukwakha ifomula kuqala ngokufaka uphawu olulinganayo esitokisini lapho ufuna khona impendulo. Amafomu angaphinda afake izingqikithi zeseli endaweni yedatha kanye nemisebenzi eyodwa noma ngaphezulu kwespredishithi.
Imisebenzi e-Excel namanye ama-spreadsheet e-electronic akha amafomula akhelwe ekwenzeni lula ukwenza izibalo eziningi - kusukela ekusebenzeni okuvamile njengokungena ngosuku noma isikhathi eziyinkimbinkimbi ezinjengokuthola ulwazi oluthile olunezintafula ezinkulu zedatha .
Idatha ye-Excel neyezimali
Amaspredishithi ngokuvamile asetshenziselwa ukugcina idatha yezimali. Amafomu nemisebenzi esetshenziselwa lolu hlobo lwedatha kufaka:
- Ukwenza imisebenzi eyisisekelo yezibalo ezifana namakholomu okuhlanganisa noma imigqa yezinombolo .
- Ukuthola amanani njengenzuzo noma ukulahlekelwa.
- Ukubala izinhlelo zokukhokhwa kwemali yokuboleka imali noma imali yokubolekwa kwemali.
- Ukuthola isilinganiso, isilinganiso esiphezulu, esincane kanye nezinye izibalo ezibalulwe kuluhlu oluthile lwedatha.
- Ukwenza ukuhlaziywa kwe-Data-uma ukuguquguquka okuguquguqukayo ngakunye ukuze ubone indlela ushintsho lwenze ngayo enye idatha - njengezindleko nezinzuzo.
Ezinye izinto zokusebenza ze-Excel
Okunye imisebenzi evamile ukuthi i-Excel ingasetshenziselwa ukufaka:
- Idatha yesigcafu noma ishadi lokusiza abasebenzisi ekukhoneni izitayela zedatha.
- Ukufometha idatha ukwenza idatha ebalulekile ukuthola nokuqonda.
- Ukuphrinta idatha namashadi okusetshenziselwa imibiko.
- Ukuhlunga nokuhlunga idatha ukuthola ulwazi oluqondile.
- Ukuxhumanisa idatha yephepha lokusebenzela kanye namashadi okusetshenziswa kwezinye izinhlelo ezifana ne-Microsoft PowerPoint ne-Word.
- Ukungenisa idatha kusuka ohlelweni lwezinhlelo zokuhlaziywa.
Ama-spreadsheet ayengama-original ' apps killer' amakhompyutha akhe siqu ngenxa yokwazi kwabo ukuqoqa nokuqonda ulwazi. Izinhlelo zokuqala zespredishithi ezifana neVisiCalc neLotus 1-2-3 ikakhulukazi zibophezele ekukhuleni kwamakhompiyutha afana ne-Apple II ne-IBM PC njengethuluzi lebhizinisi.