Yadda ake Canja Waƙafi zuwa Lokaci a Excel

A duniya A cikin sarrafa bayanai da bincike na Excel, ainihin wakilcin lambobi yana da mahimmanci don samun ingantaccen sakamako mai inganci. Ɗayan mafi yawan al'amuran da ke buƙatar daidaitawa shine tsarin rabuwa na goma da aka yi amfani da su a cikin maƙunsar sel. A yawancin ƙasashen Mutanen Espanya, ana amfani da waƙafi azaman alama ta goma maimakon lokacin. A cikin wannan labarin, za mu bincika yadda ake canza waƙafi zuwa lokaci a cikin Excel, ba ku damar yin aiki cikin sauƙi a cikin tsarin wakilcin lambobi mafi dacewa da buƙatun ku na fasaha [END].

1. Gabatarwa zuwa waƙafi zuwa canjin lokaci a cikin Excel

Idan kun taɓa yin aiki tare da bayanan lambobi a cikin Excel, ƙila kun ci karo da buƙatar canza lambobi waɗanda aka rubuta tare da ma'aunin ƙima zuwa ma'aunin ƙima. Wannan juyawa ya zama dole tunda Excel ta tsohuwa yana amfani da maki goma maimakon waƙafi. Abin farin ciki, akwai hanyoyi da yawa don aiwatar da wannan jujjuya cikin sauri da sauƙi.

Ɗayan zaɓi don canza waƙafi zuwa lokaci a cikin Excel shine ta amfani da bincike da maye gurbin aiki. Don yin wannan, zaɓi shafi ko kewayon ƙwayoyin halitta wanda ya ƙunshi lambobin da za a canza. Sa'an nan, je zuwa Home tab, danna "Find & Select" kuma zaɓi "Maye gurbin." A cikin akwatin maganganu da ya bayyana, shigar da waƙafi a cikin filin "Nemo" da lokacin a cikin filin "Maye gurbin". Danna "Maye gurbin Duk" don canza duk lambobi.

Wani zaɓi shine a yi amfani da fasalin tsara al'ada na Excel. Don yin wannan, zaɓi tantanin halitta ko kewayon tantanin halitta dauke da lambobin kuma je zuwa shafin Gida. Sa'an nan, danna maɓallin tsarin lamba kuma zaɓi "Ƙarin tsarin lamba" a ƙasan jerin. A cikin akwatin maganganu da ya bayyana, zaɓi "Custom" daga jerin nau'ikan kuma a cikin filin tsari, shigar da tsarin. #.###,##. Wannan zai canza lambobi ta atomatik tare da maki goma zuwa maki goma.

2. Fahimtar tasirin waƙafi da lokaci a cikin Excel

Waƙafi da maƙasudin ƙima su ne muhimman abubuwa guda biyu a cikin Excel waɗanda za su iya yin tasiri sosai kan fassarar da lissafin bayanai. Yana da mahimmanci a fahimci yadda ake amfani da su daidai don guje wa kurakurai da rudani a cikin dabaru da sakamako. Anan muna ba ku jagora mataki-mataki don cikakken fahimtar wannan batu.

1. Sanya zaɓuɓɓukan yanki: Yana da mahimmanci don tabbatar da cewa an saita zaɓuɓɓukan yanki daidai a cikin Excel. Wannan Ana iya yin hakan ta hanyar harshe da saitunan wuri a cikin ɓangaren zaɓi na shirin. Anan zaka iya zaɓar yaren da ake so da tsarin da ya dace don lambobi da kwanan wata.

2. Yin amfani da waƙafi da ƙayyadaddun ƙayyadaddun ƙima: Dole ne ku tuna cewa a wasu ƙasashe ana amfani da ma'anar azaman maɓalli na ƙima, yayin da wasu kuma ana amfani da waƙafi. Wannan na iya shafar yadda Excel ke fassara bayanai. Don guje wa ruɗani, ana ba da shawarar yin amfani da mai raba decimal wanda ya dace da yankin ku. Idan kuna aiki tare da bayanan da ke amfani da maɓalli na ƙima fiye da yadda aka tsara su a cikin Excel, zaku iya amfani da nemo da maye gurbin ayyuka don gyara shi.

3. Gano ƙwayoyin cuta tare da masu raba ƙayatattun ƙima

