Pangani Pansi Pansi Lembali mu Excel Kuchokera Patsamba Lina

Kupanga mndandanda wochepa pansi pa Excel umakulowetsani kuti mulowetse deta mu selo yeniyeni la zolemba kuchokera ku ndandanda yazowonjezera.

Phindu logwiritsira ntchito ndondomeko yotsika pansi ndilo:

• Kulowetsa deta mosavuta
• Kupewa zolakwika zolowera deta
• Kulepheretsa chiwerengero cha malo polowera deta

Mndandanda wa Zolemba Zowonongeka Phunziro Pang'onopang'ono Mitu Yophunzira

• Kulowa Datorial Data
• Kupanga Njira Yodziwika kwa Deta
• Kuyambira Pulogalamu Yotsitsa
• Kugwiritsa Ntchito Mndandanda wa Kuvomerezeka kwa Data
• Kulowa Mndandanda wa Data ndi Kumaliza Tsamba Lotsitsa
• Kusintha Zolemba Zamndandanda
• Zosankha Zotetezera Kutsika kwa Mndandanda

Kulowa Datorial Data

Chinthu choyamba pakupanga mndandanda wotsika mu Excel ndikolowetsa deta .

Zindikirani: Mauthenga a maphunziro saphatikizapo kukonza mapepala a tsamba.

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

Lowani deta ili m'munsiyi mu maselo omwe amasonyezedwa pamapepala limodzi ndi awiri a buku la Excel.

Maphunziro Otsogolera

1. Lowetsani ma data otsatirawa m'maselo olondola pa Tsamba 1 la tsamba: D1 - Mtundu wa Cookie:
2. Dinani patsamba la Tsamba la Mapepala 2.
   
3. Lowetsani deta zotsatirazi mu maselo olondola pa Tsamba 2 pa tsamba:
   A1 - Gingerbread A2 - Lemon A3 - Oatmeal A4 - Chokoleti Chip

Mndandanda wotsika pansi udzawonjezedwa ku selo E1 pa pepala 1.

Kupanga Zina Zogwiritsidwa Ntchito pa Zina Za Dongosolo

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 mundandanda wotsika, dzina lotchulidwa limagwiritsidwa ntchito ngati gwero la zinthu zolemba.

Maphunziro Otsogolera

1. Kokani osankha maselo A1 - A4 pa Tsamba 2.
2. Dinani pa Bokosi la Dzina lomwe lili pamwamba pa ndime A
3. Lembani "ma cookies" (palibe ndemanga) mu Box Name
4. Onetsetsani ENTER yowonjezera pa kambokosi
5. Maselo A1 kufika ku A4 pa pepala 2 tsopano ali ndi dzina loti "ma cookies"
6. Sungani tsamba lanu la ntchito

Kutsegula Bokosi la Mauthenga Ovomerezeka la Data

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

Bokosi lachidziwitso la chidziwitso cha deta liri pansi pa tebulo la deta .

Maphunziro Otsogolera

1. Dinani pa Tsamba 1 tabu pansi pa chinsalu kuti musinthe tsamba 1
2. Dinani pa selo E1 kuti mupange selo yogwira ntchito - apa ndi pamene mndandanda wotsika udzapezeka
3. Dinani pa tsamba la Data la menyu yowonjezera pamwamba pa tsamba
4. Dinani pa Chithunzi cha Validation Cha Data paboni kuti mutsegule menyu otsika
5. Dinani pa Chitsimikizo cha Deta la Chidziwitso mu menyu kuti mutsegule Chidziwitso cha Validation Data

Kugwiritsa Ntchito Mndandanda wa Kuvomerezeka kwa Data

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

Zina mwazogwiritsa ntchito kwambiri:

• Lembani
• Nthawi ndi / kapena nthawi
• Nambala zonse
• Malemba
• Mafomu (pansi pa Chinthu chadongosolo)

Pa sitepe iyi, tidzasankha njirayiyi monga mtundu wa deta yolumikizidwa kuti ugwiritsidwe ntchito pa selo E1 pa pepala 1.

Zotsatira

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 kuti muwonetsetse deta mu selo D1 ndikuthandizani Gwero la Chitsime mu bokosi la bokosi

Kulowa Mndandanda wa Deta ndikukwaniritsa Chotsitsa Pansi

Popeza chitsimikizo cha deta pansi chili pa tsamba limodzi, maina omwe adatchulidwa kale adzalowedwera mu Chitsime chakuthandizira mu bokosi la bokosi .

Zotsatira

