Ungashintsha kanjani ukhefana ube yinkathi ku-Excel

Emhlabeni Ekuphathweni nasekuhlaziyeni idatha ye-Excel, ukumelwa kwezinombolo okulungile kubalulekile ukuze uthole imiphumela enembile nethembekile. Esinye sezici ezivame kakhulu ezidinga ukulungiswa ifomethi yokuhlukanisa idesimali esetshenziswa kumaseli esipredishithi. Emazweni amaningi akhuluma isi-Spanish, ikhoma isetshenziswa njengophawu lwedesimali esikhundleni senkathi. Kulesi sihloko, sizohlola ukuthi ungashintsha kanjani ukhefana ube enkathini ku-Excel, okukuvumela ukuthi usebenze kalula ngefomethi yokumelela izinombolo ezifaneleka kakhulu izidingo zakho zobuchwepheshe [END.

1. Isingeniso sokuguqulwa kokhefana kuya kunkathi ku-Excel

Uma uke wasebenza ngedatha yezinombolo ku-Excel, kungenzeka uhlangabezane nesidingo sokuguqula izinombolo ezibhalwe ngephuzu ledesimali zibe iphuzu ledesimali. Lokhu kuguqulwa kuyadingeka njengoba i-Excel ngokuzenzakalelayo isebenzisa iphoyinti ledesimali esikhundleni sikakhefana. Ngenhlanhla, kunezindlela ezimbalwa zokwenza lokhu kuguqulwa ngokushesha futhi kalula.

Enye inketho yokuguqula ukhefana ube yinkathi ku-Excel ukusebenzisa umsebenzi wokusesha nokufaka esikhundleni. Ukuze wenze lokhu, khetha ikholomu noma ububanzi bamaseli eziqukethe izinombolo okufanele uziguqule. Bese, iya kuthebhu ethi Ikhaya, chofoza okuthi “Thola futhi Khetha” bese ukhetha okuthi “Faka esikhundleni.” Ebhokisini lengxoxo elivelayo, faka ukhefana kunkambu ethi “Thola” kanye nesikhathi kunkambu ethi “Faka esikhundleni”. Chofoza okuthi “Faka esikhundleni Konke” ukuze uguqule zonke izinombolo.

Enye inketho ukusebenzisa isici sokufometha ngokwezifiso se-Excel. Ukuze wenze lokhu, khetha iseli noma ububanzi beseli equkethe izinombolo bese uya kuthebhu ethi Ikhaya. Bese, chofoza inkinobho yefomethi yenombolo bese ukhetha "Amafomethi ezinombolo engeziwe" ezansi ohlwini. Ebhokisini lengxoxo elivelayo, khetha u-“Custom” ohlwini lwezigaba kanye nenkambu yefomethi, faka ifomethi #.###,##. Lokhu kuzoguqula ngokuzenzakalelayo izinombolo ezinephuzu ledesimali zibe iphoyinti ledesimali.

2. Ukuqonda umthelela wokhefana nesikhathi ku-Excel

Iphoyinti lekhoma nedesimali yizici ezimbili ezibalulekile ku-Excel ezingaba nomthelela omkhulu ekuchazeni nasekubalweni kwedatha. Kubalulekile ukuqonda ukuthi zisetshenziswa kanjani ngendlela efanele ukugwema amaphutha nokudideka kumafomula nemiphumela. Lapha sikunikeza umhlahlandlela Igxathu emvakwe gxathu ukuqonda ngokugcwele lesi sihloko.

1. Ukusetha izinketho zesifunda: Kubalulekile ukuqinisekisa ukuthi izinketho zesifunda zisethwe ngendlela efanele ku-Excel. Lokhu Kungenziwa ngolimi kanye nezilungiselelo zendawo engxenyeni yezinketho zohlelo. Lapha ungakhetha ulimi olufunayo kanye nefomethi ehambisanayo yezinombolo nezinsuku.

2. Ukusetshenziswa ngendlela efanele kwekhoma nephoyinti ledesimali: kufanele ukhumbule ukuthi kwamanye amazwe iphuzu lisetshenziswa njengesehlukanisi sedesimali, kanti kwamanye kusetshenziswa ukhefana. Lokhu kungase kuthinte indlela i-Excel ehumusha ngayo idatha. Ukuze ugweme ukudideka, kuyanconywa ukusebenzisa isihlukanisi sedesimali esihambisana nendawo yakho. Uma usebenzisa idatha esebenzisa isihlukanisi sedesimali esiphambene kunesilungiselelwe ku-Excel yakho, ungasebenzisa imisebenzi yokuthola bese ushintshanisa ukuyilungisa.

3. Ukuhlonza amaseli anezihlukanisi zamadesimali ezingalungile

Ukukhomba amaseli anezihlukanisi zamadesimali ezingalungile eshidini ukubala, udinga ukulandela izinyathelo ezibalulekile. Okokuqala, kubalulekile ukuqinisekisa ukuthi izihlukanisi zamadesimali ziyahambisana kuso sonke isipredishithi. Ukuze wenze lokhu, buyekeza amaseli aqukethe izinombolo bese uhlola ukuthi isihlukanisi sedesimali silungile yini, usebenzisa isihlukanisi sedesimali esijwayelekile (inkathi noma ikhoma).

Uma uthola amaseli anezihlukanisi zedesimali ezingalungile, kunezindlela ezimbalwa zoku xazulula le nkinga. Enye inketho ukusebenzisa umsebenzi othi "Faka esikhundleni" ukuze ubeke izihlukanisi zedesimali ezingalungile nezilungile. Isibonelo, uma isihlukanisi sedesimali esingalungile siwukhefana, ungasebenzisa umsebenzi othi “Faka esikhundleni” ukuze ufake ongqi esikhundleni sawo wonke amakhoma. Ungasebenzisa futhi ifomula ukuze uguqule izinombolo ezinezihlukanisi zedesimali ezingalungile zibe izinombolo ezibonwa yisipredishithi.

Enye inketho ukusebenzisa ithuluzi lokufometha elinemibandela ukuze ugqamise ngokuzenzakalelayo amaseli anezihlukanisi zedesimali ezingalungile. Ungasetha umthetho okhomba izinombolo eziqukethe isihlukanisi sedesimali esingalungile futhi uzigqamise ngombala ohlukile. Lokhu kuzokwenza kube lula ukubona nokulungisa amaphutha ngokubona. Futhi, khumbula ukubuyekeza noma yikuphi ukungenisa noma ikhophi yedatha, njengoba izihlukanisi zamadesimali kungenzeka zishintshiwe phakathi nenqubo.

4. Isinyathelo ngesinyathelo: Shintsha ikhoma ibe inkathi ku-Excel ngokwenza

Kwezinye izikhathi, ungase udinge ukushintsha amaphuzu edesimali kusipredishithi se-Excel abe amakhoma, noma okuphambene nalokho, ikakhulukazi uma kuziwa ekungeniseni noma ekukhipheni idatha kwamanye amasistimu noma amazwe asebenzisayo. amafomethi ahlukene iphuzu ledesimali. Ngenhlanhla, i-Excel inikeza indlela elula yokwenza lo msebenzi mathupha, futhi inqubo yesinyathelo ngesinyathelo inemininingwane ngezansi:

1. Vula Ifayela le-Excel lapho ufuna ukushintsha ukhefana ube yinkathi, noma okuphambene nalokho.

2. Khetha amaseli noma uhla lwamaseli aqukethe izinombolo ezinamaphoyinti edesimali noma okhefana ofuna ukuwashintsha.

3. Chofoza kwesokudla amaseli akhethiwe bese ukhetha inketho ethi “Fometha Amaseli” kumenyu yokuqukethwe.

4. Efasiteleni le-pop-up elithi "Fometha Amaseli", khetha ithebhu "Inombolo" uma ingakhethwanga ngokuzenzakalelayo. Bese, khetha isigaba "Inombolo" ohlwini lwezinketho zokufometha.

5. Esigabeni esithi “Izimpawu Zokuhlukanisa”, khetha uphawu lwedesimali ofuna ukulisebenzisa: ichashazi “.” kwezihlukanisi zamadesimali noma ukhefana “,” kuzihlukanisi zamadesimali.

6. Chofoza inkinobho ethi "KULUNGILE" ukuze ulondoloze izinguquko futhi usebenzise ukufometha okusha kumaseli akhethiwe. Manje, amaphuzu edesimali azoshintshwa abe ngokhefana noma ngokuphambene, kuye ngenketho oyikhethile.

Khumbula ukuthi le nqubo ithinta kuphela ukufometha okubonakalayo kwamaseli futhi ayiwashintshi amanani ezinombolo ngokwawo. Futhi qaphela ukuthi le ndlela ingeyesandla futhi ingasetshenziswa ekukhethweni kwamaseli athile noma ku-spreadsheet sonke, kuye ngesidingo sakho. [END

5. Ukwenza ngokuzenzakalelayo ukhefana ube nesikhathi ku-Excel

Ukwenza ngokuzenzakalelayo ukuguqulwa kukakhefana kube isikhathi ku-Excel, ungalandela lezi zinyathelo ezilandelayo:

1. Khetha ikholomu noma ububanzi bamaseli ofuna ukuguqula kuwo. Ungakwenza lokhu ngokuchofoza uhlamvu lwekholomu noma ngokuhudula igundane kububanzi.

2. Kuthebhu ethi “Ekhaya” yemenyu ye-Excel, chofoza okuthi “Thola Futhi Khetha” bese “Faka esikhundleni.” Ungasebenzisa futhi inhlanganisela yokhiye Ctrl + H.

3. Efasiteleni elivelayo, faka ukhefana («,”) endaweni ethi “Sesha” kanye nesikhathi («.”) kunkambu ethi “Faka esikhundleni ngokuthi”. Qiniseka ukuthi zombili izinkambu azinalutho.

4. Chofoza okuthi “Faka esikhundleni Konke” ukuze uguqule ngokuzenzakalela wonke amakhoma abe yizikhathi ebangeni elikhethiwe.

Khumbula ukuthi le ndlela izoshintsha wonke amakhoma abe ongqi ebangeni elikhethiwe. Uma ufuna kuphela ukushintsha ingxenye ethile yamakhoma, ungasebenzisa inketho ethi “Faka esikhundleni” esikhundleni sokuthi “Miselela Konke” bese ukhetha okhefana abathile ofuna ukuwashintsha.

Manje usungakwazi ukushintsha ukhefana ube enkathini ngokuzenzakalelayo ku-Excel ngokushesha futhi kalula. Lokhu kuzokongela isikhathi futhi kuqinisekise ukuvumelana phakathi idatha yakho.

6. Ukusebenzisa amafomula ukushintsha ukhefana ube yinkathi ku-Excel

Ku-Excel, kuvamile ukuthi lapho ungenisa noma ukopisha idatha kweminye imithombo, izinombolo zedesimali zimelelwa ngokhefana esikhundleni samaphuzu. Lokhu kungenza kube nzima ukusebenzisa imisebenzi nezibalo kusipredishithi. Ngenhlanhla, i-Excel inikeza amafomula akuvumela ukuthi uguqule ukhefana ube enkathini ngokuzenzakalelayo, okwenza kube lula ukwenza imisebenzi yezibalo.

Enye yamafomula asetshenziswa kakhulu ukushintsha ukhefana wenkathi umsebenzi othi "SUBSTITUTE". Lo msebenzi ikuvumela ukuthi umiselele uhlamvu olulodwa esikhundleni solunye kuseli enikeziwe. Ukuze siguqule ukhefana ube enkathini, kufanele sisebenzise ifomula ethi "=SUBSTITUTE(iseli_umsuka, ",", ".")", lapho "iseli_lomsuka" kuyiseli eliqukethe inombolo enokhefana. Le fomula ithatha indawo yawo wonke amakhoma ngongqi kuseli elikhethiwe.

Enye inketho ukusebenzisa umsebenzi othi "REPLACE". Lo msebenzi uyafana nomsebenzi we-"SUBSTITUTE", kodwa usivumela ukuthi simiselele isethi eyodwa yezinhlamvu ngesinye kuseli elinikeziwe. Ukuze siguqule ukhefana ube enkathini, singasebenzisa ifomula ethi "=REPLACE(iseli_lomsuka, THOLA(«,", iseli_lomsuka), 1, ".")", lapho "iseli_lomsuka" kuyiseli eliqukethe inombolo enokhefana. . Le fomula ithola indawo yekhoma kuseli futhi ifake esikhundleni sayo isikhathi. Kubalulekile ukuqaphela ukuthi ishintsha kuphela ukhefana wokuqala otholakala kuseli.