Don gano sel tare da masu raba goma ba daidai ba a kan takarda lissafin, kuna buƙatar bin wasu matakai masu mahimmanci. Na farko, yana da mahimmanci don tabbatar da cewa masu rarraba ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙa'idodi suke. Don yin wannan, bitar sel ɗin da ke ɗauke da lambobi kuma bincika idan mai raba goma daidai ne, ta yin amfani da ma'aunin ƙima (lokaci ko waƙafi).

Idan ka sami sel tare da rarrabuwar ƙima ba daidai ba, akwai hanyoyi da yawa don warware wannan matsalar. Ɗayan zaɓi shine a yi amfani da aikin "Maye gurbin" don maye gurbin masu rarraba ƙima ba daidai ba tare da daidaitattun. Misali, idan mai raba decimal mara daidai waƙafi ne, zaku iya amfani da aikin “Maye gurbin” don maye gurbin duk waƙafi da lokaci. Hakanan zaka iya amfani da dabara don musanya lambobi tare da masu raba decimal marasa kuskure zuwa lambobi waɗanda maƙunsar bayanai ke iya ganewa.

Wani zaɓi shine a yi amfani da kayan aiki na tsari don yin haske ta atomatik tare da rarrabuwa na ƙima. Kuna iya saita ƙa'ida wanda ke gano lambobi waɗanda ke ɗauke da madaidaicin madaidaicin ƙima kuma yana haskaka su cikin launi daban-daban. Wannan zai sauƙaƙa ganowa da gyara kurakurai a gani. Har ila yau, tuna don sake duba duk wani shigo da bayanai ko kwafin bayanai, saboda ƙila an canza masu rarraba decimal yayin aiwatarwa.

4. Mataki-mataki: Canja waƙafi zuwa lokaci a cikin Excel da hannu

A wasu lokatai, ƙila ka buƙaci canza maki goma a cikin maƙunsar rubutu na Excel zuwa waƙafi, ko akasin haka, musamman idan ana batun shigo da ko fitar da bayanai daga wasu tsarin ko ƙasashen da suke amfani da su. tsare-tsare daban-daban maki goma. Abin farin ciki, Excel yana ba da hanya mai sauƙi don yin wannan aikin da hannu, kuma tsarin mataki-mataki yana dalla-dalla a ƙasa:

1. Buɗe Fayil ɗin Excel wanda a ciki kake son canza waƙafi zuwa lokaci, ko akasin haka.

2. Zaɓi sel ko kewayon sel waɗanda ke ɗauke da lambobi masu maki goma ko waƙafi waɗanda kuke son canzawa.

3. Dama-danna zaɓaɓɓun sel kuma zaɓi zaɓin "Format Cells" daga menu na mahallin.

4. A cikin "Format Cells" pop-up taga, zaɓi "Lambar" tab idan ba a zaba ta tsohuwa. Sannan, zaɓi nau'in "Lambar" a cikin jerin zaɓuɓɓukan tsarawa.

5. A cikin sashin “Alamomin Rabuwa”, zaɓi alamar decimal da kake son amfani da ita: digo “.” don masu rarraba goma ko waƙafi "," don masu rarraba goma.

6. Danna maɓallin "Ok" don adana canje-canje kuma amfani da sabon tsarin zuwa sel da aka zaɓa. Yanzu, za a canza maki goma zuwa waƙafi ko akasin haka, ya danganta da zaɓin da kuka zaɓa.

