I-Excel

Uma usebenzisa amafomula ku-Microsoft Excel, abasebenzisi kufanele basebenze ngezixhumanisi kwamanye amaseli asetshenzisiwe. Kodwa akuwona wonke umsebenzisi owaziyo ukuthi lezi zixhumanisi zinezinhlobo ezimbili: ngokuphelele futhi isihlobo. Ake sizithole ukuthi zihluke kanjani phakathi kwabo, nokuthi zakha kanjani isixhumanisi sohlobo olufunayo.

Kunezimo lapho umbhalo noma amatafula afakwe ku-Microsoft Word kudingeka adluliselwe ku-Excel. Ngeshwa, iZwi alinikezi amathuluzi okwakhiwe kuwo ukuguqulwa okunjalo. Kodwa ngesikhathi esifanayo, kunezindlela eziningi zokuguqula amafayela kule ndlela. Ake sithole ukuthi lokhu kungenziwa kanjani.

Amathebula anezintambo ezingenalutho azijabulisi kahle. Ngaphezu kwalokho, ngenxa yemigqa eyengeziwe, ukuhamba ngezinyawo kungase kube nzima nakakhulu, ngoba kufanele uphelele emkhakheni omkhulu wamaseli okuya kusukela ekuqaleni kwetafula kuze kube sekupheleni. Ake sithole ukuthi yiziphi izindlela zokususa imigqa engenalutho ku-Microsoft Excel, nokuthi ungasusa kanjani ngokushesha futhi kulula.