Ngokulandela lezi zinyathelo, ungashintsha ukhefana ube enkathini ku-Excel ngokushesha futhi kalula. Lawa mafomula awusizo ikakhulukazi lapho usebenza nenani elikhulu ledatha engenisiwe noma ekopishwe ivela kweminye imithombo. Ngaphezu kwalokho, bazokuvumela ukuba wenze izibalo nemisebenzi yezibalo ngaphandle kwezinkinga. Khumbula ukuthi ungasebenzisa lawa mafomula ngokuhlanganisa neminye imisebenzi ye-Excel ukuze uthole imiphumela enembe nakakhulu.

7. Amathuluzi nezengezo ukusiza ukuguqulwa ku-Excel

Kunezinhlobo ezahlukene amathuluzi nama-plugin ezingakusiza ukuthi wenze lula ukuguqulwa kwe idatha ku-excel, ngaleyo ndlela wenze lula imisebenzi yakho yansuku zonke. Nazi ezinye izinketho ongase uzicabangele:

• Umbuzo Wamandla: Leli thuluzi le-Excel likuvumela ukuthi uhlanganise, uguqule futhi uhlele kabusha idatha evela emithonjeni ehlukene. Ngokusebenza kwayo okunembile, ungenza kalula imisebenzi yokuguqula njengokuhlukanisa umbhalo, ukuhlanganisa amakholomu nokushintsha amafomethi.
• Guqula umbhalo ube amakholomu: I-Excel inomsebenzi okuvumela ukuthi uguqule umbhalo ohlukaniswe i-delimiter ube amakholomu ngamanye. Lesi sici siwusizo ikakhulukazi uma udinga ukuhlukanisa idatha kumaseli kumakholomu amaningi, njengamakheli, amagama aphelele, noma izinombolo zocingo.
• Amafomula okuguqulwa: I-Excel inikezela ngezinhlobo eziningi zamafomula enza ukuguqulwa kwedatha kube lula. Isibonelo, ifomula CONVERT ikuvumela ukuthi uguqule amayunithi okulinganisa afana namakhilogremu abe amaphawundi noma amamitha kuya ezinyaweni. Ukwengeza, ungasebenzisa imisebenzi efana ne-TEXT, DATE, kanye no-TIME ukuze uguqule ifomethi yamadethi, izinombolo, noma umbhalo kumaspredishithi akho.

