Mmene Mungapangire Kutsika Mndandanda mu Excel

Zosankha za deta za Excel zimaphatikizapo kukhazikitsa mndandanda wotsika pansi womwe umalepheretsa deta yomwe ingalowerere mu selo yeniyeni kuti ayambe kulembetsa mndandanda wa zolembazo.

Pamene mndandanda wotsika pansi ukuwonjezedwa ku selo, muvi umasonyezedwa pafupi nawo. Kusindikiza pavivi kudzatsegula mndandanda ndikukulolani kusankha chimodzi mwa mndandanda wa zinthu kuti mulowe mu selo.

Deta imene ikugwiritsidwa ntchito mundandanda ingapezeke:

• pa tsamba lomwelo monga mndandanda
• pa tsamba limodzi lolembedwa m'buku lomwelo
• mu bukhu losiyana

Maphunziro: Kugwiritsira ntchito Deta yosungidwa m'buku losiyana

Mu phunziro ili, tidzakhala ndi mndandanda wotsika pansi pogwiritsa ntchito mndandanda wa zolembedwamo zomwe zili m'buku lina.

Ubwino wogwiritsira ntchito mndandanda wa zolembedwera zomwe zili m'buku lina ndikuphatikizira mndandanda wa deta ngati akugwiritsidwa ntchito ndi ogwiritsa ntchito ambiri komanso kuteteza deta kuchoka mwangozi kapena mwachangu kusintha.

Zindikirani: Pamene ndondomeko ya deta ikusungidwa mu bukhu lopatulika lokha mabuku onse ogwira ntchito ayenera kukhala omasuka kuti mndandanda ukhale wogwira ntchito.

Kutsatira ndondomeko m'mitu yophunzitsira pansipa ikukuyendetsani kupanga, kugwiritsa ntchito, ndi kusintha ndondomeko yosiyidwa yofanana ndi yomwe ikuwonetsedwa pa chithunzi pamwambapa.

Maphunziro awa, komabe, samaphatikizapo mapangidwe a mapepala.

Izi sizidzasokoneza kukwaniritsa maphunziro. Tsamba lanu la ntchito lidzawoneka mosiyana ndi chitsanzo pa tsamba 1, koma mndandanda wotsika udzakupatsani zotsatira zomwezo.

Mitu Yophunzitsa

• Kutsegula Mafayilo ndi Kusunga Deta Zophunzitsa
• Kupanga Mapangidwe Awiri
• Kutsegula Bokosi la Mauthenga Ovomerezeka la Data
• Kulowa Mndandanda wa Deta ndikukwaniritsa Chotsitsa Pansi
• Kusintha Zolemba Zamndandanda
• Zosankha Zotetezera Kutsika kwa Mndandanda

01 ya 06

Kulowa Datorial Data

Kutsegula Mabuku Awiri Othandiza Ogwira Ntchito

Monga tanenera, pa phunziro ili deta ya ndondomeko yosiyidwa idzapezeka mu bukhu losiyana lochokera ku ndondomeko yosikira.

Phunziro ili likutsatira izi:

1. Tsegulani mabuku awiri ogwira ntchito osalongosoka
2. Sungani buku limodzi lolembedwa ndi deta-source.xlsx - bukuli likhale ndi deta ya ndondomeko yotsika pansi
3. Sungani bukhu lachiwiri ndi dzina lochepetsa-list.xlsx - bukuli likhale ndi mndandanda wazitsitsa
4. Siyani mabuku awiri ogwiritsira ntchito atatsegula.

Kulowa Datorial Data

1. Lowani deta ili m'munsiyi mu maselo A1 mpaka A4 a buku la data-source.xlsx monga momwe mukuwonera pa chithunzi pamwambapa.
2. A1 - Gingerbread A2 - Lemon A3 - Oatmeal A4 - Chokoleti Chip
3. Sungani bukhuli ndipo lizisiya
4. Lowetsani deta ili m'munsiyi mu maselo B1 a buku la drop-down-list.xlsx .
5. B1 - Mtundu wa Cookie:
6. Sungani bukhuli ndipo lizisiya
7. Mndandanda wotsikawu udzawonjezedwa ku selo C1 m'bukuli

02 a 06

Kupanga Mapangidwe Awiri

