Dos ndi Dont of Entering Data mu Excel

01 a 08

Zowonjezera Mauthenga Otsatira

Phunziroli limaphatikizapo zina mwazofunikira za DOs ndi DONTs zolembera mapulogalamu a spreadsheet monga Excel, Google Spreadsheets, ndi Open Office Calc.

Kulowetsa deta moyenera nthawi yoyamba kumatha kupeŵa mavuto kenako ndikupangitsa kuti zikhale zosavuta kugwiritsa ntchito zida zambiri za Excel ndi zinthu monga ma fomu ndi ma chati.

ZOKHUDZA NDI ZOCHITA ndi:

1. Konzani tsamba lanu
2. Musatuluke Mipanda Yoyamba kapena Ma Columns Pogwiritsa Ntchito Dongosolo Lina
3. Sungani Nthawi Zambiri ndi Kusunga M'madera Awiri
4. Musagwiritse ntchito Numeri ngati Mitu ya Mitu ndipo Musaphatikize Units ndi Data
5. Gwiritsani ntchito mafotokozedwe a magulu ndi mapepala otchulidwa m'mafomu
6. Musachoke Maselo okhala ndi Mafomu Osatsegulidwa
7. Konzani Deta Zanu

Ganizirani Zowonjezera Zanu

Pankhani yolumikiza deta ku Excel, ndi lingaliro loyenera kupanga pang'ono pokha musanayambe kulemba.

Podziwa zomwe tsambali lidzagwiritsidwe ntchito, deta yomwe idzakhala nayo, ndipo zomwe zidzachitike ndi deta imeneyo zingakhudze kwambiri mapeto a tsambali.

Kukonzekera musanayambe kusindikiza kungapulumutse nthawi yotsatira ngati spreadsheet iyenera kukonzedweratu kuti ikhale yovuta komanso yosavuta kugwira nawo ntchito.

Mfundo Zofunika Kuziganizira

• Kodi cholinga cha spreadsheet n'chiyani?
• Kodi spreadsheet imakhala ndi deta yochuluka bwanji?
• Kodi matchadi amafunikira?
• Kodi spreadsheet idzasindikizidwa?

Kodi Cholinga cha Spreadsheet N'chiyani?

• Cholinga cha spreadsheet chidzakuthandizani kudziwa malo a deta, momwe mfundo zofunika kwambiri ziyenera kuonekera ndi zosavuta kupeza.
• Ndi ziwerengero ziti zomwe zikufunika? Ziwerengero zimakhudza zomwe zimafunika ndi ntchito ndi kumene zidzakhala.

Kodi Spreadsheet Idzagwira Ntchito Zambiri Motani?

Kuchuluka kwa deta lomwe spreadsheet lidzagwiritse ntchito ndipo zomwe zidzawonjezere mtsogolomu zidzakhudza chiwerengero cha ma worksheet omwe agwiritsidwa ntchito.

• Musatambasule deta yanu mochuluka kwambiri chifukwa zingathe kupanga zovuta zenizeni kupeza ndi kuwerengera kupanga mapepala angapo kapena mabuku ogwira ntchito angathe kuyamba kusintha ntchito ya Excel.
• Kwa ma tsamba akuluakulu, nthawi zina zimathandiza kuwonetsa zigawo zofunikira za pamtundu pamwamba pa mutu wa pamutu, osati kukakamiza ogwiritsa ntchito kupyolera pansi pa tsamba kuti awone zambiri.

Kodi Makhadi Amafunika?

Ngati zonse kapena gawo la deta liyenera kuwonetsedwa mu tchati kapena ma chart, zikhoza kuwonetsa malemba,

• Malingana ndi mtundu wa tchati, deta ingafunikire kugawidwa mosiyana - monga kugwiritsa ntchito mwachidule pamapirati a pie.
• Kwa mapepala akuluakulu, ma chart angasunthidwe kuti alekanitse masamba kuti athe kuchepetsa

Kodi Tsambali Lidzalindikizidwa?

Momwe mungakonzere deta zingakhudzidwe ngati zonse kapena zina mwa deta zidzasindikizidwa, malingana ndi momwe masanjidwe a zithunzi kapena malo amasankhidwa ndi chiwerengero cha mapepala amafunika.