Ngokungeziwe kulawa mathuluzi omdabu we-Excel nemisebenzi, ungathola futhi complementos de terceros ezengeza ukusebenza okwengeziwe kuhlelo lokusebenza. Isibonelo, kukhona ama-plugin aklanyelwe ngqo ukuguqula izimali, amayunithi okulinganisa, noma ngisho nokukhiqiza amashadi athuthuke kakhulu namathebula e-pivot.

Khumbula ukuthi lawa mathuluzi nezengezo zingahluka kuye ngenguqulo ye-Excel oyisebenzisayo, ngakho-ke kuyalulekwa ukuthi uhlole ukuhambisana ngaphambi kokuyifaka. Hlola izinketho ezitholakalayo bese ukhetha amathuluzi afaneleka kangcono izidingo zakho, uzobona ukuthi uzokwenza kanjani ukuguqula idatha ku-Excel kube lula!

8. Ungazigwema kanjani izinkinga zesikhathi esizayo lapho ushintsha ukhefana ube yinkathi ku-Excel

Lapho ushintsha ukhefana ube enkathini ku-Excel, kubalulekile ukugcina ukucatshangelwa okuthile ukuze ugweme izinkinga zedatha zesikhathi esizayo. Ngezansi, sethula amathiphu kanye nezixazululo zesinyathelo nesinyathelo ukugwema izinkinga lapho ushintsha izihlukanisi zamadesimali.

