Njira 6 Zowonetsera Dongosolo mu Excel

Zoterezi zimaphatikizapo njira zosiyanasiyana zosankhira deta ku Excel. Mauthenga enieni angapezeke pamasamba otsatirawa:

1. Yambani Pangani pa Khola Limodzi pogwiritsa ntchito Mndandanda & Fyuluta kapena Hot Keys
2. Sungani pa Mizere Yambiri
3. Sungani ndi Dates kapena Times
4. Sungani ndi Masiku a Sabata, Miyezi kapena Mndandanda Wodzinenera
5. Sungani ndi Mizere - Mizere Yowonongeka

Kusankha Dongosolo kuti Likhale

Deta isanayambe kusankhidwa, Excel iyenera kudziwa momwe mungayankhire, ndipo kawirikawiri Excel ndi yabwino kwambiri posankha dera lofanana - 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.

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

Ngati njira yofananayo iyenera kusankhidwa mobwerezabwereza, njira yabwino kwambiri ndiyipatsire dzina .

01 ya 05

Sakani Mndandanda ndikukonzekera Dongosolo

Kusankha kumafuna kugwiritsa ntchito makiyi a mtundu ndi dongosolo la mtundu.

Mndandanda wa mtundu ndi deta m'ndandanda kapena zigawo zomwe mukufuna kuzikonza. Zimadziwika ndi mutu wa mutu kapena dzina lamasamba. Mu chithunzi pamwambapa, zowonjezeka mtundu wamakina ndi ID ya Ophunzira, Dzina , Mbadwo , Ndondomeko , ndi Mwezi Woyambira

Mofulumira, kudumpha pa selo imodzi m'mphindi yomwe ili ndi fungulo loyipa ndikwanira kuuza Excel chomwe chiri fungulo.

Kwa malemba kapena manambala, njira ziwiri zomwe mungasankhe zikukwera ndikutsika .

Pogwiritsa ntchito batani la mtundu ndi fyuluta pa Tsambali la Home la Ribbon, zosankha zotsatsa ndondomekoyi zidzasintha malinga ndi mtundu wa deta muzomwe mwasankha.

Yambani Pangani pogwiritsa ntchito Pangani & Fyuluta

Mu Excel, njira yofulumira ikhoza kugwiritsidwa ntchito pogwiritsa ntchito Bungwe la Fuluta & Fuluta pa Tsambali la Home la Ribbon .

Masitepe ochita mwamsanga ndi awa:

1. Dinani pa selo m'ndandanda yomwe ili ndi fungulo
2. Dinani ku tabu la Home la Ribbon ngati kuli kofunikira
3. Dinani pa Bungwe la Fuluta & Fululuta kuti mutsegule zosankha zosankha
4. Dinani pa chimodzi mwa njira ziwiri zomwe mungakonze kuti muzitha kukwera kapena kutsika
5. Onetsetsani kuti ndondomekoyi yasankhidwa molondola

Sungani Dongosolo Pogwiritsa Ntchito Keyi Zowonjezera

Palibe kuphatikiza kwachinsinsi chachinsinsi chachinsinsi kuti musankhe data mu Excel.

Zomwe zilipo ndi mafungulo otentha, omwe amakulolani kugwiritsira ntchito makina osakaniza m'malo mogwiritsira ntchito ndondomeko yamagulu kuti musankhe zofanana zomwe zili pamwambapa pa tsamba la Home la Riboni.

• Kugwiritsa ntchito kibokosi kuti mupeze njira zachitsulo nthawi zonse zimayambira ndi Alt .

Kuti muyese mukukwera Muyeso Pogwiritsa Ntchito Zowonjezera

1. Dinani pa selo m'mbali ya fungulo
2. Dinani mafungulo otsatirawa pa kibokosilo:
3. Alt HSS
4. Gome la deta liyenera kusankhidwa A mpaka Z / zing'onozing'ono mpaka zazikulu mwasankhidwa

Makina otentha amatanthauzira:
Zithunzi "Alt"> "Home" tab> "Kusintha" gulu> "Sungani & Sungani" menyu> "Sankhani Zochepa Kwambiri Kuposa".

Kuti muyese mukutsika kwadongosolo pogwiritsa ntchito makatani opatsa