Ka tuna cewa wannan tsari yana shafar tsarin gani na sel ne kawai kuma baya canza ƙimar lambobi da kansu. Hakanan lura cewa wannan hanyar jagora ce kuma ana iya amfani da ita zuwa zaɓi na takamaiman sel ko duka maƙunsar bayanai, dangane da buƙatar ku. [KARSHE

5. Yin sarrafa waƙafi zuwa canjin lokaci a cikin Excel

Don sarrafa canjin waƙafi zuwa lokaci a cikin Excel, kuna iya bin matakai masu zuwa:

1. Zaɓi shafi ko kewayon sel waɗanda kuke son yin jujjuyawar. Kuna iya yin haka ta danna kan harafin shafi ko jan linzamin kwamfuta zuwa kewayon.

2. A shafin "Gida" na menu na Excel, danna "Nemi kuma Zaɓi" sannan "Maye gurbin." Hakanan zaka iya amfani da haɗin maɓallin Ctrl + H.

3. A cikin taga da ya bayyana, shigar da waƙafi («,”) a cikin filin “Search” da lokacin («.”) a cikin filin “Maye gurbin da”. Tabbatar cewa duka filayen babu kowa.

4. Danna "Maye gurbin Duk" don canza duk waƙafi ta atomatik zuwa lokaci a cikin kewayon da aka zaɓa.

Ka tuna cewa wannan hanyar za ta canza duk waƙafi zuwa lokaci a cikin kewayon da aka zaɓa. Idan kawai kuna son canza takamaiman ɓangaren waƙafi, zaku iya amfani da zaɓin “Maye gurbin” maimakon “Maye gurbin Duka” kuma zaɓi takamaiman waƙafi da kuke son canzawa.

Yanzu zaku iya sarrafa waƙafi zuwa canjin lokaci a cikin Excel cikin sauri da sauƙi. Wannan zai cece ku lokaci da kuma tabbatar da daidaito a ciki bayananka.

6. Amfani da dabaru don canza waƙafi zuwa lokaci a cikin Excel

A cikin Excel, ya zama ruwan dare cewa lokacin shigo da bayanai ko kwafe bayanai daga wasu tushe, ana wakilta lambobi goma sha tare da waƙafi maimakon maki. Wannan na iya yin wahalar amfani da ayyuka da ƙididdiga a cikin maƙunsar bayanai. Abin farin ciki, Excel yana ba da dabarun da ke ba ku damar canza waƙafi zuwa lokacin ta atomatik, yana sauƙaƙa aiwatar da ayyukan lissafi.

Ɗaya daga cikin hanyoyin da aka fi amfani da su don canza waƙafi na tsawon lokaci shine aikin "SUBSTITUTE". Wannan aikin yana ba ku damar maye gurbin ɗayan haruffa tare da wani a cikin tantanin halitta da aka bayar. Don canza waƙafi zuwa lokacin, kawai dole ne mu yi amfani da dabarar "= SUBSTITUTE(asalin_cell, ",",".")", inda "asalin_cell" shine tantanin halitta wanda ke ɗauke da lamba tare da waƙafi. Wannan dabarar tana maye gurbin duk waƙafi da lokaci a cikin tantanin halitta da aka zaɓa.

Wani zaɓi shine a yi amfani da aikin "SAUYA". Wannan aikin yana kama da aikin "SUBSTITUTE", amma yana ba mu damar musanya saitin haruffa ɗaya da wani a cikin tantanin halitta. Don canza waƙafi zuwa lokacin, zamu iya amfani da dabarar "= SAUKI(asalin_cell, FIND(«,", asalin_cell), 1, ".")", inda "asalin_cell" shine tantanin halitta wanda ke ɗauke da lamba tare da waƙafi. . Wannan tsari yana gano matsayin waƙafi a cikin tantanin halitta kuma ya maye gurbinsa da lokacin. Yana da mahimmanci a lura cewa kawai yana maye gurbin waƙafi na farko da aka samu a cikin tantanin halitta.

Ta bin waɗannan matakan, zaku iya canza waƙafi zuwa lokaci a cikin Excel cikin sauri da sauƙi. Waɗannan ƙididdiga suna da amfani musamman lokacin aiki tare da ɗimbin bayanan da aka shigo da su ko aka kwafi daga wasu tushe. Bugu da ƙari, za su ba ka damar yin lissafi da ayyukan lissafi ba tare da matsala ba. Ka tuna cewa zaku iya amfani da waɗannan dabarun a haɗe tare da sauran ayyukan Excel don samun madaidaicin sakamako.

7. Kayan aiki da ƙari-kan don sauƙaƙe juyawa a cikin Excel

Akwai nau'ikan iri-iri kayan aiki da plugins wanda zai iya taimaka maka sauƙaƙe jujjuyawar data a cikin Excel, don haka daidaita ayyukanku na yau da kullun. Ga wasu zaɓuɓɓukan da zaku iya la'akari dasu:

