Amathiphu namaqhinga aphezulu we-Microsoft Excel ku-Office 5
Kungakhathaliseki ukuthi usebenza ku-accounting, ugcwalise ama-invoyisi, noma uvele ucubungule izinombolo ezithile, i-Microsoft Excel iwuhlelo oluwusizo kakhulu kumabhizinisi nakubathengi ngokufanayo. Nokho, ngokungafani nezinye izinhlelo ze-Office 365, i-Excel igxile kakhulu kudatha, engase yethuse kwabanye. Ungakhathazeki, ngoba manje sikunikeza ukubheka amanye amathiphu namasu e-Excel esiwathandayo e-Office 365. Lawa macebiso namacebo ngeke nje akugcinele isikhathi kodwa angenza izinto zibe lula futhi akusize ukwenze uchwepheshe we-Excel.
Sebenzisa izinqamuleli ezithile
Njengezinye izinhlelo ze-Office 365, kunenombolo yezinqamuleli zekhibhodi ezingasetshenziswa ku-Excel.
Uma usebenzisana nezinombolo namaspredishithi anganwebeka cishe amakholomu namarowu angapheli, lezi zinqamuleli zingagcina zikongela isikhathi nekhanda elibuhlungu.
Sihlanganise ezinye zezintandokazi zethu .
- CTRL + Faka: ukuphinda umbhalo. Chofoza kulo lonke iqembu lamaseli bese uthayipha ofuna ukuphinda kuseli lokugcina, bese ucindezela u-Ctrl + Enter. Okubhalile kuya kuseli ngalinye..
- I-ALT + F1: Sebenzisa lesi sinqamuleli ukuze udale amashadi eshidini elifanayo nedatha yakho. Ngokufanayo, ukucindezela F11 Ukwakha ishadi eshidini elihlukile
- Shift + F3 Sebenzisa lesi sinqamuleli ukuze ufake umsebenzi
- U-Alt + H + D + C: Sebenzisa lesi sinqamuleli ukuze ususe ikholomu
- U-Alt + H + B: Sebenzisa lesi sinqamuleli ukuze wengeze umngcele kuseli
- U-Ctrl + Shift + $: Sebenzisa lesi sinqamuleli ukuze usebenzise ifomethi yohlobo lwemali
- U-Ctrl + Shift + %: Sebenzisa lesi sinqamuleli ukuze usebenzise ifomethi yephesenti
- U-Ctrl + Shift + &: Sebenzisa lesi sinqamuleli ukuze usebenzise imingcele yohlaka
- I-F5: Sebenzisa lesi sinqamuleli ukuze uye kuseli. Vele uthayiphe okuthi F5 bese ufometha iseli noma igama leseli
Zama imisebenzi ye-IFS Boolean ukuze ukhiphe isidingo samafomula afakwe esidlekeni
I-IFS umsebenzi wendawo owaziwa ngokuthi “Uma, lokhu, bese, nokuthi.”. Lokhu kusetshenziswa abahlaziyi emhlabeni wonke, futhi kungahlola izimo eziningi ku-Excel ukuze ungadingi ukusebenzisa amafomula akhiwe.
Isici singasetshenziswa ngokufaka =IFS kubha yefomula, ngokulandela imigomo. Bese i-IFS ihlola ukuze ibone ukuthi izimo ziyafinyelelwa yini futhi izobuyisela inani elifana nombandela we-TRUE. Isampula ye-IFS iboniswe ngezansi.
Esithombeni esilandelayo, sisebenzisa ifomula ukuze sakhe amaphuzu kusipredishithi.
Sebenzisa umudwa ochaza ngesimo ukuze uhlole isimo sedatha
Akekho othanda ukwenza izibalo ezisheshayo, kodwa i-Excel iyakwazi ukukucubungulela idatha ngokushesha. Uma uneshidi lezinombolo, noma izinombolo, umudwa ochaza ngesimo ungacubungula kalula izinombolo zakho ngaphandle kokuthi uthayiphe ifomula. Lokhu kubandakanya isikali, isikali, esincane, esikhulu, isamba. Udinga nje ukugqamisa idatha ukuze uqalise. Ezimweni ezingavamile, kungase kudingeke ukuthi uyinike amandla kuqala. Uma kunjalo, chofoza kwesokudla kubha yesimo, bese uchofoza ukuze unike amandla izinketho zezibalo ofuna ukuzibona.
Zama amabha wedatha ukuze ubone idatha yakho ngokubuka
Idatha enkulu iyasiza, kepha akukho okubonwayo kune-infographics. Ngesici samabha edatha ku-Excel, ungakwazi ukwengeza amabha kumathebula akho akhona ngaphandle kokwengeza igrafu. Ungakwenza lokhu ngokukhetha idatha namaseli ofuna ukuwagrafu, bese uya kuwo Ikhasi eliyisiqalo Ikhaya, bese ukhetha Ukufometha Okunemibandela , khetha Amabha wedatha. Ungabe usukhetha kokugcwaliswa kwegradient noma ukugcwaliswa kombala.
Cela usizo lwe-Excel
Uma uzithola ulahlekile ku-Excel, uhlelo ngokwalo lungasiza. Vele uchofoze ibhokisi phezulu lapho lisho khona sesha Futhi uzokwazi ukusesha umsebenzi ofuna ukuwenza ku-Excel.
Ibhokisi losesho lizobe selikunikeza inketho. Kungenjalo, ungahlala ubhala “ Usizo" Kule bha yokusesha ukuze ushayele futhi uthole uhlu lwezihloko ezidumile ze-Excel nemisebenzi. Ezinye zezihloko ezijwayelekile ezibalwe lapha ukuthi imigqa, imisebenzi, amaseli, amafomula, ukufometha, amathebula, njll.
Ingabe uzokwazi ukuthola izinga eliphezulu ku-Excel?
Kuningi ongakwenza nge-Microsoft Excel, futhi kunzima ukukumboza kokuthunyelwe okukodwa. Amathiphu ethu namasu athinta kuphela izisekelo, kodwa kuningi ongakuthola. Sitshele kumazwana angezansi amathiphu akho namasu e-Excel ne-Office 365.
Ungawalungisa kanjani amakhodi ephutha e-Microsoft Excel
