Ekuphathweni kwesikhathi samanje, kubalulekile ukuba namathuluzi asebenzayo asivumela ukuthi sibale ngokunembayo nangokushesha inani lamahora asetshenziwe. I-Microsoft Excel, enohlu olubanzi lwemisebenzi namandla okwenza izibalo eziyinkimbinkimbi, isiyithuluzi elibaluleke kakhulu kochwepheshe emhlabeni wonke. Kulesi sihloko, sizohlola ukuthi singalisebenzisa kanjani ngokugcwele leli thuluzi elinamandla ukubala inani lamahora asetshenzwe ku-Excel ngobuchwepheshe nangokunembile. Kusukela kumafomula ayisisekelo kuye emisebenzini ethuthukisiwe, sizothola indlela yokwenza lula nokwenza le nqubo ebalulekile ohlelweni lwethu lomsebenzi. Uma ufuna izindlela zokonga isikhathi nokuthuthukisa ukuphathwa kwesikhathi sakho somsebenzi, lesi sihloko ngesakho. Hlanganyela nathi kulolu hambo lwamandla e-Excel futhi uthole ukuthi ubalwa kanjani ngempumelelo inani lamahora asetshenziwe. [END
1. Isingeniso kumshini wokubala wamahora asetshenziwe ku-Excel
Ezweni lomsebenzi, ukubala amahora asetshenziwe kungaba umsebenzi oyisicefe futhi othambekele kumaphutha. Ngenhlanhla, i-Excel inikeza ithuluzi elihle lokwenza le nqubo ibe lula. Kulesi sigaba, sizokufundisa indlela yokusebenzisa umshini wokubala wamahora asetshenziwe ku-Excel, ukuze ukwazi ukugcina irekhodi elinembile nelisebenza kahle lesikhathi sakho somsebenzi.
Ngaphambi kokuqala, kubalulekile ukuqaphela ukuthi ukusebenzisa umshini wokubala wamahora asetshenziwe ku-Excel, uzodinga ulwazi oluyisisekelo lwaleli thuluzi. Uma ungayazi i-Excel, sincoma ukuthi uqale uzijwayeze ngemisebenzi eyisisekelo ngaphambi kokuqhubeka.
Ukuze uqale ukusebenzisa umshini wokubala wamahora asetshenziwe ku-Excel, udinga ukwenza isiqiniseko sokuthi unespredishithi esivuliwe. Okulandelayo, dala ikholomu ye-elementi ngayinye edingekayo ukuze ubale amahora asetshenziwe: idethi, isikhathi sokuqala, isikhathi sokuphela, kanye nesamba samahora asetshenziwe. Bese, faka idatha ehambisanayo kukholamu ngayinye.
2. Ukwakhiwa kwespredishithi ukuze urekhode amahora asetshenziwe
Ukuze ugcine irekhodi elinembile lamahora asetshenziwe, isipredishithi siyithuluzi eliwusizo nelisebenza kahle. Lapha sikubonisa ukuthi usenza kanjani isipredishithi ukuze urekhode amahora asetshenziwe ngendlela elula:
Isinyathelo 1: Vula isipredishithi esisha ohlelweni lwakho oluthandayo, njenge-Excel noma AmaSpredishithi e-Google.
- Uma usebenzisa i-Excel, chofoza "Ifayela" bese ukhetha "Okusha." Bese ukhetha "Isipredishithi" ukuze uvule esisha.
- Uma usebenzisa i-Google AmaSpredishithi, vula i-akhawunti yakho I-Google Drayivu bese uchofoza okuthi “Dala” bese ukhetha “Ispredishithi”.
Isinyathelo 2: Emgqeni wokuqala wespredishithi, dala izihloko zekholomu ngayinye. Ezinye izibonelo zezihloko ezivamile zihlanganisa: “Igama,” “Idethi,” “Isikhathi Sokuqala,” “Isikhathi Sokugcina,” “Isamba Samahora Asetshenziwe.”
Isinyathelo 3: Okulandelayo, emgqeni ngamunye, faka ulwazi oluhambisanayo lwenkambu ngayinye. Khumbula ukuthi ungasebenzisa amafomula ukuze ubale ngokuzenzakalelayo isamba samahora asetshenziwe usebenzisa umsebenzi wesamba. Isibonelo, ungangeza izikhathi zokuqala nezokugcina ukuze uthole isamba samahora asetshenzwe umsebenzi ngamunye.
3. Ukuthwebula isikhathi sokuqala nesokuphela sosuku lomsebenzi
A indlela ephumelelayo wokuthwebula nokuqopha isikhathi sokuqala nesokuphela kosuku lomsebenzi olusetshenziswayo amathuluzi edijithali. Lawa mathuluzi anikeza inzuzo yokwenza inqubo ngokuzenzakalelayo futhi asuse amaphutha angenzeka enziwa ngesandla. Kunezinketho ezahlukene ezitholakalayo emakethe, kokubili mahhala nezikhokhelwayo, ezivumelana nezidingo zenkampani ngayinye. Ngezansi isibonelo sendlela yokusebenzisa elinye lalawa mathuluzi ukuze uthwebule futhi urekhode amahora okusebenza.
1. Landa bese ufaka uhlelo lokusebenza: Okokuqala, kuyadingeka ukulanda futhi ufake uhlelo lokusebenza kudivayisi yesisebenzi ngasinye. Iningi lalezi zinhlelo zokusebenza ziyatholakala kumadivayisi I-iOS ne-Android, okwenza kube lula ukuyisebenzisa kunoma iyiphi inkampani.
2. Setha amahora okusebenza: Lapho uhlelo selufakiwe, isisebenzi ngasinye kufanele silungiselele amashejuli aso okusebenza. Lokhu kuhlanganisa ukukhombisa isikhathi sokuqala nesokuphela kosuku lwakho, kanye namakhefu noma amakhefu azothathwa phakathi nosuku. Lokhu kumisa kwenziwa okomuntu siqu futhi kungashintshwa noma nini ngokwezidingo zesisebenzi.
4. Ifomethi yosuku nesikhathi ku-Excel ukuze kubalwe amahora anembile
Ku-Excel, idethi nefomethi yesikhathi ibalulekile ekubaleni isikhathi okunembile. Uma ingafomethiwe kahle, i-Excel ingatolika amadethi nezikhathi ngokungalungile, okungaholela emaphutheni ezibalo. Lapha sizokukhombisa ukuthi ungasebenzisa kanjani ifomethi yedethi nesikhathi ngendlela efanele ukuze uqinisekise ukunemba ezibalweni zakho.
1. Khetha iseli noma ububanzi bamaseli ofuna ukuba nefomethi yedethi nesikhathi. Bese, uchofoza kwesokudla bese ukhetha "Fometha Amaseli" kumenyu yokudonsela phansi. Iwindi le-pop-up lizovela.
2. Efasiteleni le-pop-up, khetha isigaba "Inombolo" kuthebhu "Inombolo", bese ukhetha inketho "Yosuku" ohlwini lwefomethi. Lapha uzothola izinketho ezahlukene zamafomethi edethi achazwe ngaphambilini.
3. Uma ingekho ifomethi echazwe ngaphambilini elingana nezidingo zakho, ungenza ngendlela oyifisayo ifomethi yedethi nesikhathi. Ukuze wenze lokhu, khetha inketho ethi "Custom" ohlwini lwamafomethi. Inkundla yombhalo izovela lapho ongafaka khona ifomethi yakho.
Khumbula ukuthi ifomethi idethi nesikhathi ku-Excel Ingase yehluke kuye ngezilungiselelo zesifunda zesistimu yakho. Futhi, khumbula ukuthi izinsuku ku-Excel zimelelwa izinombolo, lapho inombolo yonke imelela usuku kanye nengxenye yedesimali imele isikhathi. Inikezwe lawa macebiso, uzokwazi ukusebenzisa ifomethi yedethi nesikhathi ku-Excel ngendlela efanele futhi wenze izibalo ezinembile zesikhathi.
5. Ungabala kanjani amahora okusebenza nsuku zonke ku-Excel
Lapho ubala amahora omsebenzi wansuku zonke ku-Excel, kunamafomula nemisebenzi eminingi engakusiza wenze lo msebenzi ngokushesha nakalula. Okulandelayo, ngizokukhombisa izinyathelo okufanele uzilandele ukuze ubale amahora okusebenza nsuku zonke ku-Excel:
Isinyathelo 1: Vula idokhumenti entsha ye-Excel bese udala ithebula elinamakholomu ahambisana nedethi yokuqala, isikhathi sokuqala, idethi yokuphela, nesikhathi sokuphela sosuku ngalunye lomsebenzi.
Isinyathelo 2: Kukholomu eyengeziwe, bala umehluko wesikhathi phakathi kwesikhathi sokuqala nesikhathi sokugcina usebenzisa umsebenzi othi «=KHIPHA«. Lo msebenzi uzokuvumela ukuthi uthole inani lamahora owasebenza usuku ngalunye.
Isinyathelo 3: Ukuze uthole isamba esiphelele samahora asetshenziwe esikhathini esithile, sebenzisa umsebenzi othi «=ISUM«. Khetha amaseli aqukethe amanani asetshenziwe amahora futhi i-Excel izobala ngokuzenzakalelayo isamba esiphelele.
6. Ukuhlanganisa amahora asetshenzwe isonto lonke lomsebenzi
Ukwengeza amahora asetshenziwe phakathi nesonto lonke lomsebenzi, kubalulekile ukulandela lezi zinyathelo ezilandelayo:
- Thola amarekhodi amahora asetshenziselwe usuku ngalunye lwesonto lomsebenzi. Lawa marekhodi angatholakala ohlelweni lokuphatha isikhathi noma amaspredishithi.
- Qinisekisa ukuthi amarekhodi asesimweni esifanele sesamba. Uma kudingeka, guqulela amalogi abe yifomethi yesikhathi evamile, njengamahora namaminithi.
- Engeza amahora asetshenziselwe usuku ngalunye usebenzisa isibali, isipredishithi, noma ithuluzi lokwengeza isikhathi ku-inthanethi. Qiniseka ukuthi ubala kahle isikhathi esengeziwe noma amahora asetshenzwe ngezinsuku okungezona ezokusebenza.
Uma unenkinga yokwengeza amahora, nanka amathiphu awusizo:
- Qiniseka ukuthi usebenzisa inothi elifanele ukumela amahora asetshenziwe, njengokuthi HH:MM noma HH.MM.
- Uma amahora asetshenziwe angenile amafomethi ahlukene, iguqulela zonke izikhathi kufomethi evamile ngaphambi kokwengeza.
- Cabangela izinhlobo ezahlukene zamahora asetshenziwe, njengamahora avamile, isikhathi esengeziwe, namahora asebusuku, bese wengeza ngokuhlukana uma kunesidingo.
Khumbula ukuthi kubalulekile ukucabangela wonke amahora asetshenziwe phakathi nesonto lomsebenzi ukuze ube nesibalo esinembile samahora esewonke.
7. Ukubalwa kwesikhathi esengeziwe ku-Excel
Ukuze ubale isikhathi esengeziwe ku-Excel, udinga ukulandela izinyathelo ezimbalwa ezibalulekile. Ngenhlanhla, i-Excel inikeza amathuluzi nemisebenzi eyenza lesi sibalo sibe lula. Lapha sizochaza ukuthi kwenziwa kanjani Igxathu emvakwe gxathu.
Okokuqala, kubalulekile ukuba nedatha edingekayo ukuze wenze ukubala. Qiniseka ukuthi unekholomu enezinsuku kanye nenye enamahora asetshenzwe ngosuku. Uma usunalo lolu lwazi, ungaqhubeka nokubala isikhathi esengeziwe.
Ungasebenzisa umsebenzi we-SUMIF ukuze uthole isamba samahora asetshenzwe ebangeni elithile. Isibonelo, uma ufuna ukubala amahora esikhathi esengeziwe somsebenzi enyangeni ethile, ungasebenzisa ifomula =SUMAR.SI(rango_fecha;"=mes_a_calcular"), lapho “idethi_range” imelela ibanga ledethi kanye “nenyanga_to_ukubala” idethi yenyanga ofuna ukubala ngayo isikhathi esengeziwe. Uma usulitholile isamba samahora asetshenziwe, ungasusa inani lamahora asungulwe kunkontileka ukuze uthole amahora wesikhathi esengeziwe.
8. Uwakhipha kanjani amahora okuphumula emahoreni asetshenziwe ku-Excel
Ku-Excel, ukususa amahora okuphumula emahoreni asetshenziwe kungaba inqubo elula ngokulandela izinyathelo ezimbalwa. Lapha sizokukhombisa ukuthi ungakwenza kanjani:
1. Kuspredishithi se-Excel, dala ikholomu yamahora asetshenziwe kanye nenye ikholomu yamahora okuphumula. Qiniseka ukuthi lawa makholomu afomethwe njengamahora, ngaphandle kwalokho i-Excel ngeke ikwazi ukwenza izibalo ngendlela efanele.
2. Kuseli lapho ufuna ukuthola khona umphumela wokukhipha, sebenzisa ifomula =ISUM(iseli elisebenza amahora) - UKWENGEZA(iseli lamahora okuphumula). Lokhu kuzosusa isamba samahora okuphumula engqikithini yamahora asetshenziwe futhi kukunike umphumela oyifunayo.
3. Ukuqinisekisa ukuthi umphumela uboniswa ngendlela efanele nefomethi yesikhathi, khetha iseli enomphumela bese usebenzisa ifomethi yesikhathi efanele. Ungakwenza lokhu ngokuchofoza kwesokudla kuseli, ukhethe okuthi “Fometha Amaseli,” ukhethe “Isikhathi” ohlwini lokudonsela phansi, bese ukhetha ifomethi oyifunayo.
9. Umsebenzi we-SUMIF wokubala ngokuzenzakalelayo inani lamahora asetshenziwe
Umsebenzi we-SUMIF ku-Excel uyithuluzi eliwusizo kakhulu lokubala ngokuzenzakalelayo ingqikithi yamahora asetshenzwe umsebenzi. Lo msebenzi ukuvumela ukuthi useshe inani elithile kububanzi bamaseli futhi wengeze amanani ahambisana nalowo mbandela. Kithina, sizosebenzisa umsebenzi we-SUMIF ukwengeza amahora asetshenzwe isisebenzi esikhathini esithile esinikeziwe.
Ukuze sisebenzise umsebenzi we-SUMIF, kufanele siqale sibe nedatha ehlelwe kuspredishithi se-Excel. Kukholomu A, sizobeka amagama abasebenzi futhi kukholamu B, amahora asetshenzwe yilowo nalowo. Okulandelayo, sizokhetha iseli lapho sifuna ukuthi umphumela ophelele wamahora asetshenziwe uvele futhi sisebenzise ifomula ethi =SUMIF(igama, igama, ibanga lehora) ukubala isamba samahora asetshenzwe isisebenzi esithile .
Kubalulekile ukukhumbula ukuthi ifomula yokusebenza ye-SUMIF kufanele ifakwe ngendlela efanele. Ibanga legama nobubanzi besikhathi kufanele kube nenani elifanayo lemigqa futhi kufanele kucaciswe kahle. Ukwengeza, igama elisetshenziswa njengemibandela kufanele libhalwe ngokufana ncamashi negama elivela kububanzi bamagama. Uma ifomula ifakwe kahle, umphumela uzobonisa inani lamahora asetshenzwe isisebenzi esithile esikhathini esinikeziwe. Khumbula ukuthi ungasebenzisa izihlungi ezizenzakalelayo ukuze uhlunge idatha futhi wenze kube lula ukucinga amagama athile.
10. Ukusebenzisa ifomethi yeseli yangokwezifiso ukukhombisa inani lamahora asetshenziwe
AmaSpredishithi anikezela ngezinketho eziningi zokufometha ukuze wenze ngendlela oyifisayo izici ezihlukene zesipredishithi sakho. idatha yakho. Enye yalezi zinketho ifomethi yeseli yangokwezifiso, ekuvumela ukuthi ubonise inani lamahora asetshenzwe ngefomethi ethile. Lapha sikubonisa ukuthi ungasebenzisa kanjani lesi sici ukuze uthuthukise ukwethulwa kwedatha yakho.
1. Okokuqala, khetha amaseli aqukethe idatha yamahora asetshenziwe.
2. Okulandelayo, chofoza kwesokudla bese ukhetha inketho ethi “Fometha Amaseli” kumenyu yokudonsela phansi.
3. Iwindi lizovuleka elinamathebhu ahlukene, khetha ithebhu "Inombolo". Lapha uzothola uhlu lwezigaba zefomethi, khetha "Custom" ezansi ohlwini.
4. Manje, esigabeni "Uhlobo", uzobona ibhokisi lombhalo elinochungechunge lwamakhodi okufometha azenzakalelayo. Ungasebenzisa lawa makhodi njengesiqalo ukuze udale ifomethi yakho yangokwezifiso.
5. Isibonelo, uma ufuna ukubonisa amahora asetshenzwe ngefomethi ethi “HH:MM”, ungasebenzisa ikhodi elandelayo: hh:mm. Lokhu kuzobonisa amahora ngefomethi yamahora angama-24 kanye namaminithi.
6. Uma usuyifakile ikhodi yokufometha oyifunayo, chofoza okuthi “KULUNGILE” ukuze usebenzise ukufometha kumaseli akhethiwe.
Ngefomethi yeseli yangokwezifiso, ungakwazi ukubuka inombolo yamahora asetshenziwe ngendlela enembile neqondakala kalula. Linga ngamafomethi ahlukene futhi uthole evumelana kangcono nezidingo zakho! Khumbula ukuthi ungasebenzisa futhi lo msebenzi ukuze usebenzise amanye amafomethi angokwezifiso, njengamaphesenti, amadethi noma uhlobo lwemali Amathuba awapheli!
11. Ungasibala kanjani isikhathi esiqoqiwe kuze kube yidethi yamanje ku-Excel
Uma udinga ukubala isikhathi esiqoqiwe kuze kube yidethi yamanje ku-Excel, kunezindlela ezimbalwa zokwenza. Ngezansi, sethula indlela yesinyathelo ngesinyathelo ukuxazulula le nkinga ngendlela elula nephumelelayo.
1. Thola idethi yamanje: Ukuze uqale, kufanele ufake ifomula ethi “=NAMUHLA()” kuseli lapho ofuna ukubonisa khona idethi yamanje. Le fomula izobuyisela idethi yesistimu yamanje.
2. Susa izinsuku ezifanele: Okulandelayo, uzodinga ukukhipha amadethi anqwabelene ngaphambi kwedethi yamanje. Ake sicabange ukuthi izinsuku ezifanele zikukholomu A. Ukuze ukhiphe idethi yamanje osukwini oluthile kuseli A2, kufanele ufake ifomula ethi “=TODAY()-A2”. Le fomula izobala ngokuzenzakalelayo umehluko wezinsuku phakathi kwedethi yamanje nedethi ekuseli A2. Ungakwazi ukuhudulela le fomula phansi ukuze uyisebenzise kuwo wonke amaseli kukholomu A lapho ofake khona amadethi eqoqo.
3. Fometha umphumela: Ekugcineni, ungafometha ikholomu ebonisa isikhathi esiqoqiwe. Ukuze wenze lokhu, khetha ikholomu yemiphumela bese uchofoza kwesokudla. Bese, khetha “Fometha Amaseli” bese ukhetha ifomethi oyifunayo, kungaba “Inombolo”, “Okuvamile” noma “Ngokwezifiso”. Ngale ndlela, uzokwazi ukubuka isikhathi esiqoqiwe ngendlela efanele.
12. Ifomula yokubala isikhathi seholide noma ukungabikho ku-Excel
Ukuze ubale isikhathi seholide noma sokungabikho ku-Excel, ungalandela lezi zinyathelo ezilula:
- Vula ifayela elisha le-Excel bese udala ikholomu ukuze urekhode izinsuku zokuqala nezokugcina zokuvakasha noma zokungabikho. Ungasebenzisa amakholomu A no-B ngale njongo.
- Kukholomu C, khipha idethi yokuqala kusukela osukwini lokugcina usebenzisa ifomula elandelayo:
=B2-A2(lapho i-B2 iyiseli eliqukethe idethi yokugcina futhi u-A2 iyiseli eliqukethe idethi yokuqala). - Fometha iseli kukholamu C njengobude besikhathi ngokukhetha inketho ethi “Ubude besikhathi” kuthebhu yefomethi yeseli.
Uma usulandele lezi zinyathelo, uzokwazi ukubala kalula isikhathi seholide noma sokungabikho ku-Excel. Khumbula ukuthi ungahudulela ifomula phansi ukuze ubale isikhathi seholide noma sokungabikho kwamarekhodi amaningi.
Uma ufuna ukuthola ingqikithi yesikhathi seholide noma sokungabikho kohlu lwezinsuku, ungasebenzisa umsebenzi we-SUM ku-Excel. Vele ukhethe iseli lapho ofuna ukubonisa khona inani bese usebenzisa ifomula =SUMA(C2:C10), kucatshangelwa ukuthi i-C2 iyiseli lokuqala kukholamu C lapho kutholakala khona isikhathi seholide noma sokungabikho, futhi i-C10 iyiseli lokugcina. Lokhu kuzokubonisa isamba esiphelele sesikhathi seholide noma ukungabikho kwalolo banga.
13. Amahora okulandelela asetshenzwe iphrojekthi ku-Excel
Ukulandelela amahora asetshenzwe iphrojekthi ku-Excel kungaba umsebenzi owusizo kakhulu ukugcina irekhodi elinembile lesikhathi esichithwe kumsebenzi ngamunye. Okulandelayo, izinyathelo ezidingekayo zizokwethulwa ukwenza lokhu kuqapha kwe indlela ephumelelayo:
1. Dala isipredishithi ku-Excel: Ukuze uqale, udinga ukuvula ifayela elisha le-Excel bese udala isipredishithi ukuze urekhode amahora asetshenziwe. Kutuswa ukuthi unikeze amakholomu egama lephrojekthi, idethi, amahora achithwe, kanye nanoma yiluphi olunye ulwazi olubalulekile.
2. Rekhoda amahora asetshenziwe: Emgqeni ngamunye we-spreadsheet, ulwazi oluhambisana nehora ngalinye elisetshenziwe kufanele lifakwe. Ifomethi yedethi nesikhathi ingasetshenziswa ukusiza ukurekhoda. Ukwengeza, ifomula ingasetshenziswa ukubala ngokuzenzakalelayo inani lamahora asetshenziswe kuphrojekthi ngayinye, okuzokwenza kube lula inqubo yokulandelela.
3. Khiqiza imibiko nokuhlaziya: Uma ukuqoshwa kwamahora asetshenziwe sekuqediwe, kungenzeka ukukhiqiza imibiko nokuhlaziya ukuhlola ukuqhubeka kwephrojekthi ngayinye. Lokhu kungenziwa kusetshenziswa amathuluzi okuhlunga nokushadi atholakala ku-Excel. Le mibiko izoba usizo kakhulu ekuhlonzeni ukuchezuka okungenzeka ngesikhathi esihleliwe nokwenza izinguquko uma kunesidingo.
Ukulandelela amahora asetshenziswe iphrojekthi ku-Excel kuwumsebenzi olula onganikeza izinzuzo eziningi ekuphathweni kwesikhathi nasekulawuleni iphrojekthi. Ngokulandela lezi zinyathelo, uzokwazi ukugcina irekhodi elinembile neliningiliziwe lamahora asetshenziswe kuphrojekthi ngayinye, okuzokwenza kube lula ukwenza izinqumo nokuhlola inqubekelaphambili. Ungakhohlwa ukusebenzisa amathuluzi nemisebenzi etholakala ku-Excel ukusheshisa nokwenza le nqubo ngokuzenzakalelayo. Ungalindi futhi bese uqala ukusebenzisa leli thuluzi lokulandelela elisebenzayo!
14. Ukuthumela amahora asetshenziwe idatha evela kwa-Excel ukuze ihlaziywe noma ikhokhelwe
Ukuhlaziywa kwamahora asetshenziwe kuyisinyathelo esibalulekile sokuhlola ukusebenza komsebenzi nokubala iholo labasebenzi benhlangano. Ngalo mqondo, i-Excel inikeza isisombululo esisebenzayo sokuthekelisa idatha ngamahora asetshenziwe futhi yenze kube lula ukuhlaziya noma ukusetshenziswa ekubalweni kweholo. Okulandelayo, izinyathelo ezidingekayo zokwenza lokhu kuthunyelwa kwedatha zizochazwa kabanzi. ngempumelelo.
1. Ukusethwa Kweshidi le-Excel: Ukuqala, kubalulekile ukuqinisekisa ukuthi ishidi le-Excel limiswe kahle ukuze likhiphe idatha esetshenziwe ngesikhathi. Kunconywa ukuthi usebenzise amakholomu athile edethi, isikhathi sokuqala, nesikhathi sokuphela sosuku ngalunye lomsebenzi.
2. Ukuhlela idatha: Uma ishidi le-Excel selimisiwe, yisikhathi sokuhlela idatha yamahora asetshenziwe. Kuphakanyiswa ukuthi kusetshenziswe umugqa owodwa ngosuku ngalunye lomsebenzi kanye nekholomu eyodwa kunkambu yolwazi ngayinye (idethi, isikhathi sokuqala, isikhathi sokuphela, njll.). Ngokufanayo, kubalulekile ukuqinisekisa ukuthi idatha iphelele futhi ayinaphutha.
3. Ukuthunyelwa kwedatha: ekugcineni, ungaqhubeka nokuthekelisa idatha yamahora asetshenziwe. I-Excel inikeza izinketho ezahlukene zokwenza lo msebenzi, njengokugcina ifayela ngefomethi ehambisana nezinye izinhlelo zokuhlaziya noma ukukhiqiza umbiko onemininingwane Ifomethi ye-PDF. Kutuswa ukucwaninga nokusebenzisa inketho efaneleka kangcono iholo lenhlangano noma izidingo zezibalo.
Khumbula ukuthi ukuthunyelwa okulungile kwedatha yamahora asetshenziwe kusuka ku-Excel kuzovumela ukuhlaziya okunembe kakhudlwana kanye nokuphathwa kahle kweholo labasebenzi. Landela lezi zinyathelo ezishiwo ngenhla futhi usebenzise ngokugcwele amakhono e-Excel. Uzothola imiphumela esheshayo nenembile ukuze uthuthukise ukusebenza kwenhlangano yakho!
Sengiphetha, i-Excel inikeza indlela ephumelelayo nenembile yokubala inani lamahora asetshenziwe. Ngokusebenzisa imisebenzi namafomula afanelekile, kungenzeka ukwenza izibalo ezizenzakalelayo ezonga isikhathi futhi zinciphise amaphutha. Ngokunokwenzeka kokufaka okuguquguqukayo okufana nesikhathi esengeziwe, izinsuku ezingezona ezokusebenza kanye namashifu ahlukene okusebenza, i-Excel ikuvumela ukuba uvumelane nezidingo ezithile zesimo ngasinye somsebenzi. Ngaphezu kwalokho, ikhono lokukhiqiza imibiko namagrafu ngokusekelwe ekubalweni okwenziwe kwenza kube lula ukuhlaziya nokulandelela isikhathi esichithwe ukusebenza.
Ngamafuphi, ukufunda ukubala inani lamahora asetshenziwe ku-Excel kungaba ikhono elibalulekile kulabo abafuna ukuthuthukisa ukuphathwa kwesikhathi endaweni yabo yokusebenza. Ngokuzijwayeza okuncane nolwazi lwemisebenzi eyisisekelo, noma ubani angazuza ezinhlelweni ezinikezwa yileli thuluzi lokubala elinamandla.
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.