Mmene Mungapangire ndi Kupanga Tchati Chakujambula mu Excel 2010

01 ya 06

Zomwe Mungapange Tchati Cholembera ku Excel 2010

Masitepe opanga tchati chofunikira chachitsulo mu Excel 2010 ndi awa:

1. Onetsani deta kuti muphatikizidwe - phatikizani mzere ndi mitu ya mutu koma osati mutu wa tebulo la deta;
2. Dinani ku Insert tab ya riboni ;
3. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Tchati cha Tchati Chotsitsa kuti mutsegule mndandanda wa mitundu yomwe ilipo.
4. Sungani pepala lanu la mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati;
5. Dinani pa tchati chofunikila;

Tchati chodziwika, chosadziwika-chomwe chimangosonyeza deta yosankhidwa, nthano, ndi nkhwangwa zowonjezera - zidzawonjezedwa pa tsamba lamasamba .

Kusiyana kwa Mabaibulo mu Excel

Maphunziro a phunziroli amagwiritsira ntchito machitidwe omwe akukonzekera ndi machitidwe omwe alipo mu Excel 2010 ndi 2007. Izi zimasiyana ndi zomwe zapezeka pamayambiriro ndi pulogalamuyi. Gwiritsani ntchito maulumikizi otsatirawa pamaphunziro a tchati chazithunzi za ma Excel ena.

• Excel 2013 Tchati Chotsatira Chakutsogolera
• Excel 2003 (ndi Mabaibulo oyambirira) Tchati Chachidule Chakuphunzitsani

Chidziwitso pa mutu wa Excel Colors

Excel, monga mapulogalamu onse a Microsoft Office, amagwiritsa ntchito malemba kuti ayang'ane mawonekedwe ake.

Mutu umene umagwiritsidwa ntchito pa phunziro ili ndi mutu wosasinthika wa Office .

Ngati mutagwiritsa ntchito mutu wina pamene mukutsatira phunziroli, mitundu yomwe ili muzochitikazi sizingapezeke pa mutu womwe mukugwiritsa ntchito. Ngati ndi choncho, ingosankhirani mitundu yomwe mumakonda monga m'malo ndi kupitiriza.

• Momwe mungasinthire ndikusintha mutu wa buku lino

02 a 06

Kukhazikitsa Tchati Chachikulu Chachitsulo mu Excel

Kulowa ndi Kusankha Deta Yophunzitsa

Zindikirani: Ngati mulibe deta yomwe ili pafupi kuti mugwiritse ntchito ndi phunziroli, ndondomeko za phunziroli zimagwiritsa ntchito deta yosonyezedwa pa chithunzi pamwambapa.

Njira yoyamba yopanga tchati nthawi zonse imalowa mndandanda wa deta - ziribe kanthu mtundu wa tchati umene ukupangidwa.

Khwerero yachiwiri ndikuwonetsa deta yomwe ingagwiritsidwe ntchito popanga tchati.

Posankha deta, mndandanda ndi mitu ya mndandanda ikuphatikizidwa muchisankho, koma mutu womwe uli pamwamba pa tebulo la deta siili. Mutuwo uyenera kuwonjezeredwa pa tchati pamanja.

1. Lowetsani deta yosonyezedwa mu chithunzi pamwamba pa maselo ofiira a masamba
2. Mukalowa, onetsetsani maselo osiyanasiyana kuchokera ku A2 mpaka D5 - ili ndilo deta yomwe idzaimiridwe ndi tchati chachindunji

Kupanga Tchati Choyambira Chachidule

1. Dinani pa Insert tab ya riboni
2. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Tchati cha Tchati Chotsitsa kuti mutsegule mndandanda wotsika wa mitundu ya tchati yomwe ilipo
3. Sungani chojambula chanu cha mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati
4. Mu gawo la 3-D Lumikizanani Padzakhala mndandanda, dinani pa Zowonjezeredwa Pakhoma - kuwonjezera tchati loyambira pa tsamba

03 a 06

Excel Chart Parts ndi kuchotsa Gridlines

Kulimbana ndi Gawo Lolakwika la Tchati

Pali zigawo zambiri pa tchati mu Excel - monga malo amalo omwe ali ndi tchati chachindunji chomwe chikuimira mndandanda wa data , nthano, ndi mutu wa tchati.