Abasebenzisi abaningi baye baphawula ukuthi uma usebenza ku-Microsoft Excel, kunamacala uma amaseli uma ufaka idatha esikhundleni sezinombolo zezinhlamvu zivela ngendlela yezinhlamvu (#). Ngokuvamile, akunakwenzeka ukusebenza ngolwazi kuleli fomu. Ake siqonde izimbangela zalesi nkinga bese sithole isisombululo saso. Ukuxazulula inkinga Isibonakaliso samaphilisi (#) noma, njengoba kulungile kakhulu ukuyibiza, i-oktotorp ivela kulawo maseli ku-sheet ye-Excel leyo idatha engafanele imingcele.

Esinye sezifomethi zesitoreji esithandwayo kakhulu sedatha ehleliwe yi-DBF. Le fomethi iyonke, okungukuthi, isekelwa izinhlelo eziningi ze-DBMS nezinye izinhlelo. Akusetshenziswanga nje kuphela njengesici sokugcina idatha, kodwa futhi njengendlela yokuwabelana phakathi kwezicelo. Ngakho-ke, inkinga yokuvula amafayela ngesandiso esinikeziwe ku-spreadsheet ye-Excel iba usizo.

Phakathi kwemisebenzi eminingi ye-arithmetic ukuthi i-Microsoft Excel ingenza, yebo, kukhona nokuphindaphindiwe. Kodwa, ngeshwa, akubona bonke abasebenzisi abangasebenzisa ngokugcwele leli thuba futhi balisebenzise ngokugcwele. Ake sibone ukuthi singenza kanjani inqubo yokubuyabuyelela ku-Microsoft Excel.

Ngezinye izikhathi kunezimo lapho kudingeka ukuguqula itafula, okusho ukuthi, shintsha imigqa namakholomu. Yiqiniso, ungakwazi ukuphazamisa ngokuphelele yonke idatha njengoba udinga, kodwa lokhu kungathatha isikhathi esiningi. Akubona bonke abasebenzisi be-Excel abaqaphela ukuthi kunomsebenzi kule prosesa ye-tabular ezosiza ukuzenzakalela le nqubo.

Kudingeka njalo ukuthi isihloko siphindwe ekhasini ngalinye lapho ushicilela ithebula noma enye idokhumenti. Ngokweqiniso, kungenzeka ukuthi kunqunywe ukucacisa umkhawulo wekhasi ngokusebenzisa indawo yokubuka kuqala bese ufaka ngesandla phezulu ekhasini ngalinye. Kodwa lokhu kukhetho kuzothatha isikhathi esiningi futhi kuholele ekuphuleni ekutheni ububanzi betafula bube khona.

Uma usebenzisa amafomula ku-Excel, uma amaseli abhekiswa opharetha asinalutho, kuzoba khona ama-zero endaweni yokubala ngokuzenzakalelayo. Ngokweqile, lokhu akubukeka kuhle kakhulu, ikakhulu uma kunezinhlobo eziningi ezifanayo nezindinganiso zero etafuleni. Yebo, futhi umsebenzisi kunzima kakhulu ukuhamba ngedatha uma kuqhathaniswa nesimo, uma izindawo ezinjalo zingenalutho.

Njengoba wazi, i-Excel inikeza umsebenzisi amandla okusebenza kudokhumenti owodwa ngesikhathi esisodwa kumashidi amaningana. Uhlelo lokusebenza lunikeza ngokuzenzakalelayo igama kwisici ngasinye esisha: "Ishidi 1", "Ishidi 2", njll. Lokhu akukona nje okomile kakhulu, okunye okungavumelaniswa ngakho, ukusebenza namadokhumenti, kepha futhi akukona ukwazisa kakhulu.

I-matrix ye-BCG ingenye yamathuluzi wokuhlaziya okukhangisa kakhulu. Ngesizo salo, ungakhetha isu elizuzisa kakhulu lokukhuthaza izimpahla emakethe. Ake sithole ukuthi yini i-matrix ye-BCG nokuthi uyayakha kanjani usebenzisa i-Excel. I-BCG Matrix I-Boston Consulting Group (BCG) i-matrix iyisisekelo sokuhlaziywa kwephromoshini yezimpahla zezimpahla, esekelwe izinga lokukhula emakethe kanye nesabelo sabo endaweni ethile yamakethe.

I-Excel inezintandokazi eziningi phakathi kwabathengisi, abacwaningi nabathengi, hhayi okungenani ngenxa yamathuluzi ayo amakhulu okwenza izibalo ezehlukene zezimali. Ngokuyinhloko imisebenzi yalokhu kugxile inikezwa eqenjini lemisebenzi yezimali. Eziningi zazo zingabasiza hhayi kuphela ochwepheshe, kodwa nakwabasebenzi ezimbonini ezihlobene, kanye nabasebenzisi abajwayelekile ezindabeni zabo zansuku zonke.

I-module iyigugu elihle kunoma iyiphi inombolo. Ngisho nenani elibi lizohlala linemodemu enhle. Ake sithole ukuthi singakanani ukubala inani le-module ku-Microsoft Excel. Umsebenzi we-ABS Ukubala inani le-module ku-Excel, kunomsebenzi okhethekile obizwa nge-ABS.

Njengoba wazi, encwadini ye-Excel kukhona amathuba okudala amashidi amaningana. Ngaphezu kwalokho, izilungiselelo ezizenzakalelayo zibekwe ukuze idokhumenti isivele inezici ezintathu uma idalwe. Kodwa, kunamacala abasebenzisi okudingeka basuse amanye amashidi wedatha noma abangenalutho ukuze bangabaphazamisi. Ake sibone ukuthi lokhu kungenziwa kanjani ngezindlela ezihlukahlukene.

Ukufaka ukuvikelwa kumafayela we-Excel kuyindlela enhle yokuzivikela kuzo zombili izigebengu kanye nezenzo zakho ezimbi. Inkinga ukuthi akubona bonke abasebenzisi abakwaziyo ukususa ilokhi, ukuze kuthi uma kunesidingo, bakwazi ukuhlela ibhuku noma ngisho nokubuka okuqukethwe kwayo.

Ngaphambi kokuthatha isikweletu, kuyoba kuhle ukubala zonke izinkokhelo kuso. Lokhu kuzosindisa obolekayo esikhathini esizayo kusuka ezinkingeni ezihlukahlukene ezingalindelekile nokudumazeka uma kuvela ukuthi ukukhokhelwa ngokweqile kukhulu kakhulu. Amathuluzi we-Excel angasiza kulokhu kubalwa. Ake sithole ukuthi singakwazi kanjani ukubala izinkokhelo zemalimboleko yesikweletu kulolu hlelo.

Amadokhumenti wombhalo we-CSV asetshenziswa yizinhlelo eziningi zekhompyutha ukushintshanisa idatha phakathi komunye nomunye. Kubonakala sengathi ku-Excel kungenzeka ukuthi uqalise ifayela elinjalo ngokuchofoza okuphindwe kabili kukho inkinobho yegundane lesokunxele, kodwa hhayi njalo kulokhu idatha idluliswa kahle. Iqiniso, kukhona enye indlela yokubuka ulwazi oluqukethwe efayeleni le-CSV.

Enye yemisebenzi engabhekana nomsebenzisi ngenkathi isebenza ku-Excel yengezela isikhathi. Isibonelo, lo mbuzo ungavela ekulungiseleleni ibhalansi yokusebenza isikhathi esimisweni. Izinkinga zihlobene neqiniso lokuthi isikhathi asilinganisiwe ohlelweni lwesimali esaziwayo kithi, lapho i-Excel isebenza ngokuzenzakalelayo.

Ngokuvamile, kufanele udlulise itafula kusuka ku-Microsoft Excel kuya eZwini, kunokuba uhambisane naso, kodwa namanje amacala okudluliswa okungahambisani nawo ayengavamile kakhulu. Isibonelo, ngezinye izikhathi udinga ukudlulisela itafula ku-Excel, eyenziwe ku-Word, ukuze usebenzise umhleli wethebula ukubala idatha.

Enye yamathuluzi amakhulu okuhlaziywa kwezibalo ukubalwa kokuphambuka okujwayelekile. Le nkhomba ikuvumela ukuba wenze ukulinganisa okujwayelekile kwesampula noma inani labantu. Masifunde indlela yokusebenzisa ifomula yokunquma ukuphambuka okujwayelekile ku-Excel.