Mayendedwe otsika mukudutsa dongosolo pogwiritsa ntchito mafungulo otentha ndi ofanana ndi omwe adatchulidwa ndi mtundu wopita kupatulapo makiyi otentha ndi awa:

Alt HSO

Makina otentha amatanthauzira:
Zithunzi "Alt"> "Home" tab> "Kusintha" gulu> "Sungani & Sungunulani" menyu> "Sankhani Njira Yaikulu Kwambiri".

02 ya 05

Sakani pa Zowonjezera Zambiri za Data mu Excel

Kuwonjezera pa kuchita mwamsanga mwadongosolo la deta limodzi, kachitidwe kachitidwe ka Excel kachitidwe kamene kamakupatsani inu kusankha mitundu yambiri pofotokozera mafungulo a mitundu angapo.

Mu mitundu yambiri ya mndandanda, mafungulo amtundu amadziwika mwa kusankha mitu ya mndandanda mu bokosi la mtundu wa mtundu.

Monga mofulumira, mawonekedwe amtunduwa amatanthauzira pozindikiritsa mitu ya masamba kapena ma field , mu tebulo yomwe ili ndi fungulo.

Sakani pa Zowonjezera Zambiri Zitsanzo

Mu chitsanzo pamwambapa, ndondomeko zotsatirazi zinatsatidwa kuti muyese ndondomekoyi pa ma H2 ndi L12 pazitsulo ziwiri za deta - poyamba, ndi zaka.

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe
2. Dinani pa tabu la Home la riboni .
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule tsambali.
4. Dinani pa Custom Custom mundandanda wotsika pansi kuti mulembe mtundu wa dialog box
5. Pansi pa Phula yomwe ikulowetsa mu bokosi, lembani Dzina kuchokera mundandanda wotsika pansi kuti muyambe kulemba deta ndi Name Name
6. Mtundu Wosankha uli wosankhidwa ku Malamulo - popeza mtunduwo uli wochokera pazinthu zomwe zili patebulo
7. Pansi pa mtundu wa Order Order , sankhani Z mpaka A kuchokera m'ndandanda wotsika pansi kuti muyese deta la Deta pansi
8. Pamwamba pa bokosi la bokosi, dinani pazowonjezera pazenera kuti muwonjezere njira yachiwiri yomwe mungasankhe
9. Kwachifungulo chachiwiri chachiwiri, pansi pa Putsani mutu, sankhani Zaka kuchokera m'ndandanda wotsika kuti mukonze ma rekodi ndi mayina ofotokozedwa ndi ndime ya Age
10. Pogwiritsa ntchito mtundu wa Order Order , sankhani Zapamwamba kwambiri mpaka Zina Zapang'ono kuchokera pa ndondomeko yotsika pansi kuti muwonetsetse deta ya zaka za pansi poyerekeza
11. Dinani KULUNGA mu bokosi la bokosi kuti mutseke bokosi la dialog ndikukonzekera deta

Chifukwa cha kufotokozera fungulo lachiwiri, mu chitsanzo chapamwamba, zolemba ziwiri zomwe zili ndi zizindikiro zofanana za malo a Name zinakonzedweratu poyerekeza pogwiritsa ntchito gawo la Age , zomwe zinachititsa kuti wophunzira alembedwe A. Wilson wa zaka 21 ali kale mbiri ya yachiwiri A. Wilson wa zaka 19.

Mzere Woyamba: Mitu Yoyambira kapena Deta?

Mndandanda wa deta yosankhidwa kuti muyese mu chitsanzo pamwambapa ikuphatikizapo mitu ya mndandanda pamwamba pa mzere woyamba wa deta.

Excel adapeza mzerewu uli ndi deta yomwe idali yosiyana ndi deta yomwe ili ndi mzere wotsatira kuti ikhale mzere woyamba kuti ukhale mitu yazithunzi ndikusintha njira zomwe zilipo mubox dialog box kuti awaphatikize.

Njira imodzi yomwe Excel amagwiritsira ntchito kuti aone ngati mzere woyamba uli ndi zilembo zazithunzi zimapangidwira. Mu chitsanzo chapamwamba, mawu omwe ali mzere woyamba ndi amtundu wosiyana ndipo ndi mtundu wosiyana kuchokera ku deta yonseyi. Iyenso imasiyanitsidwa ku mizera yomwe ili pansipa ndi malire akuda.