1. Dinani pa Chitsime mzere
2. Lembani "= cookies" (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 E1
5. Pogwiritsa ntchito chingwe chotsitsa chiyenera kutsegula mndandanda wotsika pansi womwe uli ndi mayina anayi a coko opangidwa mu maselo A1 mpaka A4 pa pepala 2
6. Dinani pa mayina amodzi muyenera kulowa mu dzina la E1

Kusintha Zinthu Zolemba

Kuti muthe kulembetsa mndandanda wazomwe mukusunga ndi deta yanu, zingakhale zofunikira kusintha nthawi zonse zosankha.

Popeza tinagwiritsa ntchito dzina lotchulidwa kuti ndilo gwero la mndandanda wamndandanda m'malo mndandanda wa mayina, kusintha maina a coko mumatchulidwe omwe ali m'maselo A1 mpaka A4 pa pepala 2 nthawi yomweyo amasintha maina mundandanda wotsika.

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

Mu sitepe iyi, tidzasintha Mphindi Yofikira ku Oatmeal Raisin mundandanda wotsika mwa kusintha deta mu selo A3 la dzina lake.

Zotsatira

1. Dinani pa selo A3 pa pepala 2 (Pang'ono pang'ono) kuti mupange selo yogwira ntchito
2. Lembani Oatmeal Chombo mu selo A3 ndipo yesani kulowera pakani pa kibokosi
3. Dinani pavivi pansi kuti mulembetse mndandanda wa E1 wa pepala 1 kuti mutsegule mndandanda
4. Gawo 3 mu mndandanda ayenera tsopano kuwerenga Oatmeal Raisin m'malo mwa Shortbread

Zosankha Zotetezera Kutsika kwa Mndandanda

Popeza kuti deta yathu ili pa tsamba limodzi lochokera pansi pazomwe mungapeze njira ziwiri zomwe zilipo poteteza mndandanda wa deta ndi:

• Bisani tsambali lomwe lili ndi deta (pepala 2)
• Tetezani pepala lomwe limatsegula maselo A1 mpaka A4 pa pepala 2

Ngati chitetezo sichingakhale chodetsa nkhaŵa, kubisala tsamba lomwe lili ndi mndandanda wa deta ndi njira yabwino chifukwa zimakhala zosavuta kusintha ndondomekoyi ngati pakufunika.

Ngati chitetezo chikukhudzidwa ndi mawu achinsinsi mungathe kuwonjezerapo pamene muteteze pepala lanu kuti muteteze kusintha kuzinthu zamndandanda.

Kupanga Pansi Powonjezera pa Zolemba Zosiyana Zolemba

Mndandanda wotsika pansi umakulowetsani kuti mulowetse deta mu Excel spreadsheet kuchokera pa mndandanda wa zolembazo.

Gawo 1 limaphatikizapo ndondomeko zowonjezera mndandanda wotsika pansi ndi deta pa pepala limodzimodzi monga ndondomeko yochepetsa.

Phunziroli likuphatikizapo kupanga mndandanda pansi pa tsamba.

Chitsanzo: Kupanga ndondomeko yochepetsa pansi ndi deta pa tsamba limodzi

Lowetsani ma data otsatirawa m'maselo olondola pa Tsamba 1 la tsamba:
E1 - Shopolo ya Cookie
D2 - Mtundu wa Cookie:
Dinani patsamba la Tsamba la Mapepala 2.
Lowetsani deta zotsatirazi mu maselo olondola pa Tsamba 2 kapena pepala lolemba:
A1 - Gingerbread
A2 - mandimu
A3 - Oatmeal Raisin
A4 - Chokoleti Chip
Onetsetsani maselo A1 - A4 pa Tsamba 2.
Lembani "ma cookies" (palibe ndemanga) mu Bokosi la Dzina ndipo pindani makiyi a Kulowa pa makiyi.
Dinani patsamba la Tsamba la Tsamba 1
Dinani pa selo E2 - malo omwe zotsatira zidzawonetsedwa
Dinani pa tsamba la Data
Dinani ku Chitsimikizo cha Data Kuchokera pa Riboni kuti mutsegule menyu
Dinani pa Kuvomerezeka kwa Data mu menyu kuti mubweretse bokosi la dialog
Dinani pa Zikhazikiko tabu mu bokosi la bokosi
Kuchokera Kulowetsa menyu kusankha Pulogalamu
Pezani = ma cookies pa Gwero la chitsime mu bokosi la bokosi
Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito
Mtsinje wotsika ukuyenera kuwoneka pafupi ndi selo E2
Mukasindikiza pavivi, mndandanda wotsikawu uyenera kutsegulidwa kuti uwonetse maina anayi akhuki