1. Sebenzisa umsebenzi we-VLOOKUP ukuze uhlonze futhi ulungise amaseli ngokhefana. Lo msebenzi uzokuvumela ukuthi useshe inani elithile kukholamu eyodwa bese ubuyisela inani elihambisanayo lisuka kwenye ikholomu. Ngale ndlela, ungakwazi ukuhlonza ngokushesha amaseli ngokhefana futhi esikhundleni sawo ufake izikhathi.

2. Sebenzisa umyalo we-Excel othi "Thola bese Ufaka esikhundleni". Leli thuluzi liwusizo kakhulu ekwenzeni izinguquko ezinkulu kudatha futhi lizokuvumela ukuthi umiselele wonke okhefana ubeke izikhathi ngokushesha futhi kalula. Vele ukhethe ububanzi bamaseli athintekile, chofoza okuthi “Thola futhi Umiselele” kumenyu ethi “Ekhaya”, futhi ucacise ukhefana njengenani okufanele liseshwe kanye nesikhathi njengevelu yokumiselela.

3. Khumbula ukusebenzisa ukufometha okufanele kumaseli. Ngemva kokufaka okhefana ngongqi, kubalulekile ukuqinisekisa ukuthi ukufometha kweseli kulungile ukugwema izinkinga ezizayo. Khetha amaseli athintekile, chofoza kwesokudla bese ukhetha okuthi “Fometha Amaseli.” Bese, khetha isigaba "Inombolo" bese ukhetha ifomethi yedesimali oyifunayo.