Excel amagwiritsira ntchito kusiyana kotere pakupanga kutsimikiza kuti mzere woyamba ndi mzere wotsatira, ndipo ndi bwino kuti uwupeze bwino - koma sungatheke. Ngati akulakwitsa, bokosi la mndandanda uli ndi bokosi - Deta yanga ili ndi mitu - yomwe ingagwiritsidwe ntchito kupititsa chisankho ichi.

Ngati mzere woyamba ulibe zilembo, Excel amagwiritsa ntchito kalatayi - monga Pambuyo D kapena Phunziro L - monga zosankhidwa muzomwe mungapezeko.

03 a 05

Sankhani Dongosolo Tsiku kapena Nthawi mu Excel

Kuphatikiza pa kusanthula deta malemba ndi ziwerengero kuchokera ku zazikulu mpaka zochepetsetsa, Zosankha za Excel ndizosankhira zamtengo wamasiku.

Malamulo amtundu wa masiku ndi awa:

• Kukwezera dongosolo - wakale kuti atsopano
• Kutsika dongosolo - chatsopano kwa zakale

Yambani Mutsatanetsatane ndi Bokosi la Dialog

Kuchokera masiku ndi nthawi ndi deta yokha yowerengedwera, chifukwa cha mtundu umodzi - monga Tsiku Lobwerekedwa mwachitsanzo mu chithunzi pamwambapa - njira yowonongeka ingagwiritsidwe ntchito bwino.

Kwa mitundu yosiyanasiyana yomwe imakhudza maulendo angapo a maulendo kapena nthawi, Bokosi lakulumikiza liyenera kugwiritsidwa ntchito - monga momwe mungasankhire pazambiri zamndandanda wa deta kapena ma data.

Sungani ndi Tsiku Chitsanzo

Kuchita mwamsanga msanga ndi tsiku mukukwera dongosolo - zakale mpaka zatsopano - mwachitsanzo mu chithunzi pamwambapa, masitepe angakhale:

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe
2. Dinani pa tabu la Home la riboni
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule mndandanda wotsika
4. Dinani pa Mndandanda Wakale kwambiri ku Chinthu Chatsopano koposa mndandanda kuti muyese deta mu kukwera dongosolo
5. Zolembazo ziyenera kusankhidwa ndi masiku akale kwambiri mu gawo loperekedwa pamwamba pa tebulo

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

Mukamagwiritsira ntchito njira yofulumira ngati malemba omwe ali ndi malemba ndi nambala akuphatikizana pamodzi, Excel amawerengetsa nambala ndi mauthenga payekha - 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.

04 ya 05

Kusanthula Dera ndi Masiku a Sabata kapena Mwezi ku Excel

Sungani ndi masiku a sabata kapena miyezi ya chaka pogwiritsa ntchito mndandanda womwewo womangidwa mwapadera womwe Excel amagwiritsa ntchito kuwonjezera masiku kapena miyezi ku pepala lolemba pogwiritsira ntchito chodzaza .

Mndandandawu umaloledwa kupatulira ndi masiku kapena miyezi nthawi motsatira nthawi.

Mu chitsanzo chapamwamba, deta yasankhidwa ndi mwezi umene ophunzira adayambitsa maphunziro awo pa intaneti.

Monga momwe mungasankhire mitundu ina, kusankha mndandanda mwa mndandanda wa mwambo ungasonyezedwe kukwera (Lamlungu mpaka Loweruka / January mpaka December) kapena kutsika dongosolo (Loweruka mpaka Lamlungu / December mpaka December).