• Ngati zithunzi zojambula pamakalata olembedwa kawirikawiri (8 1/2 X 11) ziyenera kugwiritsidwa ntchito, ganizirani kuika zambiri pa mizere pansi pa zipilala zochepa, kuti mutu wonsewo uoneke pa pepala limodzi.
• Ngati pamakhala mapepala ambiri, ganizirani zolemba pamakalata pamwamba pa tsamba lililonse kuti muwerenge mosavuta deta.
• Ngati zigawo zambiri za deta ziyenera kusindikizidwa, malo okonzedwa akhoza kuyang'ana zonse pa tsamba limodzi. Apanso, ngati mapepala ambiri akufunika, sindikizani mutu wa pamwamba pa tsamba lililonse.
• Ngati mapepala amafunika kusindikizidwa, kuwasuntha ku pepala limodzi kungathe kuchepetsa ntchitoyi.

02 a 08

Musatuluke Mizere Yopanda Madzi kapena Ma Columns mu Dongosolo Lina

Kusiya mizere yopanda kanthu kapena mizere m'matawuni a deta kapena mndandanda wa deta zingapangitse kuti zikhale zovuta kwambiri kugwiritsa ntchito zinthu zambiri za Excel monga ma chati, matebulo a pivot, ndi ntchito zina.

Ngakhale kutsegula maselo mu mzere kapena ndime yomwe ili ndi deta ingayambitse mavuto monga momwe asonyezedwera mu chithunzi pamwambapa.

Kupezeka kwa malo opanda kanthu kudzakhalanso kosavuta kwa Excel kuti azindikire ndikusankha deta yonse yokhudzanayo ngati zinthu monga kupatula , kufuta, kapena AutoSum amagwiritsidwa ntchito.

M'malo mosiya mizere yopanda kanthu kapena zikhomo, gwiritsani ntchito malire kapena maonekedwe a malemba ndi malemba pogwiritsa ntchito molimbika kapena pansipo kuti muwononge deta ndikupanga mosavuta kuwerenga.

Lowetsani deta yanu-yanzeru ngati n'kotheka.

• Pamene mutayika tsamba lanu, perekani mutu wofotokozera pamwamba pa ndime yoyamba ya tebulo ndi deta ili pansipa.
• Ngati pali zowonjezereka zotsatila deta, lembani mndandanda wa zigawozo (kumanzere kupita kumanja) ndi mutu wa mndandanda uliwonse wa deta pamwamba.

Sungani Zophatikiza Zapadera

Pamene kusunga deta yolumikizana pamodzi kuli kofunika, panthawi imodzimodzi, zingakhale zothandiza kusunga mizere yosiyana ya deta yosiyana.

Kusiya zipilala zopanda kanthu kapena mizera pakati pa ma data osiyanasiyana kapena deta ina pa tsambalo la ntchito lidzakhalanso losavuta kwa Excel kuti azindikire molondola ndikusankha mizere yofanana kapena magome a deta.

03 a 08

Sungani Nthawi Zambiri

Kufunika kopulumutsa ntchito yanu kawirikawiri sikungathetsedwe - kapena kunenedwa kawirikawiri.

Inde, ngati mukugwiritsa ntchito spreadsheet yapa intaneti - monga Google Spreadsheets kapena Excel Online - kenako kupulumutsa sivuta, chifukwa palibe pulogalamu yomwe ili ndi zosankha koma, m'malo mwake, gwiritsani ntchito pulogalamu yopulumutsa galimoto.

Kwa mapulogalamu a makompyuta ngakhale, pambuyo pa kusintha kwachiwiri kapena katatu - kaya ndikuwonjezera deta, kupanga kusintha kwa maonekedwe, kapena kulowetsa ndondomeko - sungani tsambalo.

Ngati izo zikuwoneka mochuluka, sungani osachepera mphindi ziwiri kapena zitatu.

Ngakhale kuti makompyuta ndi mapulogalamu a pakompyuta akhala bwino kwambiri zaka zingapo zapitazi, pulogalamuyi ikugwedezeka, zoperewera zamagetsi zikuchitikabe, ndipo nthawi zina anthu ena amayenda chingwe cha mphamvu ndikuchikoka kunja kwa khoma.

Ndipo zikachitika, kutayika kwa deta iliyonse - zazikulu kapena zazing'ono - kumangowonjezera ntchito yanu pamene mukuyesera kukonzanso zomwe mwachita kale.