• Tambayar Ƙarfi: Wannan kayan aikin Excel yana ba ku damar haɗawa, canzawa da sake tsara bayanai daga tushe daban-daban. Tare da ilhama ta dubawa, za ka iya sauƙi yi hira ayyuka kamar raba rubutu, hada ginshikan da canza Formats.
• Maida rubutu zuwa ginshiƙai: Excel yana da aikin da ke ba ka damar canza rubutun da aka raba ta hanyar iyaka zuwa ginshiƙai guda ɗaya. Wannan fasalin yana da amfani musamman lokacin da kuke buƙatar raba bayanai tsakanin sel zuwa ginshiƙai da yawa, kamar adireshi, cikakkun sunaye, ko lambobin waya.
• Ƙididdigar juyawa: Excel yana ba da nau'i-nau'i masu yawa waɗanda ke sa sauƙin sauya bayanai. Misali, tsarin CONVERT yana ba ku damar canza raka'a na aunawa kamar kilogiram zuwa fam ko mita zuwa ƙafa. Bugu da ƙari, kuna iya amfani da ayyuka kamar TEXT, DATE, da TIME don canza tsarin kwanakin, lambobi, ko rubutu a cikin maƙunsar bayanai.

Baya ga waɗannan kayan aikin Excel na asali da ayyuka, kuna iya samun ƙari na ɓangare na uku wanda ke ƙara ƙarin ayyuka ga aikace-aikacen. Misali, akwai plugins da aka ƙera musamman don canza agogo, raka'a na ma'auni, ko ma samar da ƙarin ginshiƙai da allunan pivot.

Ka tuna cewa waɗannan kayan aikin da add-ins na iya bambanta dangane da nau'in Excel da kake amfani da su, don haka yana da kyau a duba dacewa kafin sakawa. Bincika zaɓuɓɓukan da ake da su kuma zaɓi kayan aikin da suka dace da bukatun ku, za ku ga yadda za ku sauƙaƙe canza bayanai a cikin Excel!

8. Yadda ake guje wa matsalolin gaba yayin canza waƙafi zuwa lokaci a cikin Excel

Lokacin canza waƙafi zuwa lokaci a cikin Excel, yana da mahimmanci a kiyaye wasu la'akari don guje wa matsalolin bayanai na gaba. A ƙasa, muna gabatar da wasu nasihu da mafita-mataki-mataki don guje wa matsaloli yayin canza masu rarraba ƙima.

1. Yi amfani da aikin VLOOKUP don ganowa da gyara sel tare da waƙafi. Wannan aikin zai ba ku damar bincika takamaiman ƙima a cikin shafi ɗaya kuma dawo da ƙimar daidai daga wani shafi. Ta wannan hanyar, zaku iya gano sel da sauri tare da waƙafi kuma maye gurbin su da lokaci.

2. Yi amfani da umarnin "Nemo da Sauya" na Excel. Wannan kayan aiki yana da matukar amfani don yin manyan canje-canje ga bayanai kuma zai ba ku damar maye gurbin duk waƙafi da lokuta cikin sauri da sauƙi. Kawai zaɓi kewayon sel ɗin da abin ya shafa, danna "Nemo kuma Sauya" a cikin menu na "Gida", sannan saka waƙafi azaman ƙimar da za a nema da lokacin azaman ƙimar maye gurbin.

3. Ka tuna a yi amfani da tsarin da ya dace ga sel. Bayan maye gurbin waƙafi da lokaci, yana da mahimmanci a tabbatar da cewa tsarin tantanin halitta daidai ne don guje wa matsalolin gaba. Zaɓi Kwayoyin da abin ya shafa, danna-dama kuma zaɓi "Format Cells." Sannan, zaɓi nau'in "Lambar" kuma zaɓi tsarin da ake so.

9. Magani ga kurakurai na yau da kullun lokacin canza mai raba decimal a cikin Excel

Lokacin canza madaidaicin ƙididdiga a cikin Excel, yawanci ana fuskantar kurakurai waɗanda zasu iya shafar gabatarwa da lissafin bayanai. Na gaba, za mu nuna muku yadda ake warware mafi yawan kurakuran da za su iya tasowa yayin canza mai rarraba decimal a cikin Excel:

Kuskure 1: Canjin rabuwa na ƙima mara kyau

Idan bayan an canza maɓalli na ƙima a cikin Excel, ba a gabatar da lambobin daidai ba, ana iya canza canjin. Don gyara wannan matsalar, bi waɗannan matakan:

• Zaɓi sel masu lambobin da abin ya shafa.
• Dama danna kuma zaɓi "Format Cells."
• A cikin "Lambar" tab, zaɓi "Custom" category.
• A cikin akwatin "Type", shigar da lambar tsarin da ta dace, misali, "#, ##0.00" idan kuna son amfani da wurare na decimal guda biyu.

