I-Excel

Lapho usebenza ngamatrices, ngezinye izikhathi udinga ukuwahambisa, okungukuthi, ngamazwi alula, uwaphendule. Yiqiniso, ungaphazamisa idatha ngesandla, kodwa i-Excel inikeza izindlela eziningana zokwenza kube lula futhi ngokushesha. Ake siwaphule phansi ngokuningiliziwe. Inqubo yokudlulisa Ukudlulisa i-matrix kuyinkqubo yokushintsha amakholomu nemigqa ezindaweni.

Umsebenzi wokuthutha kuwumsebenzi wokuthola indlela enhle kakhulu yokuthutha izimpahla zohlobo olufanayo kusuka kumphakeli kumthengi. Isisekelo saso siyisibonelo esetshenziswa kabanzi emikhakheni ehlukene yezibalo kanye nezomnotho. Ku-Microsoft Excel, kunezindlela ezisiza kakhulu isixazululo senkinga yokuthutha.

Phakathi kwezinhlobo eziningi zamashadi angakhiwa usebenzisa i-Microsoft Excel, ishadi le-Gantt kufanele liqokonyiswe ngokukhethekile. Kuyinto ishadi bar enezingqimba, kwi-axis enezingqimba yayo, umugqa wesikhathi sitholakala. Ngosizo lwalo, kulula kakhulu ukubala, nokunquma ngokuqondile, isikhathi esithile.

Uma usebenzisa uhlobo olufanayo lwedatha olubekwe kumathebula ahlukene, amashidi, noma ngisho nezincwadi, ukuze kube lula kokubona, kungcono ukuqoqa ulwazi ndawonye. Ku-Microsoft Excel ungabhekana nalo msebenzi ngosizo lwethuluzi elikhethekile elibizwa ngokuthi "Ukuhlanganiswa". Ihlinzeka ikhono lokuqoqa idatha engafani etafuleni elilodwa.

Uma usebenza netafula noma ulwazi oluthe xaxa ngolwazi oluningi, kungenzeka ukuthi amanye amarowu aphindaphindiwe. Lokhu kukhulisa ngokwengeziwe uhlu lwamanani. Ngaphezu kwalokho, phambi kwama-duplicates, ukubalwa okungalungile kwemiphumela emafomula kungenzeka. Ake sibone ukuthi singathola kanjani futhi sisuse imigqa emibili e-Microsoft Excel.

Ukuhlaziywa kwe-Correlation - indlela evamile yokucwaninga ngezibalo, esetshenziselwa ukukhomba izinga lokuxhomekeka kwesinye isibonakaliso kwesinye. I-Microsoft Excel inethuluzi elikhethekile elenzelwe ukwenza lolu hlobo lokuhlaziywa. Ake sithole ukuthi singayisebenzisa kanjani lesi sici.

Uma usebenzisa ama-spreadsheets e-Excel, ngezinye izikhathi kudingekile ukuhlukanisa iseli elithile zibe izingxenye ezimbili. Kodwa, akulula njengoba kubonakala ekuqaleni. Ake sibone indlela yokuhlukanisa iseli zibe izingxenye ezimbili ku-Microsoft Excel, nokuthi ungayahlukanisa kanjani. Ukuhlukaniswa kwamaseli Masinyane kufanele kuqashelwe ukuthi amaseli aseMicrosoft Excel yizona zakhi eziyinhloko zesakhiwo, futhi azikwazi ukuhlukaniswa zibe izingxenye ezincane, uma kungenjalo ukuhlanganiswa ngaphambilini.

Ngokuvamile, okuqukethwe kweseli etafuleni akuhambisani nemingcele ebekwe ngokuzenzakalelayo. Kulesi simo, umbuzo wokukhulisa kwawo uba osebenzayo ukuze yonke imininingwane ihambisane nokubuka okuphelele komsebenzisi. Ake sithole ukuthi ungenza kanjani le nqubo ku-Excel.

Ngokuvamile, uma usebenza ku-Excel, kunesidingo sokufaka umbhalo ochazayo eduze komphumela wokubala ifomula, okusiza ukuqonda le datha. Yiqiniso, ungakhetha ikholomu ehlukile yezincazelo, kodwa hhayi kuzo zonke izimo ezengeze izakhi ezengeziwe zizwakalayo.

Ngezinye izikhathi uma udala idokhumenti ngezibalo, umsebenzisi udinga ukufihla amafomula ekuhloleni amehlo. Okokuqala, isidingo esinjalo sibangelwa ukungathandi komsebenzisi kumuntu ongaziwayo ukuqonda isakhiwo somqulu. Ku-Excel, ungafihla amafomula. Sizoqonda ukuthi lokhu kungenziwa kanjani ngezindlela ezihlukahlukene.