9. Isixazululo samaphutha avamile lapho ushintsha isihlukanisi sedesimali ku-Excel

Lapho ushintsha isihlukanisi sedesimali ku-Excel, kuvamile ukuhlangana namaphutha angathinta ukwethulwa nokubalwa kwedatha. Okulandelayo, sizokukhombisa ukuthi ungawaxazulula kanjani amaphutha avame kakhulu angavela lapho ushintsha isihlukanisi sedesimali ku-Excel:

Iphutha 1: Ushintsho lokuhlukaniswa kwedesimali olungalungiselelwe kahle

Uma ngemva kokushintsha isihlukanisi sedesimali ku-Excel, izinombolo azivezwanga ngendlela efanele, ushintsho kungenzeka alulungiswanga kahle. Ukuze ulungise le nkinga, landela lezi zinyathelo:

• Khetha amaseli anezinombolo ezithintekile.
• Chofoza kwesokudla bese ukhetha "Fometha Amaseli."
• Kuthebhu "Inombolo", khetha isigaba "Ngokwezifiso".
• Ebhokisini elithi "Uhlobo", faka inombolo yefomethi efanele, isibonelo, "#,##0.00" uma ufuna ukusebenzisa izindawo ezimbili zamadesimali.

Iphutha 2: Izibalo ezingalungile

Ngemva kokushintsha isihlukanisi sedesimali, izibalo ku-Excel zingenziwa ngokungalungile. Ukuze ulungise le nkinga, landela lezi zinyathelo:

• Hlola ukuthi izinombolo kumaseli athintekile zikufomethi elungile yini. Uma kungenjalo, landela izinyathelo ezishiwo ngenhla ukuze ushintshe ifomethi yeseli.
• Qiniseka ukuthi amafomula kumaseli wokubala nawo asebenzisa isihlukanisi sedesimali esilungile. Ungakwenza lokhu ngokukhetha amaseli efomula bese uchofoza okuthi “Faka esikhundleni” kuthebhu ethi “Ekhaya”.
• Ebhokisini lengxoxo elithi “Faka esikhundleni”, faka isihlukanisi sedesimali esingalungile kunkambu ethi “Thola” kanye nesihlukanisi esilungile sedesimali kunkambu ethi “Faka esikhundleni nge”. Chofoza okuthi “Faka esikhundleni Konke” ukuze ushintshe zonke izihlukanisi zamadesimali ezingalungile kumafomula.

Iphutha 3: Ukungahambisani ne ezinye izinhlelo

Lapho ushintsha isihlukanisi sedesimali ku-Excel, ungase uhlangabezane nokungahambelani nezinye izinhlelo noma amasistimu asebenzisa isihlukanisi sedesimali esihlukile. Ukuze uxazulule le nkinga, ungacabangela izinketho ezilandelayo:

• Sebenzisa ukufometha okufanele lapho ukhipha noma ungenisa idatha phakathi kwezinhlelo noma amasistimu.
• Sebenzisa amathuluzi okuguqula ifomethi ukuze uguqule isihlukanisi sedesimali ngokuzenzakalelayo.
• Hlola ukuhambisana kwezinhlelo noma amasistimu owasebenzisayo bese wenza ukucupha okudingekayo ukuze uqinisekise ukutolika okuyikho kwesihlukanisi sedesimali.

10. Imikhawulo nokucatshangelwa lapho ushintsha ukhefana ube yinkathi ku-Excel

Lapho ushintsha ukhefana ube yinkathi ku-Excel, kubalulekile ukukhumbula imikhawulo nokucatshangelwa okuthile. Ngezansi amaphuzu abalulekile okufanele uwakhumbule ukuze ugweme izinkinga futhi uqinisekise ushintsho olulungile kuhlelo.

1. Ifomethi yenombolo: Lapho ushintsha ukhefana ube yinkathi ku-Excel, kubalulekile ukuqinisekisa ukuthi ifomethi yenombolo esetshenzisiwe iyahambisana. Kubalulekile ukuqinisekisa ukuthi izinombolo zifomethwe ngendlela efanele ukugwema amaphutha ezibalo. Kwezinye izimo, kungase kudingeke ukuthi ulungise ukufometha usebenzisa izinketho zokufometha kweseli.

2. Amafomula nemisebenzi: Kubalulekile ukubuyekeza wonke amafomula nemisebenzi esetshenziswe kusipredishithi lapho ushintsha ukhefana ube yinkathi ku-Excel. Amanye amafomula noma imisebenzi ingase ingasebenzi kahle uma ingalungiswanga kahle. Kunconywa ukuthi uqinisekise futhi uguqule amafomula adingekayo nemisebenzi ukuze uqinisekise ukuthi izibalo zenziwa ngendlela efanele.

3. Ukungenisa nokuthekelisa idatha: Lapho ushintsha ukhefana ube isikhathi ku-Excel, kubalulekile ukucabangela ukuthi idatha ithunyelwa futhi ithekeliswe kanjani kuspredishithi. Uma ungenisa idatha isuka kolunye uhlelo noma uyikhiphela kwenye ifomethi, njenge-CSV, kungase kudingeke ukuthi ulungise izilungiselelo zokungenisa noma zokuthekelisa ukuze uqinisekise ukuthi izinombolo zitolikwa ngendlela efanele ngephoyinti ledesimali.

11. Izinzuzo zokusebenzisa iphuzu njengesihlukanisi sedesimali ku-Excel

Uma usebenzisa i-Excel njengethuluzi lokwenza izibalo zezinombolo, kubalulekile ukwazi izinzuzo zokusebenzisa isikhathi njengesihlukanisi sedesimali. Ngezansi ezinye izinzuzo zokusebenzisa lolu hlobo lwesihlukanisi ku-Excel:

1. Ukuvumelana ngefomethi: Ngokusebenzisa iphuzu njengesihlukanisi sedesimali, ukuvumelana okukhulu kufinyelelwa ngefomethi yezinombolo ezethulwa kusipredishithi. Lokhu kwenza kube lula ukufunda nokuqonda idatha, ukugwema ukudideka namaphutha lapho utolika ulwazi.

2. Ukusekelwa kwamafomula nemisebenzi: I-Excel isebenzisa amafomula nemisebenzi ukwenza izibalo ezizenzakalelayo. Ngokusebenzisa iphuzu njengesihlukanisi sedesimali, ukutolika okulungile kwalawa mafomula nemisebenzi kuyaqinisekiswa, njengoba kuyifomethi ebonwa i-Excel ngokuzenzakalelayo.

3. Ukuhwebelana kwedatha ngamazwe ngamazwe: Iphuzu njengesihlukanisi sedesimali lisetshenziswa kabanzi emhlabeni jikelele. Ngokuyisebenzisa ku-Excel, idatha yenziwa iqondeke kalula futhi iqhathaniswe phakathi kwamazwe ahlukene nezifunda. Lokhu kuwusizo ikakhulukazi ezindaweni zokusebenza zomhlaba wonke noma zokuhlanganyela, lapho abasebenzisi bangase babe nezilungiselelo zefomethi yezinombolo ezihlukile.