Zonsezi zimaonedwa ngati zosiyana ndi pulogalamuyo, ndipo, motere, aliyense akhoza kupangidwa mosiyana. Mumauza Excel chomwe chili gawo la tchati yomwe mukufuna kuimanga mwa kuyika pa iyo ndi ndondomeko ya mouse.

Muzotsatira izi, ngati zotsatira zanu sizifanana ndi zomwe zalembedwa mu phunziroli, ndizotheka kuti mulibe gawo loyenera la tchati yomwe mwasankha pamene mwasankha machitidwe omwe mumasankha.

Kulakwitsa kofala kwambiri ndikudutsa chigawo cha chiwembu pakati pa ngoloyo pamene cholinga chake ndi kusankha tchati chonse.

Njira yosavuta yosankhira tchati chonse ndikukweza pamwamba kumanzere kapena kumanzere kumbali ya mutu wa tchati.

Ngati kulakwitsa kwapangidwa, kungakonzedwe mwamsanga pogwiritsa ntchito chithunzi cha Excel kukonza cholakwika. Pambuyo pake, dinani mbali yoyenera ya tchati ndikuyesanso.

Kuchotsa Gridlines kuchokera ku Plot Area

Mzere woyamba wa galasi umaphatikizapo ma gridlines omwe amayendayenda kumalo amodzi kuti apange mosavuta kuwerenga mfundo za deta - makamaka m'matata okhala ndi deta zambiri.

Popeza pali zigawo zitatu zokha zomwe zili mu tchatichi, mfundo za data ndi zovuta kuziwerenga, kotero magalasi akhoza kuthetsedwa.

1. M'chojambulacho, dinani kamodzi pa $ 60,000 gridline ikuyenda pakati pa graph kuti iwonetsere zonse zamagetsi - mabulu ang'onoang'ono a buluu ayenera kuwonedwa kumapeto kwa gulu lililonse
2. Thandizani Chotsani Chotsani pa khibhodi kuchotsa magalasi

Pano, tchati yanu iyenera kufanana ndi chitsanzo chomwe chikuwonetsedwa pamwambapa.

04 ya 06

Kusintha Malemba a Tchati

Makanema a Chart Tools

Pamene tchati imapangidwa ku Excel 2007 kapena 2010, kapena pamene chithunzi chiripo chikusankhidwa pogwiritsa ntchito, ma tebulo atatu akuwonjezeredwa ku riboni monga momwe tawonetsera pa chithunzi pamwambapa.

Ma tebulo a Chart Tools - Kukonzekera, Kuyika, ndi Maonekedwe - ali ndi mawonekedwe a maonekedwe ndi makonzedwe makamaka ma chart, ndipo adzagwiritsidwa ntchito potsatira njira zowonjezera mutu ku tchati chachindunji ndikusintha mitundu ya tchati.

Kuwonjezera ndi Kusintha Mutu wa Chati

Mu Excel 2007 ndi 2010, masatidwe ofunika samaphatikizapo maudindo a tchati. Izi ziyenera kuwonjezedwa mosiyana pogwiritsa ntchito Chinthu Chachidule Chakupezeka pa tab Layout ndikukonzekera kuti muwonetse mutu womwe mukufuna.

1. Dinani kamodzi pa tchati kuti muzisankhe izo, ngati kuli koyenera, kuwonjezera ma tabu a zida za tchati ku riboni
2. Dinani pa Tsambali layout
3. Dinani pa Tsatanetsatane wa Chithunzi Chachidule kuti mutsegule mndandanda wa zosankha
4. Sankhani Chithunzi Cham'mwamba kuchokera pa mndandanda kuti muike bokosi lachikholo lachithunzi losasinthika pa tchati pamwamba pazitsulo za deta
5. Dinani kamodzi mu bokosi la mutu kuti mukonzeko phunziro losasinthika
6. Chotsani malemba osasinthika ndikulowa mutu wa tchati - Bukhu la Cookie 2013 Summary Summary - mu bokosi la mutu
7. Ikani chithunzithunzi pakati pa Shop ndi 2013 mu mutu ndikusindikizira Fungulo lolowamo pa khididiyi kuti mulekanitse mutu pa mizere iwiri

Kusintha mtundu wa mtundu