Kuskure 2: Lissafin da ba daidai ba

Bayan canza mai raba na decimal, ƙididdiga a cikin Excel na iya yin kuskure ba daidai ba. Don gyara wannan matsalar, bi waɗannan matakan:

• Bincika idan lambobin da ke cikin sel da abin ya shafa suna cikin tsari daidai. Idan ba haka ba, bi matakan da aka ambata a sama don canza tsarin tantanin halitta.
• Tabbatar cewa ƙididdiga a cikin sel ɗin lissafin suma suna amfani da madaidaicin maɓalli na goma. Kuna iya yin haka ta zaɓar sel ɗin dabara sannan danna "Maye gurbin" akan shafin "Gida".
• A cikin akwatin maganganu na “Maye gurbin”, shigar da mai raba decimal da ba daidai ba a cikin filin “Find” da madaidaicin mai raba decimal a cikin filin “Maye gurbin da”. Danna "Maye gurbin Duka" don canza duk masu rarraba decimal da ba daidai ba a cikin tsarin.

Kuskure 3: Rashin jituwa tare da wasu shirye-shirye

Lokacin canza madaidaicin ƙima a cikin Excel, ƙila za ku gamu da rashin jituwa tare da wasu shirye-shirye ko tsarin da ke amfani da maɓalli daban-daban. Don magance wannan matsala, kuna iya la'akari da zaɓuɓɓuka masu zuwa:

• Yi amfani da ingantaccen tsari lokacin fitarwa ko shigo da bayanai tsakanin shirye-shirye ko tsarin.
• Yi amfani da kayan aikin jujjuya tsarin don canza mai raba goma ta atomatik.
• Bincika daidaiton shirye-shirye ko tsarin da kuke amfani da su kuma yi daidaitattun daidaitawa don tabbatar da madaidaicin fassarar mai raba goma.

10. Iyakoki da la'akari lokacin canza waƙafi zuwa lokaci a cikin Excel

Lokacin canza waƙafi zuwa lokaci a cikin Excel, yana da mahimmanci a tuna da wasu iyakoki da la'akari. A ƙasa akwai mahimman abubuwan da za a kiyaye su don guje wa matsaloli da tabbatar da ingantaccen canji a cikin shirin.

1. Tsarin lamba: Lokacin canza waƙafi zuwa lokaci a cikin Excel, yana da mahimmanci don tabbatar da cewa tsarin lambar da aka yi amfani da shi ya yi daidai. Yana da mahimmanci don tabbatar da cewa an tsara lambobi daidai don kauce wa kurakurai a cikin lissafin. A wasu lokuta, yana iya zama dole a daidaita tsarin ta amfani da zaɓuɓɓukan tsara tantanin halitta.

2. Formules da ayyuka: Yana da mahimmanci a sake nazarin duk dabaru da ayyuka da aka yi amfani da su a cikin maƙunsar bayanai lokacin canza waƙafi zuwa lokaci a cikin Excel. Wasu ƙila ko ayyuka ba za su yi aiki daidai ba idan ba a daidaita su da kyau ba. Ana ba da shawarar cewa ku tabbatar da gyara mahimman dabaru da ayyuka don tabbatar da cewa an yi lissafin daidai.

3. Shigo da fitarwa na bayanai: Lokacin canza waƙafi zuwa lokaci a cikin Excel, yana da mahimmanci a yi la'akari da yadda ake shigo da bayanai da fitar da su a cikin maƙunsar bayanai. Idan ka shigo da bayanai daga wani shirin ko fitarwa zuwa wani tsari, kamar CSV, ƙila ka buƙaci daidaita saitunan shigarwa ko fitarwa don tabbatar da cewa an fassara lambobi daidai tare da ma'aunin ƙima.

11. Fa'idodin amfani da batu a matsayin mai raba goma a cikin Excel

Lokacin amfani da Excel azaman kayan aiki don yin ƙididdige ƙididdiga, yana da mahimmanci a san fa'idodin amfani da lokacin azaman mai raba ƙima. Da ke ƙasa akwai wasu fa'idodi na amfani da irin wannan nau'in rarrabawa a cikin Excel:

1. Daidaituwa a cikin tsari: Ta hanyar amfani da ma'ana azaman mai rarraba ƙima, ana samun daidaito mafi girma a cikin tsarin lambobin da aka gabatar a cikin maƙunsar rubutu. Wannan yana ba da sauƙin karantawa da fahimtar bayanan, guje wa ruɗani da kurakurai yayin fassarar bayanin.

2. Taimako don ƙididdiga da ayyuka: Excel yana amfani da ƙididdiga da ayyuka don yin lissafin atomatik. Ta hanyar amfani da ma'ana azaman mai raba ƙima, ingantaccen fassarar waɗannan ƙididdiga da ayyuka yana da tabbacin, tunda shine tsarin da Excel ya gane ta tsohuwa.

3. Ƙaddamar da bayanai: Batun a matsayin mai raba goma ana amfani da shi sosai a duniya. Ta amfani da shi a cikin Excel, bayanan suna samun sauƙin fahimta da kamanta tsakanin ƙasashe da yankuna daban-daban. Wannan yana da amfani musamman a aikin duniya ko mahallin haɗin gwiwa, inda masu amfani za su sami saitunan tsarin lamba daban-daban.

A taƙaice, yin amfani da lokacin azaman mai keɓance ƙima a cikin Excel yana ba da fa'idodi dangane da tsara daidaiton tsari, dacewar dabara, da haɗa bayanai zuwa ƙasashen duniya. Waɗannan fa'idodin suna ba da gudummawa don haɓaka inganci da daidaito a cikin sarrafa bayanan lambobi a cikin Excel. Ka tuna don daidaita tsarin maƙunsar bayanan ku da kyau don tabbatar da daidaitaccen gani da lissafin bayanai.

12. Ta atomatik canza duk sel masu waƙafi zuwa lokaci a cikin Excel

Idan kuna aiki akai-akai tare da zanen Excel masu ɗauke da bayanan lambobi, ƙila kun fuskanci ƙalubalen canza duk ƙwayoyin da ke ɗauke da waƙafi ta atomatik zuwa maki goma. Wannan yanayin na iya zama mai wahala sosai idan kuna fuskantar babban adadin bayanai, amma an yi sa'a akwai mafita mai sauri da sauƙi ga wannan matsalar.

Da farko, yana da mahimmanci a lura cewa Excel yana da haɗin gwiwar aiki mai suna "Replace" wanda ke ba mu damar yin wannan nau'in ayyuka a cikin ma'auni. Don samun damar wannan fasalin, kuna buƙatar zaɓar kewayon sel ɗin da kuke son canzawa sannan danna “Nemo kuma Zaɓi” akan shafin “Gida” na ribbon. Na gaba, zaɓi "Maye gurbin" daga menu mai saukewa.

Da zarar ka danna "Maye gurbin," taga pop-up zai buɗe wanda zai baka damar tantance ƙimar da kake son nema da maye gurbin. A cikin filin "Search", dole ne ka shigar da waƙafi (,) kuma a cikin filin "Maye gurbin da", dole ne ka shigar da lokacin (.). Tabbatar zaɓar zaɓin "Maye gurbin Duk" don samun Excel yin jujjuyawar akan duk sel da aka zaɓa ta atomatik. Sa'an nan, danna "Ok" kuma shi ke nan! Duk sel waɗanda ke ɗauke da waƙafi yanzu an canza su zuwa maki goma.

13. Yadda Ake Ci Gaba Da Daidaituwa A Tsara Tsakanin Decimal Separator a Excel

A cikin Excel, yana da mahimmanci a kiyaye daidaito a cikin tsarin raba goma don tabbatar da cewa an fassara alkalumman daidai. Idan muka yi aiki tare da ƙasashe ko yankuna daban-daban waɗanda ke amfani da nau'ikan rarraba ƙima daban-daban, kamar maki ko waƙafi, ƙila mu gamu da batutuwan dacewa a cikin maƙunsar bayanai. An yi sa'a, Excel yana ba mu kayan aiki don tabbatar da cewa tsarin rarraba decimal ya yi daidai cikin takaddar.