Kafushane, ukusebenzisa isikhathi njengesihlukanisi sedesimali ku-Excel kunikeza izinzuzo ngokuya ngokungaguquguquki kokufometha, ukuhambisana kwefomula, kanye nokwenza idatha yamazwe ngamazwe. Lezi zinzuzo zifaka isandla ekuthuthukiseni ukusebenza kahle nokunemba ekuphathweni kolwazi lwezinombolo ku-Excel. Khumbula ukulungisa kahle ifomethi yamaspredishithi akho ukuze uqinisekise ukubonwa okulungile nokubalwa kwedatha.

12. Guqula ngokuzenzakalelayo wonke amaseli anamakhoma abe ongqi ku-Excel

Uma usebenza njalo ngamashidi e-Excel aqukethe idatha yezinombolo, kungenzeka ukuthi ubhekane nenselele yokuthi uguqule ngokuzenzakalela wonke amaseli aqukethe okhefana abe amaphuzu wedesimali. Lesi simo singase sibe yisicefe kakhulu uma ubhekene nenani elikhulu ledatha, kodwa ngenhlanhla kunesixazululo esisheshayo nesilula kule nkinga.

Okokuqala, kubalulekile ukuqaphela ukuthi i-Excel inomsebenzi ohlanganisiwe obizwa ngokuthi "Buyisela" osivumela ukuthi senze lolu hlobo lwemisebenzi kumaspredishithi. Ukuze ufinyelele lesi sici, udinga ukukhetha ububanzi bamaseli ofuna ukuwaguqula bese uchofoza okuthi “Thola futhi Khetha” kuthebhu ethi “Ekhaya” iribhoni. Okulandelayo, khetha okuthi “Faka esikhundleni” kumenyu yokudonsela phansi.

Uma usuchofoze okuthi “Faka esikhundleni,” kuzovuleka iwindi le-pop-up elikuvumela ukuthi ucacise amanani ofuna ukuwathola bese uwashintsha. Esigabeni esithi “Sesha”, kufanele ufake ukhefana (,) futhi endaweni ethi “Faka esikhundleni nge”, kufanele ufake isikhathi (.). Qiniseka ukuthi ukhetha inketho ethi "Faka Konke" ukuze i-Excel iguqule ngokuzenzakalelayo kuwo wonke amaseli akhethiwe. Bese, chofoza "KULUNGILE" futhi yilokho! Wonke amaseli aqukethe okhefana manje aseguqulelwe kumaphoyinti edesimali.

13. Ungakugcina Kanjani Ukungaguquguquki Ekufometheni Kwesihlukanisi Sedesimali ku-Excel

Ku-Excel, kubalulekile ukugcina ukungaguquguquki kufomethi yesihlukanisi sedesimali ukuze kuqinisekiswe ukuthi izibalo zitolikwa ngendlela efanele. Uma sisebenza namazwe ahlukene noma izifunda ezisebenzisa amafomethi ahlukene okuhlukanisa amadesimali, njengamaphoyinti noma okhefana, singase sihlangabezane nezinkinga zokusebenzisana kumaspredishithi ethu. Ngenhlanhla, i-Excel isinika amathuluzi okuqinisekisa ukuthi ifomethi yesihlukanisi sedesimali iyahambisana kuwo wonke umbhalo.

Enye indlela yokugcina ukungaguquguquki ekufometheni kwesihlukanisi sedesimali ukusebenzisa inketho Yezilungiselelo Zesifunda se-Excel. Ukuze sifinyelele le nketho, kufanele siye kuthebhu ethi "Ifayela" bese ukhetha "Izinketho." Ngaphakathi kwewindi lezinketho, sikhetha "Okuthuthukisiwe" bese sibheka isigaba "Lapho udala izincwadi ezintsha". Lapha sizothola inketho ethi "Sebenzisa izihlukanisi zesistimu" futhi kufanele siqiniseke ukuthi ihloliwe. Uma ukhetha le nketho, i-Excel izosebenzisa ngokuzenzakalelayo isihlukanisi sedesimali esichazwe kuzilungiselelo zakho zendawo. isistimu esebenzayo.