Ukukhipha isithakazelo kwinombolo ngesikhathi sokubala izibalo akuyona into engavamile. Isibonelo, ezinkampanini zokuhweba zithatha iphesenti ye-VAT emalini yonke ukuze kubekwe intengo yezimpahla ngaphandle kwe-VAT. Lokhu kwenziwa yizinhlaka ezihlukahlukene zokulawula. Masibuye sibone ukuthi singasusa kanjani iphesenti kusukela kwinombolo ku-Microsoft Excel.

Uma udala amathebula ngolwazi oluthile lwedatha, ngezinye izikhathi kuyadingeka ukusebenzisa ikhalenda. Ngaphezu kwalokho, abanye abasebenzisi bafuna ukuyidala, bayiprinte futhi bayisebenzise ngezinhloso zasekhaya. Uhlelo lwe-Microsoft Office likuvumela ukuba ufake ikhalenda etafuleni noma eshidi ngezindlela eziningana. Ake sithole ukuthi lokhu kungenziwa kanjani.

Kuyaziwa kakhulu ukuthi encwadini eyodwa ye-Excel (ifayela) kukhona ngokuzenzakalelayo amashidi amathathu phakathi kokuthi ungashintsha. Lokhu kwenza kube lula ukudala amadokhumenti amaningana ahlobene efayeleni elilodwa. Kodwa yini okufanele uyenze uma inombolo elandelwe ngaphambilini yamathebhu angeziwe ayanele? Ake sibone ukuthi singeza kanjani into entsha ku-Excel.

Uma usebenza ku-Excel, ngezinye izikhathi kuyadingeka ukuhlanganisa amakholomu amabili noma ngaphezulu. Abanye abasebenzisi abazi ukuthi bangayenza kanjani. Abanye bajwayele kuphela izinketho ezilula. Sizoxoxa ngezindlela ezikhona zokuhlanganisa lezi zakhi, ngoba esimweni ngasinye kunengqondo ukusebenzisa izinketho ezahlukene.

Ngemigqa kukhona amarekhodi anjalo okuqukethwe okuboniswayo lapho ushicilela idokhumenti kumashidi ahlukene endaweni efanayo. Kuyinto elula kakhulu ukusebenzisa leli thuluzi lapho ugcwalisa amagama amatafula nama-caps awo. Kungasetshenziselwa nezinye izinjongo. Ake sibheke indlela yokuhlela amarekhodi anjalo ku-Microsoft Excel.

Lapho usebenza ngemininingwane ye-tabular, kuvame ukudingeka ukubala iphesenti yenombolo, noma ubale iphesenti yenani eliphelele. Lesi sici sinikezwa i-Microsoft Excel. Kodwa, ngeshwa, akuwona wonke umsebenzisi okwazi ukusebenzisa amathuluzi wokusebenza nesithakazelo kulolu hlelo lokusebenza.

Amafayela we-Excel wespredishithi angonakaliswa. Lokhu kungenzeka ngezizathu ezihluke ngokuphelele: ukuhluleka kwamandla ngokushesha ngesikhathi sokusebenza, ukulondolozwa kwamadokhumenti okungalungile, amagciwane wekhompyutha, njll. Yiqiniso, akukubi kakhulu ukulahlekelwa ulwazi olulotshwe ezincwadini ze-Excel. Ngenhlanhla, kunezinketho eziphumelelayo zokuthola kabusha.

Lapho usebenza nedatha, ngokuvamile kunesidingo sokuthola ukuthi indawo eyodwa noma enye inkomba ithatha kuhlu olubanzi. Kuzibalo, lokhu kubizwa ngokuthi kusezingeni. I-Excel ineamathuluzi avumela abasebenzisi ukuba benze le nqubo ngokushesha futhi kalula. Ake sithole ukuthi singayisebenzisa kanjani.

Phakathi kwezinkomba eziningi ezisetshenziselwa izibalo, kudingeka ukhethe ukubalwa kokuhluka. Kumele kuqashelwe ukuthi ukwenza ngokwezifiso lokhu kubalwa kuwumsebenzi onzima kakhulu. Ngenhlanhla, i-Excel inemisebenzi yokwenza inqubo yokubala. Thola i-algorithm yokusebenza ngalawa mathuluzi.

Uma usebenzisa ama-spreadsheet e-Excel, ngezinye izikhathi udinga ukufihla amafomula noma idatha engadingekile okwesikhashana ukuze bangaphazamisi. Kodwa ngokushesha noma ngokuhamba kwesikhathi kufika isikhathi lapho udinga ukulungisa ifomula, noma ulwazi oluqukethwe kumaseli afihliwe, umsebenzisi ngokuzumayo udinga. Yilapho umbuzo wokuthi ungabonisa kanjani izakhi ezifihliwe ziba efanele.