Ngokuvamile sibiza ifayela ngalinye le-Excel ngespredishithi. Kuwusizo ukuqonda ukuthi isipredishithi ku-Excel asihlukile kuspredishithi. Isipredishithi esiku-software ye-Excel singakwenzela lula imisebenzi ethile yansuku zonke, ekhaya nasebhizinisini lakho.
Kulesi sihloko, sizokufundisa ukuthi ungasebenzisa kanjani imiqondo eyisisekelo yethuluzi.
Yini i-spreadsheet ku-Excel?
Ishidi lokusebenzela liyithebhu kuphela efayeleni le-Excel.
Cishe uyazi ukuthi elinye lamakhono afunwa kakhulu namuhla ezinkampanini ukuphatha i-Excel, kodwa singakuqinisekisa ukuthi ukufunda yonke imisebenzi yayo kudinga isikhathi futhi ngaphezu kwakho konke amandla.
Ukuze udale amaspredishithi ku-Excel, uma usuvele uku-Excel interface, vele ufake ithebhu entsha. Ungakhetha inketho yokusebenzisa isinqamuleli sekhibhodi u-Shift + F11 noma uchofoze u-"+" eduze kwegama lephepha lokusebenzela.
Ungazulazula kanjani phakathi kwamashidi?
Sivamise ukuba nezizindalwazi ezimbalwa noma ulwazi oluhlukile, futhi lokhu kufanele kubekwe kumathebhu ahlukahlukene noma amaspredishithi ukuze kube lula ukuhlelwa komsebenzi. Ukuze uzulazule phakathi kwamathebhu noma amashidi, ungachofoza kwesokunxele kuthebhu ngayinye ukuze uwavule, noma usebenzise isinqamuleli esithi CTRL + PgDn ukuya phambili noma CTRL + PgUp ukuze ubuyele emuva.
Izikhathi eziningi bekufanele unwebe amathebula afanayo kumakhasi okusebenza ahlukene lapho kuphela idatha ehlukayo. Lolu hlobo lwesimo luvame kakhulu kubantu abasebenza ngamasheke ngezikhathi ezithile (nsuku zonke, masonto onke, nyanga zonke). Ngakho-ke kubalulekile ukwazi ukuthi zihlelwa kanjani ukuze ulwazi oluthile lufinyeleleke kalula.
Indlela yokufaka imibala kuspredishithi?
Uma usebenza ngamathebhu/amashidi amaningi, inketho eyodwa yokuhlukanisa izindawo ezihlobene, noma ukuhlukanisa ngokubonakalayo uhlobo ngalunye lwedatha, ukusebenzisa imibala ehlukene entweni ngayinye. Ukuze wenze lokhu, ungakwazi ukuchofoza kwesokudla kumugqa, ikholomu, noma isethi yamaseli, bese uchofoza kwesokudla bese ukhetha "umbala wokugcwalisa", bese ukhetha umbala owufunayo wesici okukhulunywa ngaso .
Ungawahlanganisa kanjani ama-Worksheets ku-Excel?
Ngemva kokufaka isizindalwazi sakho kuma-spreadsheet, kuyathakazelisa ukwenza imisebenzi efana nesamba senani eliveziwe, ukubalwa kwamaphesenti azosetshenziswa, kanye nolunye ulwazi oluningi ongase uludinge, kanye neqembu libe ngamaseli kusipredishithi sakho.
Uma lokho sekwenziwe, udinga ukufunda ukuthi ungawakha kanjani amafomula kudatha onayo. Isibonelo, inani lemikhiqizo ekumugqa woku-1 weshidi lokufingqa lepulazi lizoba isamba senani lemikhiqizo ekulayini 1 wedatha ngayinye yomsebenzi wamaqembu, njalonjalo ngolwazi olufanele. kumugqa ngamunye kanye nekholomu yeshidi lakho lokulawula.
Ungafunda futhi ukusebenzisa amashadi namagrafu ukuze utolike kangcono imiphumela yakho. Inhloso yamagrafu, njengoba negama liphakamisa, ukuhlinzeka ngephrezentheshini eyisithombe yedatha ebalulekile, ukuze kubonakale kangcono imiphumela etholiwe.
Ekuphethweni
Uzizwa kanjani lapho uqaphela ukuthi i-Excel iyisidingo sokuqala semakethe yemisebenzi yanamuhla? Uma udidwe eminye imisebenzi futhi ungazi ukuthi ungayiguqula kanjani idatha ibe imininingwane efanele ngempela, ungakhathazeki, ungafunda ukusebenzisa i-Excel ngempumelelo, futhi kukhona amavidiyo okuqeqesha mahhala ezisohlwini lwengosi yethu. Bavela ezinkundleni zemfundo ephakeme kakhulu.