Elinye isu lokugcina ukungaguquguquki ukusebenzisa umsebenzi we-FORMAT ku-Excel. Lo msebenzi usivumela ukufometha izinombolo ngokwephethini ethile. Isibonelo, uma sifuna ukusebenzisa iphuzu njengesihlukanisi sedesimali, singasebenzisa ifomula elandelayo: =FORMATO(A1;"#.##0,00"). Le fomula izofometha inombolo kuseli A1 isebenzisa isikhathi njengesihlukanisi sedesimali kanye nokhefana njengesihlukanisi sezinkulungwane. Singasebenzisa le fomula kuwo wonke amaseli esiwadingayo futhi ngaleyo ndlela siqinisekise ukuthi ifomethi yesihlukanisi sedesimali iyafana kuyo yonke idokhumenti.

Ukugcina ukungaguquguquki kufomethi yesihlukanisi sedesimali ku-Excel kubalulekile ukuze ugweme ukudideka namaphutha kumaspredishithi ethu. Kuphakathi kokuthi ngokusebenzisa inketho Yezilungiselelo Zesifunda noma umsebenzi we-FORMAT, singaqinisekisa ukuthi isihlukanisi sedesimali esisetshenzisiwe silungile futhi asiguquguquki kuyo yonke idokhumenti. Landela lezi zinyathelo ukuze ugcine isethulo esihle nesihambisanayo kumaspredishithi akho e-Excel.

14. Iziphetho: Ukuthuthukisa ukunemba nokuhambisana nokuguqulwa ku-Excel

Kafushane, ukuthuthukisa ukunemba nokuhambisana nokuguqulwa ku-Excel kungafinyelelwa ngokulandela izinyathelo ezibalulekile ezimbalwa. Okokuqala, kubalulekile ukuqinisekisa ukuthi idatha ifomethwe kahle ngaphambi kokuguqulwa. Lokhu kuhlanganisa ukubuyekeza nokulungisa noma imaphi amaphutha, amaphutha okufometha, noma ukungahambisani kwedatha.

Endaweni yesibili, kuyatuseka ukusebenzisa izici ezithuthukisiwe ze-Excel, ezifana nokusetshenziswa kwamafomula nama-macros, ukwenza ngokuzenzakalelayo nokusheshisa inqubo yokuguqula. Le misebenzi ingasetshenziswa ukwenza izibalo eziyinkimbinkimbi, ukukhohlisa idatha kanye nokwenza imibiko enembe kakhulu.

Ekugcineni, kuyasiza ukusebenzisa amathuluzi ezinkampani zangaphandle aklanyelwe ngokukhethekile ukuthuthukisa ukunemba nokuhambisana nokuguqulwa ku-Excel. Lawa mathuluzi angase ahlanganise izengezo, ama-plug-in noma isofthiwe ekhethekile enikeza ububanzi obuningi bokusebenza okwengeziwe.

Sengiphetha, ukushintsha ukhefana ube yinkathi ku-Excel kuwumsebenzi olula kodwa obalulekile ukuze kuqinisekiswe ukuhunyushwa okufanele kwedatha. Ngezinketho zefomethi kanye nokusebenzisa amafomula, singashintsha ifomethi yezinombolo futhi senze imisebenzi ngaphandle kwezinkinga.

Kubalulekile ukukhumbula ukuthi, lapho usebenza nedatha yezinombolo ku-Excel, kubalulekile ukucabangela ifomethi efanele ukugwema ukudideka noma amaphutha ezibalo. Ukushintsha ukhefana nenkathi kuwumkhuba ovamile ezindaweni eziningi zobungcweti futhi kuqinisekisa ukuvumelana kwamazwe ngamazwe ekuphathweni kwedatha.

Sethemba ukuthi lesi sihloko sinikeze umhlahlandlela ocacile futhi omfushane wokuthi ungashintsha kanjani ukhefana ube yinkathi ku-Excel. Khumbula ukusebenzisa lolu lwazi kumaphrojekthi akho futhi uzuze ekwethulweni kwedatha okungaguquki nokunembile. Ngokuzijwayeza kanye nobuchule balezi zindlela, uzokwazi ukukhohlisa izinombolo ngempumelelo futhi ngempumelelo. Qhubeka uthole okuningi ku-Excel!