Mu chithunzi pamwambapa, ndondomeko zotsatirazi zinatsatidwa kuti muyese chitsanzo cha deta m'madera osiyanasiyana H2 ku L12 ndi miyezi ya chaka:

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe
2. Dinani pa tabu la Home la riboni .
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule tsambali.
4. Dinani pa Custom Custom mundandanda wotsika kuti mubweretse mtundu wa dialog box
5. Pansi pa Phula yomwe ikulowetsa mu bokosi, khalani Mwezi Woyambira pa ndondomeko yotsika pansi kuti muyese ndondomeko ya miyezi ya chaka
6. Mtundu Wosankha uli wosankhidwa ku Malamulo - popeza mtunduwo uli wochokera pazinthu zomwe zili patebulo
7. Pansi pa mtundu wa Order Order , dinani pansi pavivi pafupi ndi njira yosasinthika A mpaka Z kuti mutsegule menyu
8. Mu menyu, sankhani Mndandanda wamtundu kuti mutsegule bokosi la dialog L Custom
9. Muwindo lamanzere la bokosi, dinani kamodzi pandandanda: January, February, March, April ... kuti muzisankhe

10. Dinani OK kuti mutsimikizire kusankha ndikubwezeretsani ku Bokosi la dialog

11. Mndandanda wosankhidwa - January, February, March, April - udzawonetsedwa pansi pa mutu wa Order

12. Dinani OK kuti mutseke bokosi la dialog ndikuyang'ana detayi miyezi ya chaka

Zindikirani : Mwachindunji, mndandanda wamakhalidwewo umawonetsedwa pokhapokha kukwera dongosolo mu Custom Lists dialog box. Kukonzekera deta mukudutsa dongosolo pogwiritsa ntchito mndandanda wamakhalidwe mutasankha mndandanda wofuna kuti uwonetsedwe pansi pa Order yomwe ikupita mu bokosi la mtunduwu:

1. Dinani pamsana wotsika pafupi ndi mndandanda wawonetsedwe - monga January, February, March, April ... kuti mutsegule menyu otsika
2. Mu menyu, sankhani njira yowonongeka yomwe ikuwonetsedwa mukutsika - monga December, November, October, September ...

3. Dinani OK kuti mutseke bokosi la bokosi ndikusanthula deta mukutsika pogwiritsa ntchito mndandanda wa mwambo

05 ya 05

Sungani ndi Mizere Yomwe Mungakambirane Ma Columns mu Excel

Monga momwe zisonyezedwera ndi zosankha zamtundu wakale, deta imasankhidwa pogwiritsa ntchito mitu ya masamba kapena mayina a pamunda ndipo zotsatira zake ndizobwezeretsa mizere yonse kapena zolemba za deta.

Chinthu chosadziwika bwino, chomwecho, chosagwiritsidwa ntchito mosagwiritsidwa ntchito pa Excel ndiko kusankha mzere, womwe uli ndi zotsatira zokonzanso ndondomeko ya zipilala zomwe zatsala kumanja

Chifukwa chimodzi chosankhira pamzere ndikulumikizana ndi dongosolo la mzere pakati pa matebulo osiyanasiyana a deta. Ndi ndondomeko yomwe ili kumanzere komweko, ndikusavuta kuyerekezera zolemba kapena kusindikiza ndi kusuntha deta pakati pa matebulo.

Kukonzekera Phukusi Lamulo

Kawirikawiri, komabe, kupeza ndondomeko yoyenera ntchito yoyenerera chifukwa cha kuchepa kwazomwe zikukwera komanso kutsika njira zosankha zoyenera.

Kawirikawiri, m'pofunika kugwiritsa ntchito mtundu wamtundu wamtundu, ndipo Excel ikuphatikizapo njira zomwe mungasankhire ndi selo kapena mtundu wa fosholo kapena zizindikiro zosinthika .

Zosankha izi, monga tafotokozera m'munsi mwa tsamba lino, zidakali kugwira ntchito mwamphamvu ndipo sizili zophweka kuzigwiritsa ntchito.

Mwinanso njira yosavuta yofotokozera Excel ndondomeko ya ndondomeko ndiyo kuwonjezera mzere pamwamba kapena pansi pa tebulo ladeta lomwe lili ndi manambala 1, 2, 3, 4 ... omwe amasonyeza dongosolo lazitsulo kuyambira kumanzere.

Kusankha ndi mizere ndiye kumakhala nkhani yosavuta yosankha mizati yaing'ono mpaka yaikulu mwa mzere uli ndi manambala.

Kamodzi katha, mayina owonjezeredwa akhoza kuchotsedwa mosavuta .

