Nangona abatyhishini abaninzi banokuthi banciphise i-Excel spreadsheet basebenzise kwiinkqubo zabo zokugcina iincwadi, njengoko bebona inkqubo ilungele ukulandelela, ukuthumela kunye nokurekhoda kwemisebenzi, i-Excel ingafana nokusebenza kwemali. Ngokuqonda iifomula ezifanelekileyo kunye nezindlela ezisisiseko zokucwangcisa, umnini-shishini we-math-phobic uzakufumana i-Excel spreadsheets elula ukuhamba.
Ziziphi i-Excel Spreadsheets ezifunekayo zokunikela
I-Excel yinkqubo ye-Microsoft Office eyenzelwe ukukunceda ukubala, itafile, iseshwankathelo kunye nokuthelekisa idatha yenkcazelo yangoku kunye nezayo. Kwaye njengamanye amaninzi enkqubo zeMicrosoft, iimpawu zayo zizinzileyo kwaye zingasetyenziswa kunye nobunzima obuncinane okanye obunzima njengoko ukhetha.
Ngaphandle kweencwadi zokugcina ukugcinwa kweencwadi, iimpawu zokuphendula kwi-Excel zinokukunceda ukuba ubone ukuba ibhizinisi lakho limi njani ngokwezemali, ukuvelisa iingxelo ezinzulu, ukulandelela uluhlu lwabathengisi, abasebenzi kunye nabathengi, kwaye ulungiselele iirekhodi zakho zonyaka werhafu ngonyaka.
Nazi imimiselo embalwa yendlela yokusebenzisa i-Excel spreadsheet ze-accounting basisiseko.
Indlela yokusebenzisa i-Excel ukulandelela iimpahla, ukuthengwa kunye neendleko
Ukufaka idatha kwi-Excel ukugcina irekhodi lokuthenga kwakho, ukuthengiswa kunye neendleko ngokuthe ngqo. Xa uvula iMicrosoft Excel, qalisa iphepha lokusebenzela elitsha, kwaye uqale ukunikezela iilebhile kwiikholamu eziza kubandakanya imihla kunye nemilinganiselo yamanani kwisondlo ngasinye sempahla, intengiso nganye kunye neendleko nganye.
Emva kokuba iikholomu zakho zibhalwe, faka ukuthengwa kokuthengwa, ukuthengiswa okanye iindleko kwiikholamu nganye kumqolo ofanelekileyo nomhla ochanekileyo.
Ukubona le nkqubo elula esenzweni, nasi isifundo sevidiyo esiza kukuhamba ngamanyathelo: Indlela yokusebenzisa iMicrosoft Excel ye-Accounting Business Small.
Indlela yokusebenzisa iifomula ezisisiseko kunye neziNqutyana kwi-Excel
Kwi-tutorial yangaphambili, usenokuba uqaphele ukuba umqeqeshi wenza iifomula ze-Excel ukuba abale inzuzo esekelwe ekuthengisweni kwempahla, ukuthengiswa kunye nedatha yeendleko. Iifomula zinceda abaqeqeshi bee-accounting kunye nabahwebi ngokufanayo bahamba ngeendlela ze-Excel ngokufanelekileyo ngokufanelekileyo.
Ngoko phambi kokuba udibene kwiinkcazo ezicacileyo zenkcazo ebalulekileyo yezoshishino kunye nedatha oyifake kwiphepha lakho lokusebenzela lase-Excel, kunokuba luncedo ukufunda ezininzi malunga neengcebiso, amaqhinga kunye namafomula ongayisebenzisa kakuhle ukuhamba phambili.
Nantsi i-video ye-tutorial ehamba ngokukhawuleza ihlanganisa ezinye zeefomula ezikhoyo kunye nezixhamlayo kwi-Excel: Iingcebiso ze-Excel 2016 kunye neCandelo le-Excel 2016.
Indlela yokusebenzisa i-Excel ukudala iNkcazo yeNzuzo kunye neLahleko
Uninzi lwabasomashishini bakhetha ukuba nolwazi olunxulumene neenzuzo zabo okanye ilahleko zoshishino zabo ezihlukileyo kwezinye iidatha. Oku kuvumela ukuba bahlalutye baze baqhathele ingeniso yabo ngexesha lamaxesha ahlukeneyo konyaka, utshintsho oluthile kwiiprojekthi zabo okanye umthwalo wokusebenza, okanye nayiphi na imiqathango yeemeko ezinokuchaphazela impilo yemali yenkampani.
Indlela efanelekileyo yokujonga le ngcaciso ngokwahlukileyo yinkcazo yenzuzo kunye nelahleko (P & L) okanye isitatimenti se ngeniso.
Ngombulelo, i-Excel ineemplates ezenziwe ngokulungele ukukunceda udale, uzalise kwaye ugcine isitatimende senzuzo kunye nelahleko njengoko uqhuba ishishini lakho. Kodwa kulunge ukuba ufunde indlela izitatimende ze-P & L zisebenza ngayo ngaphandle kokuba ukhe ukhethe ukusebenzisa iithemplates ezinikezelwe kwinkqubo.
Ukubona indlela yokwakha inzuzo elula kunye nelahleko kwi-Excel ngaphandle kokuncediswa kwethemplate, nayi-tutorial video ebonisa indlela yokuqalisa ngayo: Ukudala ii-Akhawunti zoLawulo Ukusebenzisa i-Excel: iNzuzo kunye neNkcazo yokulahleka.
Indlela yokusebenzisa i-Excel ukuvelisa iingxelo kunye namaSpredishithi
Iingxelo zeendleko, iingxelo zentengiso, i-balance sheet, i-ledger jikelele, uyiqamba igama. Ukuba kukho enye into yokugcina iincwadi kunye nabagcini-zimali bayakujabulela ukudala iingxelo.
Ngenhlanhla, iMicrosoft Office yenza iirekhodi ezivelisayo zilula lula ngokuhlaziywa kwesoftware nganye entsha.
Njengomnini-shishini, ukudala iingxelo akuyiyo into oyilungisayo kuphela kubatyalomali bakho, amaqabane oshishino okanye igosa lemboleko yebhanki. Iingxelo zivumela ukuba uthathe uhlolojikelele jikelele okanye inkcukacha ethile malunga nempilo yakho yezemali ngaphandle kwexabiso elikhulu leenkcukacha ukuchaza isiphetho. Ngaloo ndlela, zinceda kakhulu kuwe njengomrhwebi ukulinganisa isimo sebhizinisi lakho ngokukhangela, ngamaxesha onke.
Ukufunda indlela yokuvelisa iingxelo zesishwankathelo esilula, nantsi i-video tutorial yokufundisa indlela yokwakha ingxelo yokuthengisa kwi-Excel: Ukudala ingxelo yoThengiso kwi-Excel: iNqanaba eliSiseko.
Iingxelo zindleko zifuna amanyathelo ambalwa ahlukeneyo. Ukuze uqalise, nantsi i-video tutorial yokufundisa indlela yokwakha ingxelo yeendleko okanye iphepha: iMicrosoft Excel: Ukudala iShidi leZindleko ezilula.
Ukuba unomdla wokongeza imifanekiso ebonakalayo kwiingxelo zakho ezivumela abafundi ukuba baqonde kakuhle ulwazi, nayi-tutorial video malunga nendlela yokudala amatafula e-pivot, iigrafu kunye needashbhodi: Isingeniso kwii-Tivables, i-Charts neeDashbhoards kwi-Excel .
Yaye iya kuthathwa yintoni inkqubo encinane yokubambisa i-business ngaphandle kwesikhokelo esiqhelekileyo? Nantsi i-video epheleleyo yokufundisa ekudaleni i-ledger jikelele kwi shishini lakho: Yakha i-Ledger jikelele usebenzisa i-Excel.
Ukwandisa i-Microsoft yakho Excel Know-How
Ukuba iMicrosoft Excel yiprogram ongayisebenzisi kangako ngaphambi kokuba ube neyeshishini, ibonakala ngathi iyatshitshiswa naphezu kokusekwa kwayo. Nangona kunjalo, kukho abaqeqeshi abasebenzisa i-Excel imihla ngemihla abangaqinisekanga kuzo zonke iinkalo eziphambili zeprogram. Yiyo le nkqubela kunye nofikelelo olubanzi olwenza ukuba lufaneleke njengesixhobo kubalobi bezoshishino.
Enye indlela ekuqinisekiseni ngayo amaphupha akho osomashishini angakhula kwaye anyuke kwinqanaba elilandelayo kukudlala indima echaphazelekayo kwiinkqubo zengxelo zezoshishino. Ukuqala ngemisebenzi yalo elula, abanikazi bamashishini abancinci bangafunda indlela yokulawula iirekhodi zabo zezezimali kunye nokwandisa izakhono zabo ze-Excel kunye nezempilo zabo zeenkampani.
Ukongeza kwii-tutorials zevidiyo ezifakwe apha ngasentla, iMicrosoft nayo inelayibrari yoqeqesho lwayo lwe-Excel enokukunceda uhlaziye izakhono zakho ze-Excel ukuze ukwazi ukulusebenzisa kwesi sixhobo esincinane kwi shishini lakho elincinci.