Excel ili ndi gawo lopulumutsa galimoto , lomwe limagwira ntchito bwino, koma siliyenera kudalira. Khalani ndi chizoloŵezi chopeza deta yanu yomwe mumakhala nayo nthawi zambiri.

Njira yopatulira yopita ku Saving

Kusunga sikuyenera kukhala ntchito yowopsya yosuntha mbewa ku riboni ndikukongoletsa pazithunzi, khalani ndi chizoloŵezi chosunga pogwiritsa ntchito njira yowonjezera mzere wa:

Ctrl + S

Sungani Malo Awiri

Gawo lina lakupulumutsidwa lomwe silingathe kuwonjezereka ndi kufunika kosunga deta yanu m'malo awiri osiyana.

Malo achiwiri ali, ndithudi, kusungira, ndipo zanenedwa nthawi zambiri, "Zikalata zili ngati inshuwalansi: khalani ndi umodzi ndipo simungasowa, musakhale nawo limodzi ndipo mwinamwake mudzachita".

Choyimira bwino kwambiri ndi chimodzi chomwe chili pamalo osiyana kuchokera pachiyambi. Ndipotu, ndi mfundo yanji yokhala ndi maofesi awiri ngati ali

• ali pa galimoto yomweyo yomwe imalephera?
• pa kompyuta yomweyo, yomwe imabedwa?
• mu nyumba yomweyo yomwe imayaka pansi?

Zotsatira Zogwiritsa Ntchito Webusaiti

Kachiwiri, kupanga kusungidwa sikuyenera kukhala ntchito yowopsya kapena yogwiritsira ntchito nthawi.

Ngati chitetezo sichiri vuto - tsambali ndilo mndandanda wa DVD yanu - tumizani nokha makalata anu pogwiritsa ntchito mauthenga a pa intaneti kuti chikalata chikhalebe pa seva mwina chokwanira.

Ngati chitetezo ndi vuto, kusungirako webusaiti akadakalipo - ngakhale ndi kampani yomwe imagwirizana ndi zinthu zoterozo ndi kulipira malipiro otero.

Pankhani ya ma-spreadsheet a pa intaneti, mwinamwake, eni ake a pulogalamu amasunga ma seva awo - ndipo izi zikuphatikizapo zonse zomwe akugwiritsa ntchito. Koma kuti mukhale otetezeka, koperani fayilo yanu ku kompyuta yanu.

04 a 08

Musagwiritse ntchito Numeri ngati Mitu ya Mitu ndipo Musaphatikize Units ndi Data

Gwiritsani ntchito mitu yomwe ili pamwamba pazitsulo komanso kumayambiriro kwa mizere kuti mudziwe deta yanu, pamene akupanga ntchito monga kusankha mosavuta, koma musagwiritse ntchito nambala - 2012, 2013, ndi zina zotero - kuti muchite.

Monga momwe tawonetsera pa chithunzi pamwambapa, mitu ndi mitu ya mzere yomwe ili nambala chabe ingakhale yowerengedwa muzowerengera. Ngati mawonekedwe anu ali ndi ntchito monga:

• Sungani ,
• AutoMax ,
• Zomwe Zidasintha .

zomwe zimangosankha mndandanda wa deta yotsutsana ndi ntchito .

Kawirikawiri, ntchito zoterezo zimayang'ana kaye pazithunzi zapamwamba pamwamba pa malo omwe alipo ndiyeno kumanzere kwa manambala amodzi, ndipo mitu iliyonse yomwe ili nambalayi idzaphatikizidwa muzinthu zosankhidwa.

Numeri yogwiritsidwa ntchito ngati mitu ya mzere ikhozanso kulakwitsa ngati mndandanda wina wa deta ngati ikusankhidwa ngati gawo la tchati m'malo molemba ngati nkhwangwa.

