Uyisebenzisa njani iFomathi yeNombolo yoCwangciso kwiMicrosoft Excel
Ukuba usebenzisa iMicrosoft Excel ngeenjongo zokubala, unokufuna ukusebenzisa inombolo yokubala ifomathi kumanani akho. Kukho iindlela ezininzi zokusebenzisa oku ulungelelaniso Kwaye siza kuchaza ukuba njani.
Ithini ifomathi yenombolo yokubala?
Ekuboneni kokuqala, ifomathi yenombolo ye-accounting ibonakala njengefomathi yemali. Nangona kunjalo, kukho umahluko phakathi kwezi zimbini.
Lo mahluko zezi:
- uphawu lwemali : Ifomati yenombolo ye-accounting ibeka uphawu lwemali ekhohlo kude kwiseli.
- Zero Njengedashi: Ooziro bakho baboniswa njengedashi kule fomati yamanani.
- Ezingalunganga kwizibiyeli : ibonisiwe Amanani angalunganga
()phakathi kwezibiyeli. I-Excel ayikwenzi oku ngokungagqibekanga.
Zonke ezi ndlela zingezantsi zikuvumela ukuba usebenzise ifomathi yenombolo yokubala efanayo kumanani akho, ke sebenzisa nayiphi na indlela ofumana kulula ukuyenza.
Faka ifomati yenombolo yokubala ngeribhoni ukhetho
I-Excel inokhetho kwiribhoni yayo ukukunceda ukuba usebenzise ngokukhawuleza ifomathi yenombolo yokubala kwiispredishithi zakho.
Ukuyisebenzisa, okokuqala, vula i-spreadsheet nge-Microsoft Excel. Kwi-spreadsheet, khetha iiseli eziqulathe amanani ofuna ukuwaguqulela kumanani okubalwa.
kwi Ibha ye-Excel phezulu Cofa kwi eKhaya thebhu.
Kwi eKhaya thebhu, kwicandelo leNani, cofa i-ayikhoni yotolo olusezantsi ecaleni kwendlela yokuFomatha inombolo ye-Akhawuntingi.
Kwimenyu evulayo, khetha imali yeenombolo zakho.
Kwaye amanani akho owakhethileyo ngoku asebenzisa ifomathi yenombolo yokubala.
Ulungile.
Faka ifomati yenombolo ye-akhawunti ngokusebenzisa imenyu yokuhla
Enye indlela yokufaka ifomathi yenombolo yogcino-mali kukusebenzisa ifomati yenombolo yoluhlu lokuhla.
Ukusebenzisa le ndlela, vula i-spreadsheet nge-Microsoft Excel. Emva koko khetha iiseli ezinamanani kuzo.
Kwiribhoni ye-Excel phezulu, cofa i eKhaya thebhu.
Kwi eKhaya thebhu, kwindawo ethi Nani, cofa kwindawo ehlayo.
Ukusuka kwimenyu eyehlayo, khetha iAkhawuntingi.
Onke amanani owakhethileyo ngoku akwifomathi yeenombolo zokubala.
Yi le.
Sebenzisa amanani okubalwa ngefestile yeeSeli zokuFomatha
Indlela yesithathu yokusebenzisa ifomati yenombolo ye-accounting kwi-Excel kukuvula ifestile yeeFomathi zeeSeli.
Ukwenza oku, vula i-spreadsheet kwaye ukhethe iiseli ezinamanani kuzo. Cofa ekunene enye yezi seli kwaye ukhethe iiSeli zokuFomatha kwimenyu.
Ifestile yeFomathi yeeSeli iya kuvula. Apha, ukusuka kuluhlu lwemenyu ekhohlo, khetha iAkhawuntingi.
kwindawo elungileyo, Misela amanqaku edesimali kumanani akho Ukusebenzisa "iindawo zedesimali" ukhetho. ngoko Khetha imali Ukusuka kwi-"Symbol" yemenyu yokuhla.
Ekugqibeleni, cofa u-OK emazantsi efestile.
Iiseli ozikhethileyo ngoku zifomathwe kwifomathi yenombolo yokubala.
Ngoku ulungele imisebenzi yakho yokubala kwiispredishithi zakho ze-Excel.
Ngaba i-Excel iyayisusa i-zero ekuqaleni kwamanani akho? Kukho indlela Ukumenza agcine ezi zero .