Hanya ɗaya don tabbatar da daidaito a cikin tsarin rarraba ƙima shine ta amfani da zaɓin Saitunan Yanki na Excel. Don samun dama ga wannan zaɓi, dole ne mu je shafin "Fayil" sannan mu zaɓi "Zaɓuɓɓuka." A cikin taga zaɓin, za mu zaɓi "Na ci gaba" kuma mu nemi sashin "Lokacin ƙirƙirar sababbin littattafai". Anan za mu sami zaɓi na "Yi amfani da tsarin separators" kuma dole ne mu tabbatar an duba shi. Lokacin da kuka zaɓi wannan zaɓi, Excel za ta yi amfani da keɓancewar decimal ta atomatik da aka ayyana a cikin saitunan yankinku. tsarin aiki.

Wata dabara don kiyaye daidaito shine amfani da aikin FORMAT a cikin Excel. Wannan aikin yana ba mu damar tsara lambobi bisa ga takamaiman tsari. Misali, idan muna son yin amfani da batu a matsayin mai raba goma, za mu iya amfani da dabara mai zuwa: =FORMATO(A1;"#.##0,00"). Wannan dabarar za ta tsara lambar a cikin tantanin halitta A1 ta amfani da lokacin azaman mai raba goma da waƙafi azaman mai raba dubunnan. Za mu iya amfani da wannan dabara ga duk sel ɗin da muke buƙata don haka tabbatar da cewa tsarin raba goma ya daidaita a cikin takaddar.

Tsayar da daidaito a cikin tsarin raba goma a cikin Excel yana da mahimmanci don guje wa rudani da kurakurai a cikin maƙunsar bayanan mu. Ko dai ta amfani da zaɓin Saitunan Yanki ko aikin FORMAT, za mu iya tabbatar da cewa mai raba decimal ɗin da aka yi amfani da shi daidai ne kuma ya daidaita a duk cikin takaddar. Bi waɗannan matakan don kiyaye kyakkyawar gabatarwa da daidaituwa a cikin maƙunsar bayanai na Excel.

14. Ƙarshe: Inganta daidaito da daidaituwa tare da juyawa a cikin Excel

A taƙaice, haɓaka daidaito da daidaituwa tare da juyawa a cikin Excel ana iya samun su ta hanyar bin ƴan matakai masu mahimmanci. Da farko, yana da mahimmanci don tabbatar da cewa an tsara bayanan da kyau kafin canzawa. Wannan ya ƙunshi bita da gyara duk wani rubutaccen rubutu, tsara kurakurai, ko rashin daidaituwa a cikin bayanan.

A matsayi na biyu, yana da kyau a yi amfani da fasalulluka na Excel na ci gaba, kamar yin amfani da ƙididdiga da macro, don yin aiki da kai da kuma hanzarta tsarin juyawa. Ana iya amfani da waɗannan ayyuka don yin ƙididdiga masu rikitarwa, sarrafa bayanai da samar da ingantattun rahotanni.

A ƙarshe, yana da taimako don amfani da kayan aikin ɓangare na uku waɗanda aka tsara musamman don inganta daidaito da daidaituwa tare da juyawa a cikin Excel. Waɗannan kayan aikin na iya haɗawa da add-ons, plug-ins ko software na musamman waɗanda ke ba da ƙarin ayyuka da yawa.

A ƙarshe, canza waƙafi zuwa lokaci a cikin Excel aiki ne mai sauƙi amma mai mahimmanci don tabbatar da ingantaccen fassarar bayanai. Ta hanyar zaɓuɓɓukan tsari da kuma ta amfani da ƙididdiga, za mu iya canza tsarin lambobi da yin ayyuka ba tare da matsala ba.

Yana da mahimmanci a tuna cewa, lokacin aiki tare da bayanan lambobi a cikin Excel, yana da muhimmanci a yi la'akari da tsarin da ya dace don kauce wa rikicewa ko kurakurai a cikin lissafi. Maye gurbin waƙafi tare da lokaci al'ada ce ta gama gari a guraben ƙwararru da yawa kuma yana tabbatar da daidaiton ƙasashen duniya wajen sarrafa bayanai.

Muna fatan wannan labarin ya ba da jagorar taƙaitacciyar jagora kan yadda ake canza waƙafi zuwa lokaci a cikin Excel. Ka tuna yin amfani da wannan ilimin a cikin ayyukanku kuma ku amfana daga daidaitattun gabatarwar bayanai. Tare da aiki da ƙwarewa na waɗannan fasahohin, zaku iya sarrafa lambobi yadda ya kamata kuma tasiri. Ci gaba da samun mafi kyawun Excel!