Mawerengedwe apangidwe mu maselo oyambirira monga malemba kapena kulenga malemba apamtima poyambirira chiwerengero chirichonse ndi apostrophe (') - monga' 2012 ndi '2013. Apostrophe sichisonyeze mu selo, koma imasintha nambala kuti ikhale deta.

Sungani Units mu Mitu

Osati: lowetsani ndalama, kutentha, mtunda kapena ma unit ena mu selo iliyonse ndi deta ya chiwerengero.

Ngati mutero, pali mwayi woti Excel kapena Google Spreadsheets aziwona deta yanu yonse ngati malemba.

M'malo mwake, ikani zigawo pamitu yomwe ili pamwamba pa chigawocho, zomwe, ngati zichitika, zidzatsimikizira kuti zigawozo ndizolemba ndipo sizingapangitse vuto lomwe takambirana pamwambapa.

Lembani kumanzere, Numeri kumanja

Njira yowonetsera kuti muwone ngati muli ndi malemba kapena chiwerengero cha nambala ndikuyang'ana kulumikizidwa kwa deta mu selo. Mwachinsinsi, deta yanu ikugwirizana ndi kumanzere ku Excel ndi Google Spreadsheets ndi deta ya data ikugwirizana kumanja mu selo.

Ngakhale kusintha kosasintha kumeneku kungasinthidwe mosavuta, kufotokozera sikumagwiritsidwa ntchito mpaka pambuyo pa deta zonse ndi mayina atalowa, kotero kusinthika kosasinthika kungakupatseni chitsimikizo msanga kuti chinachake chiri chosasangalatsa pa tsamba la ntchito.

Maperesenti ndi Zizindikiro Za Ndalama

Chinthu chabwino kwambiri cholowetsa deta yonse muzomwe mukulemba ndikutumiza nambala yeniyeni ndikusintha selo kuti muwonetse nambalayi molondola - ndipo izi zikuphatikizapo kuchuluka kwa ndalama ndi ndalama.

Excel ndi Google Spreadsheets, komabe, mvetserani zizindikiro zomwe zimayikidwa mu selo limodzi ndi nambala ndipo onse awiri amazindikiranso zizindikiro za ndalama, monga chizindikiro cha dola ($) kapena chizindikiro cha pounds la British (£) ngati atayikidwa selo limodzi ndi chiwerengero cha chiwerengero, koma zizindikiro zina za ndalama, monga South African Rand (R), zikhoza kumasuliridwa ngati malemba.

Kuti mupewe mavuto omwe mungathe, tsatirani njira yabwino yomwe tatchulidwa pamwambayi ndi kulowetsa ndalamazo ndikuyimira selo kuti mukhale ndalama m'malo molemba zizindikiro za ndalama.

05 a 08

Gwiritsani ntchito mafotokozedwe a magulu ndi mapepala otchulidwa m'mafomu

Zomwe mafotokozedwe a maselo ndi mayina omwe angatchulidwe angakhale nawo ndipo ayenera kugwiritsidwa ntchito m'mafomu kuti apange mofulumira komanso mosavuta kusunga malemba ndi powonjezera, pepala lonse, zopanda zolakwika komanso mpaka lero.

• Maumboni a magulu ndi ophatikizana ndi kalata ya mzere ndi mzere wa selo - monga A1, B23, ndi W987 - ndipo amagwiritsidwa ntchito kuzindikira malo a deta mu tsamba.
• Dzina lotanthauzira kapena dzina lotanthauzira likufanana ndi selo lofotokozera mu selolo kuti limagwiritsidwa ntchito kuzindikira selo kapena maselo ambiri mu tsamba.

Kufotokozera Data mu Mafomu

Mafomu amagwiritsidwa ntchito ku Excel kuti achite mawerengedwe - monga kuwonjezera kapena kuchotsa.

Ngati nambala yeniyeni imaphatikizidwa mu mafomu - monga:

= 5 + 3

Nthawi iliyonse pamene deta ikusintha- imanena kuti 7 ndi 6, ndondomekoyo iyenera kusinthidwa ndipo nambalayi inasintha kotero kuti chiwerengero chikhala:

= 7 + 6

Ngati, mmalo mwake, deta yalowa mu maselo mu tsamba, zolemba za selo - kapena mayina a mayina - zingagwiritsidwe ntchito mu chiwerengero m'malo mwa nambala.

Ngati nambala 5 yalowa mu selo A 1 ndi 3 mu selo A2, ndondomeko imakhala:

= A1 + A2

Kuti muwonjezere deta, sintha zomwe zili mu maselo A1 ndi A2, koma chiwerengerocho chikhala chimodzimodzi - Excel mowonjezera amasintha zotsatira zake.

Kusungidwa kwa nthawi ndi khama kumawonjezeka ngati tsambali liri ndi zovuta zambiri komanso ngati maulendo angapo amawunikira deta yomweyi kuchokera pamene deta ikuyenera kusinthidwa pamalo amodzi komanso mayendedwe onse omwe akuyang'anawo adzasinthidwa.

Kugwiritsira ntchito mapepala kapena mapepala omwe amatchulidwa kumapangitsanso kuti ntchito yanu ikhale yotetezeka, chifukwa imakulolani kuteteza mawonekedwe kuchokera ku kusintha kwadzidzidzi pamene mukusiya maselo osintha omwe akusintha kupezeka.

Kuwonetsera pa Deta

Chinthu chinanso cha Excel ndi Google Spreadsheets ndi chakuti amakulowetsani kuti mulowetse mafotokozedwe a magulu kapena maina a mayina kukhala mawonekedwe pogwiritsa ntchito kukopa - zomwe zimaphatikizapo kusindikiza pa selo kuti mulowerere muzokambirana.

Kuwonetsera kumachepetsa kuthekera kwa zolakwika zomwe zimapangika polemba zolakwika pa selo lolakwika kapena kuposera dzina lachinyama.

Gwiritsani Njira Zotchulidwa Zosankha Deta

Kupereka dzina lofanana ndi deta kungachititse kuti zisakhale zosavuta kusankha deta pamene mukuchita zojambula kapena zojambula.

Ngati kukula kwa deta kusinthika, mayina osiyanasiyana angasinthidwe mosavuta pogwiritsira ntchito Name Manager .

06 ya 08

Musachoke Maselo Ophatikiza Mafomu Osatetezedwa

Pambuyo pokhala ndi nthawi yochuluka yolemba njira zawo ndikugwiritsira ntchito selo lolondola, anthu ambiri amalakwitsa kusiya njira zomwe zingawonongeke mwangozi kapena mwadzidzidzi.

Mwa kuyika deta m'maselo mu ofesi ya ntchito ndikuwonetseratu detayi m'mafomu, amalola maselo okhala ndi mayendedwe kuti atseke ndipo, ngati n'koyenera, mawu otetezedwa amatetezedwa.

Panthawi imodzimodziyo, maselo omwe ali ndi deta angasiyidwe kutsegulidwa kotero kuti kusintha kungatheke mosavuta kuti pakhale spreadsheet.

Kuteteza tsamba kapena buku la ntchito ndi njira ziwiri:

1. Onetsetsani kuti maselo olondola atsekedwa
2. Ikani pepala loteteza - ndipo ngati mukufuna, yonjezerani mawu achinsinsi

07 a 08

Konzani Deta Zanu

Sungani deta yanu mutatha kumalowa.

Kugwira ntchito ndi deta yosawerengeka mu Excel kapena Google Spreadsheets sikumakhala vuto, koma ngati chiwerengero cha deta chikuwonjezeka kotero zimakhala zovuta kugwira nawo ntchito bwino.

Deta yosankhidwa ndi yosavuta kumvetsetsa ndi kusanthula ndipo zina ntchito ndi zipangizo, monga VLOOKUP ndi SUBTOTAL zimafuna deta yolongosoledwa kuti abweretse zotsatira zolondola.

Ndiponso, kusanthula deta yanu m'njira zosiyanasiyana kungathandize kuti muwone zovuta zomwe sizikuwonekera poyamba.

Kusankha Dongosolo Yopangidwe

Deta isanayambe kusankhidwa, Excel iyenera kudziwa momwe mungayankhire, ndipo kawirikawiri, Excel ndi yabwino kwambiri posankha dera lofanana ndi deta - pokhapokha italowa,

1. Palibe mizere kapena mizere yopanda kanthu yomwe inasiyidwa mkati mwa dera lofanana;
2. ndipo mizere yopanda kanthu ndi ndondomeko zatsalira pakati pa madera ofanana.

Excel idzatsimikiziranso, molondola, ngati deta ili ndi mayina amtundu ndikusiya mzerewu kuchokera ku zolemba zomwe zidzasankhidwe.

Komabe, kulola Excel kusankha mndandanda womwe udzasankhidwe ukhoza kukhala wowopsa - makamaka ndi deta yambiri yomwe ndi yovuta kuyang'ana.

Kugwiritsa Ntchito Mayina kuti Sankhani Data

Kuti muwonetsetse kuti deta yolondola yasankhidwa, yambani mndandanda wanu musanayambe mtunduwu.

Ngati njira yofananayo iyenera kusankhidwa mobwerezabwereza, njira yabwino kwambiri ndikupatsamo mayina.

Ngati dzina limatanthauzidwa kuti mayendedwe angasankhidwe, lembani dzina mu Bokosi la Dzina , kapena lisankhe kuchokera pazomwe likuphatikizidwapo ndi Excel idzawonetsera ndondomeko yolondola ya deta muzenera.

Mizere Yobisika ndi Ma Coloni ndi Kukonza

Mizere yosabisa ndi ndondomeko ya deta sizisuntheka panthawi yosankha, kotero zimayenera kusokonezedwa musanakhale mtunduwo.

Mwachitsanzo, ngati mzere 7 uli wobisika, ndipo ndi mbali ya deta yochuluka yomwe yasankhidwa, idzakhalabe mzere 7 osati kusunthira ku malo ake olondola chifukwa cha mtunduwo.

Zomwezo zimapita pazithunzi za deta. Kusankha ndi mizere kumaphatikizapo kukonzanso ndondomeko ya deta, koma ngati Pambuyo B imabisika musanakhale mtunduwo, idzakhalabe ngati Phula B ndipo sichidzasinthidwa ndizitsulo zina muzinthu zosiyana.

08 a 08

Numeri yonse iyenera kukhala Masitolo monga Numeri

Nkhani: Onetsetsani kuti manambala onse amasungidwa ngati nambala. Ngati zotsatira sizinali zimene inu mumayembekeza, chigawocho chingakhale ndi manambala omwe amasungidwa monga malemba osati monga manambala. Mwachitsanzo, nambala zolakwika zomwe zimatumizidwa kuchokera ku machitidwe ena owerengetsera ndalama kapena nambala yomwe inalowa ndi mtsogoleri 'apostrophe' amasungidwa ngati malemba.

Mukafulumira kukonza deta ndi ndondomeko ya AZ kapena ZA, zinthu zingayende molakwika. Ngati pali mzere wopanda kanthu kapena zipilala zopanda kanthu mkati mwa deta, mbali ya deta ikhoza kusankhidwa, pamene deta ina imanyalanyazidwa. Tangoganizirani chisokonezo chomwe muli nacho, ngati mayina ndi nambala ya foni sakugwirizana, kapena ngati mauthenga akupita kwa makasitomala olakwika!

Njira yosavuta yowonetsetsa kuti deta yolondola isankhidwa musanayambe kusankha ndikupatseni dzina.

Kulingalira kwachiwiri kumakhudza chimodzimodzi mtundu wa Excel. Ngati muli ndi selo imodzi yosankhidwa, Excel imasankha kusankha mtundu (mofanana ndi kukanikiza Ctrl + Shift + 8) yokhala ndi imodzi kapena zingapo zopanda mazere ndi mizere. Icho chimayang'ana mzere woyamba muzosankhidwa kuti mudziwe ngati uli ndi chidziwitso cha mutu kapena ayi.

Apa ndi pamene kusankha ndi zida zamatabwa zitha kukhala zonyenga-mutu wanu (mukuganiza kuti muli nawo) muyenera kutsata ndondomeko zovuta kuti Excel izindikire ngati mutu. Mwachitsanzo, ngati pali magulu opanda kanthu m'mzere wamutu, Excel angaganize kuti si mutu. Mofananamo, ngati mzere wa mutu ukupangidwira chimodzimodzi ndi mizere ina mu deta, ndiye kuti sangachizindikire. Ndiponso, ngati tebulo lanu la deta liri ndi malemba onse ndipo mzere wanu wamutu ulibe kanthu koma malemba, Excel adzakhala-pafupifupi nthawi zonse-kulephera kuzindikira mzere wa mutu. (Mzerewu ukuwoneka ngati mzere wina wa deta ku Excel.)

Pambuyo pokhapokha mutasankha mtunduwo ndikuwonetsetsa ngati pali mzere wa mutu, Excel idzachita zomwezo. Momwe mukukondwera ndi zotsatira zimatengera kuti Excel ili ndi kusankha kwasankhidwe ndi mzere wa mzere wolondola. Mwachitsanzo, ngati Excel sakuganiza kuti muli ndi mzere wa mutu, ndipo mutero, ndiye mutu wanu wasankhidwa mu thupi la deta; izi ndizovuta.

Kuti muwonetsetse kuti mtundu wanu wa deta wadziwika molondola, gwiritsani ntchito njira ya Ctrl + Shift + 8 kuti muwone zomwe Excel amasankha; izi ndi zomwe zidzapatulidwe. Ngati sichikugwirizana ndi zomwe mukuyembekeza, ndiye kuti mukusintha khalidwe la deta lanu, kapena muyenera kusankha deta musanayambe kugwiritsa ntchito mtundu wa dialog box.

Kuti muonetsetse kuti mutu wanu wavomerezedwa molondola, gwiritsani ntchito njira yowonjezera ya Ctrl + Shift + 8 kuti musankhe ma data, kenako yang'anani mzere woyamba. Ngati mutu wanu ulibe mzere pakati pa omwe asankhidwa mzere woyamba kapena mzere woyamba umakonzedwa ngati mzere wachiwiri, kapena muli ndi mzere wambiri wa mutu, ndiye Excel akuganiza kuti mulibe mzere uliwonse. Kuti mukonze izi, pangani kusintha kwa mzere wanu wa mutu kuti muwonetsetse kuti ndizovomerezedwa bwino ndi Excel.

Potsirizira pake, kubetcha konse kungatheke ngati tebulo lanu la deta likugwiritsa ntchito mitu ya mzere wambiri. Excel ili ndi nthawi yovuta kuwazindikira iwo. Mumayambitsa vutoli pamene mukuyembekezera kuti likhale ndi mizere yopanda kanthu mu mutuwo; izo sizingakhoze basi kuzichita izo mosavuta. Komabe, mungathe kusankha mzere womwe mukufuna kuti musankhe musanakhale nawo. Mwa kuyankhula kwina, khalani mwachindunji mu zomwe mukufuna Excel kukhazikitse; musalole Excel kupanga malingaliro anu.
Nthawi ndi Nthawi Zasungidwa Monga Malemba

Ngati zotsatira za kusankhidwa ndi tsiku sizikuyembekezeredwa, deta yomwe ili ndi chingwe cha mtunduyi ingakhale ndi nthawi kapena nthawi yosungidwa monga deta m'malo mwa nambala (masiku ndi nthawi ndizowerengedweratu deta).

Mu chithunzi pamwambapa, chiwerengero cha A. Peterson chinatha pansi pa mndandandanda, pamene, patsiku la ngongole - November 5, 2014 -, mbiriyi iyenera kuikidwa pamwamba pa mbiri ya A. Wilson, yomwe ali ndi ngongole ya November 5.

Chifukwa cha zotsatira zosayembekezereka ndikuti tsiku lokwanira kwa A. Peterson lasungidwa monga malemba, osati monga nambala
Dongosolo la Mixed ndi Mitundu Yofulumira.

Pogwiritsira ntchito njira zofulumira zamakalata zomwe zili ndi malemba ndi nambala yosakanikirana, Excel amawonetsa deta ndi deta pambali pawokha - kuyika zolembazo pamndandanda wamndandanda pansi pa mndandanda womwewo.

Excel ikhoza kuphatikizapo mitu ya mndandanda mu zotsatira za mtundu - kutanthauzira iwo ngati mzere wina wa deta yolemba m'malo mofanana ndi maina a masamba pa tebulo la deta.
Samalitsani Chenjezo - Fufuzani Bokosi Loyambira

Monga momwe tawonetsera pa chithunzi pamwambapa, ngati mndandanda wa mafotokozedwewo akugwiritsidwa ntchito, ngakhale kwa mitundu yosiyanasiyana, Excel ikuwonetsera uthenga ukukuchenjezani kuti wapeza deta yosungidwa ngati malemba ndikukupatsani kusankha:

Sungani chirichonse chomwe chikuwoneka ngati nambala monga nambala
Sankhani manambala ndi manambala omwe amasungidwa mosiyana

Ngati mutasankha njira yoyamba, Excel ayesa kuyika deta yanu pamalo oyenera a zotsatira za mtundu.

Sankhani njira yachiwiri ndipo Excel idzalemba malemba omwe ali ndi deta pansi pa zotsatira za mtundu - monga momwe amachitira ndi mitundu yofulumira.