Kusintha mtundu wamasewero womwe umagwiritsidwa ntchito mosasinthika pazolembedwa zonse mu tchati sikungowonjezera maonekedwe a tchati, koma zidzakhalanso zosavuta kuwerengera nthano ndi nkhonya mayina ndi zoyenera.

Kusintha kumeneku kudzapangidwa pogwiritsa ntchito njira zomwe zili muzithunzi zamtundu wa Tsamba la Home la Ribbon.

Zindikirani : Kukula kwa foni kumayikidwa pa mfundo - kawirikawiri kumachepetsedwa ku pt.
72 pt. malemba ndi ofanana ndi inchi - 2.5 cm - kukula.

Kusintha Tanthauzo la Tsati

1. Dinani kamodzi pa mutu wa tchati kuti muisankhe
2. Dinani pa tabu la Home la riboni
3. Mu gawo la foni la riboni, dinani pa Bokosi la Masamba kuti mutsegule tsambali la zilembo zomwe zilipo
4. Pemphani kuti mupeze ndikusindikiza pazithunzi Arial Black mu mndandanda kuti musinthe mutu wa ma foni awa

Kusintha Nthano ndi Ndondomeko Text

1. Bwerezaninso masitepewa kuti musinthe zomwe zili mu tchatichi ndi X ndi Y axes ku Arial Black

05 ya 06

Mitundu Yosintha mu Tchati Cholembera

Kusintha Mtundu wa Pansi ndi Khoma lakumbali

Zotsatirazi mu phunziroli zimaphatikizapo kusintha mtundu wa pansi pa tchati ndi khoma kumbali kwa wakuda monga momwe tawonera pa chithunzi pamwambapa.

• Mzere wamatabwa pansi ndi mzere wozungulira womwe uli pansi pa zigawo za deta m'deralo.
• Khoma lambali lili kumbali ya kumanzere kwa chiwembu pakati pa ndondomeko zam'ndandanda ndi malemba ozungulira a Y (otsika).

Zinthu zonse ziwiri zidzasankhidwa pogwiritsa ntchito mndandanda wa ndondomeko yotsika pansi yomwe ili kumbali yakumanzere ya tab ya Layout ya Ribbon.

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonse ngati kuli kofunikira
2. Dinani pa Tsatanetsatane tab ya riboni
3. Ndi ndondomeko yonse yomwe yasankhidwa, ndondomekoyi ikuyimira dzina la Tchati pamwamba pa ngodya ya pamwamba.
4. Dinani pansi pavivi pansi pazithunzi zazomwe mungachite kuti mutsegule mndandanda wa magawo a tchati
5. Sankhani Pansi pa mndandanda wa mapepala kuti muwonetse pansi pa tchati
6. Dinani pa Tsambidwe la Mtambo wa Riboni
7. Dinani pa Fomu Yodzazani njira kuti mutsegule Zojambula Zotsitsa pansi
8. Sankhani Chida, Ndemanga 1 kuchokera ku gawo la Masewera a Mutu wa gululo kuti musinthe mtundu wa tchati kuti mukhale wakuda
9. Bweretsani masitepe 2 mpaka 6 pamwamba kuti musinthe mtundu wa tchati cha Pafupi ndi Wall kwa wakuda

Ngati mwatsatira mapazi onse mu phunziroli, pakadali pano, chithunzi chanu chiyenera kufanana ndi chomwe chikuwonetsedwa pa chithunzi pamwambapa.

06 ya 06

Kusintha Kokosi Kumatuluka ndi Kusuntha Tchati

Kusintha Mtundu wa Zojambula Zamatoto a Chart

Gawo ili mu phunziro limasintha maonekedwe a mazenera a deta powasintha mitundu, kuwonjezera malemba, ndi kuwonjezera ndondomeko pamndandanda uliwonse.

Chithunzicho chimadza ndi kupanga mawonekedwe a ndondomeko , yomwe ili pa Tabu yafomu idzagwiritsidwa ntchito kusintha ma kusintha. Zotsatira zidzafanana ndizomwe zikuwonetsedwa mu chithunzi pamwambapa.

Kusintha Mitundu Yonse ya Misonkho