Kupanga Mapangidwe Awiri

Mtundu wotchulidwa umatchulidwa kuti uwonetsere maselo enaake mu bukhu la ntchito ya Excel.

Mipata yodziwika imakhala ndi ntchito zambiri ku Excel kuphatikizapo kuzigwiritsa ntchito muzithunzi komanso popanga ma chart.

Nthawi zonse, malo otchulidwapo amagwiritsidwa ntchito mmalo mwa mafotokozedwe angapo a selo omwe amasonyeza malo a deta muzenera.

Pogwiritsidwa ntchito pamndandanda wotsika m'mabuku osiyana, mayina awiri otchulidwawo ayenera kugwiritsidwa ntchito.

• Chimodzi chimapangidwira pazinthu zomwe zili mu bukhu la ntchito kumene deta ili
• Yachiwiri imalengedwa mu bukhu la ntchito komwe mndandanda wazitsulo ulipo. Lachiwirili limatanthawuza zofanana ndi zomwe zatchulidwa m'buku loyamba

Maphunziro Otsogolera

Njira Yoyamba Yotchulidwa

1. Sankhani maselo A1 - A4 a buku la data-source.xlsx kuti awoneke
2. Dinani pa Bokosi la Dzina lomwe lili pamwamba pa ndime A
3. Lembani "Cookies" (palibe ndemanga) mu Box Name
4. Onetsetsani ENTER yowonjezera pa kambokosi
5. Maselo A1 ku A4 a buku la data-source.xlsx tsopano ali ndi dzina la ma Cookies
6. Sungani bukuli

Njira Yachiwiri Yotchulidwa

Wachiwiri wotchedwa range sagwiritsira ntchito maofesi ang'onoang'ono kuchokera m'buku la drop-down-list.xlsx .

M'malo mwake, izo, monga tanenera, zimagwirizanitsa ndi dzina la Cookies mu buku la data-source.xlsx .

Izi ndizofunika chifukwa Excel silingalandire maumboni a selo kuchokera ku bukhu losiyana la dzina lotchulidwa. Zidzakhala, koma, kupatula dzina linalake.

Kupanga chachiwiri chotchulidwa, choncho, sikumagwiritsidwa ntchito pogwiritsa ntchito Dzina la Bokosi koma pogwiritsira ntchito Dzina la Mayina a Zina lomwe lili pazithunzi zabuboni .

1. Dinani pa selo C1 mu buku la drop-down-list.xlsx
2. Dinani pa Mafomu> Oyang'anira Maina pa Riboni kuti mutsegule Bokosi la Mauthenga a Name Name
3. Dinani pa batani Yatsopano kuti mutsegule Bokosi Latsopano la Maina
4. Mu Dzina la Mzere: Deta
5. Mulozera mtundu wa mzere: = 'data-source.xlsx'! Cookies
6. Dinani OK kuti mutsirizitse dzina lotchulidwa ndi kubwerera ku bokosi la dialog Manager
7. Dinani Kutseka kuti mutseke bokosi la dialog Manager
8. Sungani bukuli

03 a 06

Kutsegula Bokosi la Mauthenga Ovomerezeka la Data

Kutsegula Bokosi la Mauthenga Ovomerezeka la Data

Zosankha zonse zokhudzana ndi deta mu Excel, kuphatikizapo ndondomeko zochepa, zimayikidwa pogwiritsa ntchito deta yolumikizira bokosi.

Kuonjezera kuwonjezera mndandanda wa mapepala pa tsamba, kufotokoza deta ku Excel kungagwiritsidwe ntchito poletsa kapena kuchepetsa mtundu wa deta yomwe ingalowerere m'maselo ena pa tsamba.

Maphunziro Otsogolera

1. Dinani pa selo C1 la buku la drop-down-list.xlsx kuti likhale selo yogwira ntchito - apa ndi pamene mndandanda wotsika udzapezeka
2. Dinani pa tsamba la Data la menyu yowonjezera pamwamba pa tsamba
3. Dinani pa Chithunzi cha Validation Cha Data paboni kuti mutsegule menyu otsika
4. Dinani pa Chitsimikizo cha Deta la Chidziwitso mu menyu kuti mutsegule Chidziwitso cha Validation Data
5. Chokani ku bokosi lamasamba kutsegulira gawo lotsatira mu phunziroli