Sankhani ndi Mizere Chitsanzo

Mu chitsanzo cha deta chimene chikugwiritsidwa ntchito pazotsatirazi pazochita zosankha za Excel, ndondomeko ya ID ya Ophunzira nthawizonse yakhala yoyamba kumanzere, ikutsatiridwa ndi Dzina ndiyeno nthawi Zaka .

Pachifukwa ichi, monga momwe tawonetsera pa chithunzi pamwambapa, zipilala zasinthidwa kotero kuti Pulogalamu ya Pulogalamuyo ikhale kumanzere kumtsata pambuyo pa Mwezi Woyamba , Dzina, ndi zina.

Zotsatira zotsatirazi zinagwiritsidwa ntchito kusintha ndondomeko ya mzere kwa zomwe zikuwonetsedwa mu chithunzi pamwambapa:

1. Ikani mzere wopanda kanthu pamwamba pa mzere umene uli ndi mayina akumunda
2. Mu mzere watsopanowu, lowetsani nambala zotsatirazi zatsalira kuyambira pomwe ndikuyamba
   ndime H: 5, 3, 4, 1, 2
3. Onetsetsani mtundu wa H2 kufika pa L13
4. Dinani pa tabu la Home la riboni .
5. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule tsambali.
6. Dinani pa Custom Custom mundandanda wotsika pansi kuti mulembe mtundu wa dialog box
7. Pamwamba pa bokosi la bokosi, dinani pa Options kuti mutsegule Zokambirana Zokambirana
8. Mu gawo lakumayambiriro la bokosi lachiwiri lachidule, dinani Pangani kumanzere kumanja kuti muyese ndondomeko ya zipilala zomwe zatsala kumanja.
9. Dinani OK kuti mutsegule bokosili
10. Ndikusintha kwa Kumayambiriro, Phukusi likulowetsa m'ndandanda wa bokosi la mtunduwo
11. Pansi pa mutu wa Row , sankhani kusankha ndi Row 2 - mzere uli ndi manambala ozoloŵera
12. Mtundu Wosankha uli wosankhidwa ku Malemba
13. Pansi pa Mndandanda wa Order Order , sankhani Zing'onozing'ono Kuposa zonse kuchokera mundandanda wotsika pansi kuti muyese manambala mu mzere 2 wokwera
14. Dinani OK kuti mutseke bokosi la bokosi ndikusintha mizere kuchokera kumanzere kupita kumanja ndi manambala mzere 2
15. Lamulo la zikhomo liyenera kuyamba ndi Pulogalamu yotsatira Mwezi Woyambira , Dzina , ndi zina.

Kugwiritsira ntchito Excel Custom Custom Options kuti Pangani Ma Columns

Monga tafotokozera pamwambapa, pamene mwambo wamakono ulipo mu Mndandanda wa Mafotokozedwe a Excel mu Excel, zosankhazi sizili zovuta kuzigwiritsa ntchito polemba ndondomekoyi pa tsamba.

Zosankha pa kukhazikitsa dongosolo la mtundu wamtundu womwe ulipo m'ndandanda wa bokosi la mtundu ndikulongosola deta ndi:

• mtundu wa selo
• mtundu wa fonti
• chithunzi

Ndipo, pokhapokha ngati chigawo chilichonse chili ndi mawonekedwe osiyana-siyana - monga ma teti osiyana kapena mitundu ya maselo, maonekedwewo amafunika kuwonjezedwa ku maselo omwe ali mumzere womwewo kuti mzere uliwonse ukhazikitsidwe.

Mwachitsanzo, kugwiritsira ntchito mtundu wa fosholo kuti ukonzeretseranso zipilala mu chithunzi pamwambapa

1. Dinani pa dzina lililonse la munda ndikusintha mtundu wa mtundu uliwonse - monga wofiira, wobiriwira, wabuluu, ndi zina zotero.
2. Mu Mndandanda wa bokosi la mtundu, sankhani mtundu umene mungasankhe kuti muwoneke
3. Mu Order, mwasankha kukhazikitsa mayina a mayina amtunda mitundu kuti agwirizane ndi malemba omwe akufuna
4. Pambuyo posankha, yongolani mtundu wa foni pa dzina lililonse