Ngokubanzi ubukho booziro kwindawo yolwazi ye-Excel bunokwenza iihistograms kunye neentlobo ezahlukeneyo zeegrafu zibukeke zingachanekanga. Uya kubona ukuba phantsi kwamanyathelo okutshintsha i-zero ngokucocekileyo, i-Sprint okanye umxholo wokubhaliweyo kwi-Excel.
Iindlela zokutshintsha iZero ngokuCoca kwi-Excel
Phambi kokuba uye phambili ngamanyathelo okutshintsha ii-zeros ngococeko kwi-Excel, unokufuna ukubona ukuba ukutshintsha ooziro ngezixa ezicocekileyo ukuphelisa ulwazi olusuka kwiiseli ezinamaxabiso angama-0.
Nje ukuba uthathe ii-zero kwi-Excel, zonke iiseli eziqulathe ii-zero ziya kuphulukana nolwazi lwazo kwaye ziya kuphathwa njengeeseli ezingenanto ezingenalwazi kuzo.
Xa utshintsha ooziro nge-Sprint (-) okanye umxholo woMbhalo kwi-Excel, unokuhlangabezana neempazamo ngokubanzi, ukuba iiseli ezineSprint okanye iNdawo yoMxholo woMxholo zibhekiswa kuqulunqo lwakho.
Ngolu kuqonda, sivumele ukuba sihambe phambili kwaye sizame amanyathelo okutshintsha i-zero ngokucocekileyo, i-sprint okanye indawo yomxholo wombhalo kwi-Excel.
1. Guqula iZero ngokuCoca kwi-Excel
Jonga la manyathelo angezantsi ukutshintsha ooziro ngezithuba ezingenanto kwi-Excel.
1. khetha Ulwazi olupheleleyo apho unqwenela ukutshintsha iZero ngeeseli ezicocekileyo.
2. Cofa kwi Kuhlala tab> cofa kwi Fumana kwaye ukhethe kwindawo 'Yokuphucula' kwaye ukhethe i utshintsho kunokwenzeka kwimenyu eyehlayo.
3. Kwindawo ethi 'Fumana kwaye Utshintshe', ngenisa 0 kwi 'Fumana ntoni' Indawo > yiya kwindawo 'Tshintsho nge' ezingenanto (ungangeni nto kuyo) kwaye ucofe ku ukhetho.
4. Ngaphakathi kwendawo eyandisiweyo 'Fumana kwaye Utshintshe', khetha Tshatisa iziqulatho zeeseli zizonke kunokwenzeka kwaye ucofe ku Guqula konke iqhosha.
Xa ucofa iqhosha elithi 'Shintsha Konke', zonke iiseli kulwazi lwakho ezino-zeros ziya kukhula zicoceke ngoko nangoko.
2. Guqula iZero nge-Sprint kwi-Excel
Enye indlela yokuhlangabezana nexabiso elingu-zero kwi-Excel kukutshintsha ooziro nge-sprint (-). Oku kunokufezekiswa ngokusebenzisa ukufomatha ubungakanani obulungiselelweyo njengalapha kwi-Excel.
1. khetha Ulwazi olupheleleyo apho unqwenela ukutshintsha ooziro ngokubaleka.
2. Cofa kwi Kuhlala tab > khetha format kunokwenzeka kwiqela elithi 'Iiseli'> cofa kwi Iiseli zokuFomatha... ngaphakathi kwemenyu eyehlayo.
3. Kwifomathi yeeseli zencoko yababini, cofa kwi ubuninzi tab kwaye ukhethe ngentando kunokwenzeka kwifestile yasekhohlo. Ngaphakathi kwefestile yasekunene, ngenisa 0;-0;”–” ngaphakathi kwendawo ethi 'Uhlobo'.
4. Cofa apha OK ukugcina okuninzi kunye nokuphumeza olu tshintsho.
Xa ucofa ku-Kulungile, Iiseli ezinamaxabiso angama-0 ziya kubonisa ukuchaphaza (-). Ukongeza, ukuba kuyenzeka ukuba ufake u-zero kuyo nayiphi na iseli, iya kutshintshwa nge-Sprint (-).
3. Guqula iZero ngomxholo wombhalo kwi-Excel
Kuyenzeka kwakhona ukutshintsha ooziro ngayo nayiphi na indawo yombhalo kwi-Excel. Umzekelo, unokutshintsha ooziro ngo-'NA', 'Not Out there' okanye wonke omnye umxholo wokubhaliweyo.
1. khetha Ulwazi olupheleleyo apho unqwenela ukutshintsha ooziro ngomxholo wokubhaliweyo.
2. Cofa kwi Kuhlala tab > khetha format kunokwenzeka kwiqela elithi 'Iiseli'> cofa kwi Iiseli zokuFomatha... ngaphakathi kwemenyu eyehlayo.
3. Kwifomathi yeeseli zencoko yababini, cofa kwi ubuninzi tab kwaye ukhethe ngentando kunokwenzeka kwifestile yasekhohlo. Ngaphakathi kwefestile yasekunene, ngenisa 0;-0;[Inethiwekhi]"HAYI" ngaphakathi kwendawo ethi 'Uhlobo'.
4. Cofa apha OK ukugcina okuninzi kunye nokuphumeza olu tshintsho.
Xa ucofa ku-Kulungile, zonke iiSeli ezinamaxabiso angama-0 ziya kubonisa umxholo wokubhaliweyo 'NA' ngombala omfusa.
igama: Ukuba unqwenela ukubonisa 'NA' ngombala ofanayo, hlela nje 0;-0;”NA”.
4. Fumanisa ooZero kwi-Excel
Kwimeko apho awudingi kususa ooziro ngoko nangoko, unokuqala ngokufumana ooziro kwindawo yolwazi, khetha bonke ooziro kwaye ubakhathalele njengoko kufuneka.
1. Khetha Gqiba ulwazi Ukuba nexabiso elingu-Zero
2. Cofa kwi Kuhlala tab> cofa kwi Fumana kwaye ukhethe kwindawo 'Yokuphucula' kwaye ukhethe i utshintsho kunokwenzeka kwimenyu eyehlayo.
3. Kwindawo ethi 'Fumana kwaye Utshintshe', ngenisa 0 kwi 'Fumana ntoni' Indawo > yiya kwindawo 'Tshintsho nge' ezingenanto (ungangeni nto kuyo) kwaye ucofe ku ukhetho.
4. Ngaphakathi kwendawo eyandisiweyo 'Fumana kwaye Utshintshe', khetha Tshatisa iziqulatho zeeseli zizonke kunokwenzeka kwaye ucofe ku Fumana Konke iqhosha.
5. Xa ucofa kuFumana Konke, iiseli ezinamaxabiso angama-zero ziya kuphawulwa.
6. Gcina i Isitshixo soLawulo kwaye Cofa i Isitshixo ukukhetha zonke iiseli ezino-0 kuzo.
Ngoku, ngenxa yokuba ukhethe zonke iiseli ezinexabiso elingu-0, ungacima ooziro, utshintshe ooziro ngalo naluphi na uphawu okanye iiseli ezikhanyayo ezinooziro.
- Iindlela zokuFumana ukuPhindwa kabini kwi-Excel usebenzisa ukuFomatha okuneMiqathango
- Iindlela zokwenza iDesika yePivot kwi-Excel
Igama lam nguJavier Chirinos kwaye ndiyayithanda itekhnoloji. Ebudeni bexesha endikhumbula ngalo, ndandizithanda iikhompyutha nemidlalo yevidiyo yaye loo ndlela yokuzonwabisa yaphelela ekubeni ndifumane umsebenzi.
Bendipapasha malunga netekhnoloji kunye nezixhobo kwi-Intanethi ngaphezulu kweminyaka eyi-15, ngakumbi kwi mundobytes.com
Ndikwayingcali yonxibelelwano lwe-intanethi kunye nokuthengisa kwaye ndinolwazi lophuhliso lwe-WordPress.