04 ya 06

Kugwiritsa Ntchito Mndandanda wa Kuvomerezeka kwa Data

Kusankha Mndandanda wa Kuvomerezeka kwa Data

Monga tafotokozera pali njira zingapo zowonjezeretsa deta ku Excel kuphatikizapo mndandanda wazitsulo.

Mu sitepe iyi tidzasankha njira ya Mndandanda ngati mtundu wa deta wotsimikiziridwa kuti uzigwiritsidwa ntchito pa selo D1 pa tsambali.

Maphunziro Otsogolera

1. Dinani pa Zikhazikiko tabu mu bokosi la bokosi
2. Dinani pamsana wotsika kumapeto kwa Allow Lumikila kuti mutsegule menyu
3. Dinani pa Mndandanda kuti musankhe mndandanda wotsika pansi pa deta yolumikizidwa mu selo C1 ndi kuwonetsa Gwero la Chitsime mu bokosi la bokosi

Kulowa Mndandanda wa Deta ndikukwaniritsa Chotsitsa Pansi

Popeza chidziwitso cha deta chikupezeka pa bukhu lopatulika, lachiwiri lotchulidwa lija lopangidwa kale lidzalowetsedwa mu Gwero la Chitsime mu bokosi la bokosi.

Maphunziro Otsogolera

1. Dinani pa Chitsime mzere
2. Lembani "= Deta" (palibe ndemanga) mu Gwero la Chitsime
3. Dinani OK kuti mutsirize mndandanda wotsika pansi ndi kutseka bokosi lachidziwitso cha Data
4. Chithunzi chaching'ono chakutsitsa chakuzungulira chakumanja kwa selo C1
5. Pogwiritsa ntchito chingwe chotsitsa chiyenera kutsegula mndandanda wotsika pansi womwe uli ndi mayina anayi a coko omwe analowa mu maselo A1 mpaka A4 a buku la data-source.xlsx
6. Kusindikiza pa mayina amodzi muyenera kulowa mu dzina la C1

05 ya 06

Kusintha Zolemba Zolemba

Kusintha Zolemba Zamndandanda

Kuti tilembetse mndandanda wazinthu zomwe zikuchitika pakadali pano, zingakhale zofunikira kusintha nthawi zonse zosankha.

Popeza tinagwiritsa ntchito dzina lotchulidwa kuti ndilo gwero la mndandanda wazinthu zathu m'malo molemba mayina, kusintha maina a cookie mumatchulidwe ake omwe ali m'maselo A1 mpaka A4 a buku la data-source.xlsx nthawi yomweyo amasintha mayina akutsikira mndandanda.

Ngati deta likulowetsani mwachindunji ku bokosi, kukonzanso pa mndandanda kumaphatikizapo kubwereranso ku bokosi la bokosi ndikusinthira mndandanda.

Mu sitepe iyi tidzasintha Lemon ndi Shortbread m'ndandanda wotsika mwa kusintha deta mu selo A2 la dzina lake lotchulidwa m'buku la data-source.xlsx .

Maphunziro Otsogolera

1. Dinani pa selo A2 mu buku la data-source.xlsx (Lemon) kuti likhale selo yogwira ntchito
2. Lembani chofufuzira Chaching'ono mu selo A2 ndikusindikizira fungulo lolowamo mukhiyi
3. Dinani pamsana wotsika kuti mndandanda wotsika mu selo C1 ya bukhu lotsika-list-list.xlsx kuti mutsegule mndandanda
4. Chinthu chachiwiri mu mndandanda ayenera kuwerengeka Pang'ono pomwe m'malo mwa mandimu

06 ya 06

Zosankha Zotetezera Kutsika kwa Mndandanda

Zosankha Zotetezera Kutsika kwa Mndandanda

Popeza deta yathu ili pa tsamba lina lochokera kuzinthu zochepa zomwe zilipo poteteza mndandanda wazinthu zikuphatikizapo:

• Tetezani pepala lomwe limatsegula maselo A1 mpaka A4 pa pepala 2
• Kufuna chinsinsi kuti musinthe bukuli
• Kukhala ndi bukhu lotseguka lotseguka ngati Kuwerenga-kokha