Ngokuqhelekileyo sibiza ifayile nganye ye-Excel ngespredishithi. Kuluncedo ukuqonda ukuba i-spreadsheet kwi-Excel ayahlukanga kwi-spreadsheet. I-spreadsheet kwi-Excel software inokwenza lula imisebenzi ethile yemihla ngemihla kuwe, ekhaya nakwishishini lakho.
Kweli nqaku, siya kukufundisa indlela yokusebenzisa ezinye iikhonsepthi ezisisiseko zesixhobo.
Yintoni i-spreadsheet kwi-Excel?
Iphepha lomsebenzi liyithebhu ekhethekileyo kwifayile ye-Excel.
Mhlawumbi uyazi ukuba esinye sezona zakhono zifunwa kakhulu kule mihla kwiinkampani kulawulo lwe-Excel, kodwa sinokuqinisekisa ukuba ukufunda yonke imisebenzi yayo kufuna ixesha kwaye ngaphezu kwakho konke amandla.
Ukwenza i-spreadsheets kwi-Excel, xa sele ukwi-Excel interface, faka nje ithebhu entsha. Unokukhetha ukhetho lokusebenzisa indlela emfutshane ye-keyboard Shift + F11 okanye ucofe ku-"+" ecaleni kwegama lephepha lomsebenzi.
Indlela yokuhamba phakathi kwamaphepha?
Sidla ngokuba nogcino-lwazi oluninzi okanye ulwazi olwahlukileyo, kwaye ezi kufuneka zibekwe kwiithebhu ezahlukeneyo okanye kwi-spreadsheets ukuququzelela ulungelelwaniso lomsebenzi. Ukuzulazula phakathi kweethebhu okanye amaphepha, unokucofa-ekhohlo-kwithebhu nganye ukuyivula, okanye usebenzise indlela emfutshane CTRL + PgDn ukuya phambili okanye CTRL + PgUp ukubuyela umva.
Amaxesha amaninzi kuye kwafuneka wandise iitafile ezifanayo kumaphepha okusebenzela ahlukeneyo apho kuphela idatha iyahluka. Olu hlobo lwemeko luxhaphake kakhulu phakathi kwabantu abasebenza ngeetshekhi ngamaxesha (imihla ngemihla, ngeveki, ngenyanga). Ngoko ke kubalulekile ukwazi ukuba zilungelelaniswe njani ukuze ulwazi oluthile lufikeleleke lula.
Indlela yokufaka imibala kwi-spreadsheet?
Xa usebenza ngeethebhu / amaphepha amaninzi, enye inketho yokwahlula iindawo ezinxulumeneyo, okanye ukwahlula ngokubonakalayo uluhlu ngalunye lwedatha, kukusebenzisa imibala eyahlukileyo kwinto nganye. Ukwenza oku, unokucofa nje-ekunene kumqolo, ikholamu, okanye iseti yeeseli, emva koko ucofe ekunene kwaye ukhethe u-"gcwalisa umbala", emva koko ukhethe umbala owufunayo kwinto ebuzwayo.
Ukudibanisa njani amaphepha okusebenzela kwi-Excel?
Emva kokufaka i-database yakho kwi-spreadsheets, inika umdla ukwenza imisebenzi efana nenani lilonke lamanani anikezelweyo, ukubalwa kweepesenti eziza kusetyenziswa, kunye nezinye iinkcukacha ezininzi onokuzifuna, kunye neqela kwiiseli kwi-spreadsheet sakho.
Nje ukuba yenziwe, kufuneka ufunde ukwenza iifomula kwidatha onayo. Ngokomzekelo, ixabiso leemveliso kumgca we-1 wephepha lesishwankathelo sefama liya kuba lixabiso lexabiso leemveliso kumgca we-1 wedatha nganye yomsebenzi wamaqela, njalo-njalo ngolwazi olufanelekileyo. kumqolo ngamnye kunye nekholamu yephepha lakho lolawulo.
Unokufunda ukusebenzisa iitshathi kunye neegrafu ukutolika ngcono iziphumo zakho. Injongo yeegrafu, njengoko igama libonisa, kukubonelela ngenkcazo yegraphical yedatha ebalulekileyo, ukujonga ngcono iziphumo ezifunyenweyo.
Ukuququmbela
Uziva njani xa ufumanisa ukuba i-Excel iyimfuneko kwimarike yomsebenzi yanamhlanje? Ukuba ubhidekile yeminye imisebenzi kwaye awuyazi indlela yokuguqula idatha ibe lulwazi olufanelekileyo, ungakhathazeki, unokufunda ukusebenzisa i-Excel ngempumelelo, kwaye kukho iividiyo zoqeqesho lwasimahla zidweliswe kwindawo yethu. Bavela kumaqonga emfundo makhulu.
