Esinye sezixhobo ezinamandla kwi-intanethi ye-parameterizing data yi-Excel. Esi sixhobo seOfisi yeMicrosoft besikunye nathi iminyaka kwaye ngalo lonke ixesha sinokwenza imisebenzi emininzi. Kuyinyani ukuba ezinye iintlobo zespreadsheets ziye zaphuma, ezifana ne-Apple's "Numbers" okanye "iSheets" zikaGoogle. Kodwa akukho namnye kubo onekhono, okwangoku, le-Excel. Baye bafezekiswa kwaye basetyenziswa luluntu lwedijithali kunye neenkampani ezinkulu kwiimarike iminyaka emininzi.
Nabani na kuthi osebenza phambi kwekhompyuter usebenzisa i-spreadsheet ngesizathu esithile. Ukwenza imizobo kwi-Excel akukho nto ingaphezulu kwesixhobo esibonakalayo sokubona ngokulula yonke into esiyongezayo kwiphepha. Ngale ndlela, abantu abangaqhelananga neefomula kunye nedatha banokubona ngokujonga nje ukuba kuthetha ukuthini. Kwakhona, siza kufundisa indlela yokwenza.
Nangona kunjalo, ukuba inkampani yakho okanye wena awunaso isicelo se-Excel kwaye usebenzise nayiphi na kwezi zikhankanywe ngasentla, khumbula ukuba umsebenzi wokwenza iigrafu uyafana. Kusenokwenzeka ukuba uzifumana unezinto ozilungeleyo ezingaphantsi okanye kulula kakhulu ukwenza into oyifunayo ngelo xesha ngenxa yokusikelwa umda kwayo. Kodwa ngokuqinisekileyo ungasebenzisa iigraphics. Kuya kufuneka wazi ukuba inguqulelo yedesktop ayifani nohlobo lwewebhu, olulinganiselwe ngakumbi.
Zeziphi iitshathi ze-Excel kwaye zezantoni?
Okokuqala, yazi ukuba iitshathi ze-Excel sesinye isixhobo kwiribhoni. Kwabo bangaqhelananga nolwimi lwe-Excel, "iRibhoni" ibizwa ngokuba yiphaneli ephezulu apho zonke iimpawu zeOfisi zikhoyo. Nokuba yi-Excel, iWord okanye iPowerPoint. Kule ribhoni sinokufumana iithebhu ezinemisebenzi eyahlukeneyo. Enye yazo yimizobo. Imiboniso emincinci emizobo esebenza njengohlalutyo lwedatha esiyibeke kwiphepha lethu.
Imalunga nokubonisa ngokubonakalayo itafile nganye yedatha esiyidalayo. Ezi theyibhile zedatha zinokuqokelela zonke iintlobo zolwazi. Ngokomzekelo, bangaphi abemi ngokwelizwe yaye bangaphi kubo ababudala busemthethweni okanye abantwana. Unokukhetha oku ngegrafu, ethi ngemibala, ibonise le datha. Ngaloo ndlela, sinokuhlela ngeentlobo ezimbini zedatha, inani labemi kunye nabantu abadala.
Ukunika njengomzekelo, sinokubonisa ukuba idatha iya kubonakala kwi-orange. Kwaye ngeblue, sinokubona inani labemi kunye nabancinci. Le mizobo inokuba zizo zonke iintlobo. Kuba asiyi kubona kuphela iigrafu zebar ezimelweyo. Kwakhona sinokuseka igrafu ejikelezayo, ngokungathi yitshizi, eyahlulwe ngemibala. Basenokusekwa ngamanqaku adadayo okanye ngemivalo ethe tye, yonke into iya kuxhomekeka koko kubonakaliswa kakhulu kwidatha yakho.
Uzenza njani iitshathi kwi-Excel
Eyokuqala yazo zonke ukukwazi ukwenza igrafu kwi-Excel, kukuba nedatha. Ezi datha zisisiseko sokukwazi ukwenza nantoni na kwi-spreadsheet yethu. Kulo mzekelo, onokuwubona emfanekisweni, siye saseka imilinganiselo yezixeko kunye nenani labemi. Kule datha siya kwenza igrafu esetyhula. Kule grafu siza kubona ihlulwe yonke le datha ngemibala kunye neepesenti.
Ngaloo ndlela, sinokubona ukuba izixeko zikhulu ngenani labemi abahlala kuzo. Ukwenza ezi grafu kulula kakhulu. Siphawula yonke idatha esifuna ukuyibona imelwe kule grafu. Kule meko, igama lezixeko kunye nenani labemi kuzo zonke. Nje ukuba sibonise kwitafile yethu, siya kwithebhu yeribhoni yethu, "Faka". Apho sinokubona iinketho ezimbini: Imizobo ecetyiswayo okanye uluhlu lweentlobo ezahlukeneyo zemizobo.
Iitshathi ezicetyiswayo zezo i-spreadsheet ngokwayo ekholelwa ukuba zisebenza kakhulu kulwazi ofuna ukulubonisa. Kodwa, ukuba ufuna ukuyenza ngenye indlela, ungaya kuluhlu lweegraphics eziyalelwa ngohlobo. Kwaye kukho ukukhetha nayiphi na kuzo. Nje ukuba ukhethe leyo uyifunayo, iya kuvela ngokuzenzekelayo kwitafile yakho. Ngegama elimiselweyo onokuthi uliguqule ngokuthanda kwakho. Njengemibala kunye nobukhulu.
Hlela imizobo xa sele yenziwe
Nje ukuba unayo le datha kwaye ezi grafu zicwangciswe kwiphepha lakho, ungaqhubeka nokwenza ngakumbi. Oku kuya kuxhomekeka kwinqanaba lemfuno yomntu ngamnye. Okanye bacela ntoni kuwe. Umboniso ongekho sikweni wokuba nedatha ebonakalayo yokuququzelela umsebenzi wakho ayifani nokwenza intetho esemthethweni kunye nabaphathi bakho kwinkampani. Kulapho ukwenziwa komntu oku kungena khona. Yenza ngokwezifiso naliphi na inqaku legrafu yakho ukunika umahluko ngokubhekiselele kwinto enokwenziwa ngumntu.
Ukuba sicofa kwigrafu yethu, siya kubona indlela ithebhu yefomati evula ngayo. Kule thebhu yefomathi sinokuyiguqula idatha ngaphakathi kwegrafu yethu kunye noyilo lwayo oluthile. Awuyi kukwazi nje ukutshintsha umbala wawo wonke umzobo, kodwa uya kukwazi ukuhlela indawo nganye yawo. Umbala, umzekelo, ungatshintsha ulwandlalo kwaye ususe ukugcwaliswa ukuze kungabonakali kunobundlobongela kakhulu xa unesiphumo esibanzi ngokuchasene nabanye.
Ungawuguqula umbala wokubhaliweyo kunye neepesenti. Bandakanya ngakumbi okanye ngaphantsi ukungafihli, dala izithunzi, iimbalasane okanye imiphetho ethambileyo. Kwakhona yahlula ngokwecandelo ukuze igrafu ibe nokwahlula phakathi kwamanqaku ayo abalulekileyo. Okanye wenze umzobo kwifomathi ye-3D ukuyenza ibonakale inomtsalane ngakumbi kwinkcazo onayo kwiintlanganiso zakho. Oku kukwenza kubonakale ngathi igrafu ngokwayo iphuma kwiscreen.
Kwaye okokugqibela, gcina engqondweni ukuba la ngamanye amanqaku onokuwenza, kodwa awapheli nje apho. Ukuba siphonononga zonke iinketho zeribhoni yethu yokwenza ngokwezifiso sinokufumana izixhobo ezahlukeneyo ezisisebenzelayo kwimeko yethu ethile. Yiyo loo nto unokwenza uphando lwakho kwaye uze netshathi yesiko ngokupheleleyo kuwe.