1. Dinani kamodzi pa imodzi ya nsalu zam'mbali Zonse za mapepala mu tchati kuti musankhe mitundu yonse itatu ya buluu
2. Dinani pa tabu ya foni ya riboni ngati kuli kofunikira
3. Dinani pa Fomu Yodzazani njira kuti mutsegule Zojambula Zotsitsa pansi
4. Sankhani Mdima Wofiirira, Wachiwiri 2, Wowonjezera 60% kuchokera ku gawo la Masewera a Mutu wa gululo kuti musinthe mtundu wazitsulo kuti ukhale wobiriwira

Kuwonjezera pa Gradient

1. Ndizitsulo Zonse za Misonkho adakali osankhidwa, dinani pazomwe Fulani Yodzaza njira yachiwiri kuti mutsegule Menyu yotsitsa
2. Sungani pointer ya mouse pamasankhidwe a Gradient pafupi ndi pansi pa mndandanda kuti mutsegule gulu lalikulu
3. Mu gawo la Kusintha kwa Kuunika kwa gawolo, dinani pa Linear Right option kuti muwonjezere chigawo chomwe chimakhala chowala kuchokera kumanzere kupita kumanja

Kuwonjezera Mndandanda wa Column

1. Ndizitsulo Zonse za Misonkho zidakalipo, dinani pazomwe Mukusankha Zolembazo kuti mutsegule Zolemba Zowonongeka Zapangidwe
2. Mu gawo labwino la zojambula za gululo, sankhani Mdima Wakuda kuti uwonjezere ndondomeko yakuda ya buluu ku chigawo chilichonse
3. Dinani pa Tsambali Yopangidwira njira yachiwiri
4. Dinani pa Kulemera kwazomwe mungasankhe pa menyu kuti mutsegule zosankha zazing'ono
5. Sankhani 1 1/2 pt. kuwonjezera makulidwe a ndondomeko zazitsulo

Kukonza Mapulogalamu Onse Otsalira

Bwerezaninso njira zomwe zimagwiritsidwa ntchito popanga mizere yonse ya msonkho , pogwiritsa ntchito mafomu awa:

• Mzere Wodzaza Mtundu: Chiguduli Chofiira 2, Chimdima 50%
• Zovuta: Kuunika Kwakuya , Kuli Kumanja
• Column Outline Colour: Red Accent 2, Mdima Wochepa 50%
• Mzere Wochokera Kumtundu Wolemera: 1 1/2 pt.

Kupanga Ma Pulogalamu Yopindulitsa / Kutaya

Bwerezaninso njira zomwe zimagwiritsidwa ntchito popanga mizere yonse ya msonkho , pogwiritsa ntchito mafomu awa:

• Pulogalamu Yodzaza Mtundu: Mafuta a Green Olives 3, Mdima 25%
• Zovuta: Kuunika Kwakuya , Kuli Kumanja
• Column Outline Mtundu: Olive Green Accent 3, Mdima Wochepa 50%
• Mzere Wochokera Kumtundu Wolemera: 1 1/2 pt.

Panthawiyi, ngati ndondomeko zonse zowonongeka zatsatidwa, tchati chachindunji chiyenera kufanana ndi chithunzi chomwe chili pa chithunzi pamwambapa.

Kusuntha Tchati pa Tsamba Losiyana

Gawo lomaliza la phunziroli limasintha tchaticho ku pepala lapadera mu bukhu lophunzitsira pogwiritsa ntchito bokosi lachikale la Chart.

Kusuntha tchati ku pepala lokha kumapangitsa kuti kusindikiza tchati kukhale kosavuta komanso kungathetsere kusokonezeka mu tsamba lalikulu lomwe liri ndi deta.

1. Dinani kumbuyo kwa tchati kuti musankhe tchati chonsecho
2. Dinani pa tabu Yopanga ya kasoni
3. Dinani pa chithunzi cha Tchati Chotsatira kumbali yakumanja ya riboni kuti mutsegule Bokosi la Chithunzi Chakutsitsa
4. Monga momwe tawonera pa chithunzi pamwambapa, dinani pa Tsamba lachidindo latsopano muzokambirana ndipo - mwachangu - perekani pepala dzina, monga Cookie Shop 2013 Summary Summary
5. Dinani OK kuti mutseke bokosilo - chojambulacho chiyenera kupezeka pa pepala lapadera ndi dzina latsopano lomwe likuwoneka pa pepala lazithunzi pansi pazenera.