Indlela Yakha Ishadi Lamakholomu ku-Excel

01 ka-06

Indlela Yakha Ishadi Lamakholomu ku-Excel

Izinyathelo zokudala ishadi lamakholomu eyisisekelo ku-Excel yilokhu:

1. Qinisekisa idatha ukuthi ifakwe eshadini - faka izihloko zegqawu nekholomu kodwa hhayi isihloko setafula yedatha;
2. Chofoza ku- Faka ithebhu ye- ribbon ;
3. Ebhokisini Lamashadi webhebhoni, chofoza isithonjana seKhadi lekholomu lokufaka ukuze uvule uhlu lokudonsa phansi lwezinhlobo zeshadi ezitholakalayo;
4. Hambisa isikhombisi sakho semouse phezu kohlobo lwebhadi ukuze ufunde incazelo yeshadi;
5. Chofoza kugrafu oyifunayo;

Ishadi elicacile, elingashintshiwe - elibonisa kuphela amakholomu abamele uchungechunge lwemininingwane ekhethiwe, isihloko seshadi esizenzakalelayo, i-legend, kanye nama-value axxes - kuzongeniswa ephepheni lokusebenza lamanje.

Ukuhluka kohlobo ku-Excel

Izinyathelo kulesi sifundo zisebenzisa izinketho zokufometha nezokuhlela ezitholakalayo ku-Excel 2013. Lokhu kuhluke kulabo abatholakala ekuhumusheni kokuqala kohlelo. Sebenzisa izixhumanisi ezilandelayo zamakholi wekholomu wekholomu kwezinye izinguqulo ze-Excel.

• I-Excel 2010 Isifundo seKhadi lamakholomu
• I-Excel 2003 (nezinguqulo zangaphambilini) Ukufundisa Ishadi lamakholomu

Inothi kwi-Excel's Theme Colors

I-Excel, njengezinhlelo zonke ze-Microsoft Office, isebenzisa izingqikithi ukubeka ubukeka bezincwadi zayo.

Isihloko esetshenziselwa lesi sifundo yisihloko se- Office esizenzakalelayo.

Uma usebenzisa enye indaba elandelayo ngenkathi ulandela le tutorial, imibala efakwe ezinyathelweni zokufundisa kungenzeka ingatholakali engqikithi oyisebenzisayo. Uma kungenjalo, khetha nje imibala ekuthandeni kwakho njengama-substitute futhi uqhubeke.

02 ka 06

Ukufaka idatha yeThart futhi Ukwakha Ishadi Lamakholamu Eyisisekelo

Qaphela: Uma ungenalo idatha esetshenziselwe ukuyisebenzisa nalesi sifundo, izinyathelo kulo mfundo zisebenzisa idatha eboniswe esithombeni ngenhla.

Ukufaka idatha yeshadi kuhlale kuyisinyathelo sokuqala ekudaleni ishadi - kungakhathaliseki ukuthi yiluphi uhlobo leshadi oludalwa.

Isinyathelo sesibili sigcizelela idatha okufanele isetshenziswe ekudaleni ishadi.

1. Faka idatha ekhonjiswe esithombeni ngenhla kumaseli afanele okushicilela
2. Uma usungenwe, qokomisa ububanzi bamaseli kusuka ku-A2 kuya ku-D5 - lokhu kuluhlu lwedatha oluzobe lumelelwe ishadi lamakholomu

Ukudala Ishadi Lamakholomu Eliyisisekelo

Izinyathelo ezingezansi zizokwenza ishadi lamakholomu ayisisekelo - ishadi elicacile, elingenalwazi - elibonisa uchungechunge oluthathu lwedatha, umlando, kanye nesihloko esishayela ishadi.

Ngemuva kwalokho, njengoba kukhonjisiwe, ukufundisa kuhlanganisa indlela yokusebenzisa ezinye izici zokufometha ezivame kakhulu, okulandelayo, uma zilandelwa, zizoshintsha igrafu eyisisekelo ukufanisa okuboniswe phezulu kwalesi sifundo.

1. Chofoza ku- Faka ithebhu ye-ribbon
2. Ebhokisini Lamashadi webhebhoni, chofoza ku-Isithonjana seKhadi lekholomu lokufaka ukuze uvule uhlu lokudonsa phansi lwezinhlobo zeshadi ezitholakalayo
3. Hambisa isikhombisi sakho segundane phezu kohlobo lweshadi ukuze ufunde incazelo yeshadi
4. Esigabeni se- 2-D yekholomu kuhlu, chofoza ku- Column ehlanganisiwe - ukwengeza ishadi elisisekelo ekhasini lokusebenzela

03 ka 06

Ukungeza isihloko seshadi

Hlela isihloko seShadi elizenzakalelayo ngokuchofoza kukho kabili - kodwa ungachofoli kabili

1. Chofoza kanye esihlokweni seshadi elizenzakalelayo ukulikhetha - ibhokisi kufanele livele kuzungeze isihloko seThikhthi
2. Chofoza okwesibili ukubeka i-Excel kumodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lesihloko
3. Susa umbhalo ozenzakalelayo usebenzisa okhiye we-Delete / Backspace ekhibhodi
4. Faka isihloko seshadi - Isifinyezo Sokuthola Imali ka-Cookie 2013 - ebhokisini lesihloko
5. Faka isikhombisi phakathi kwe- Shop no- 2013 esihlokweni bese ucindezela ukhiye we-Enter ekhibhodi ukuze uhlukanise isihloko emigqeni emibili

Kuleli phuzu, ishadi lakho kufanele lifane nesibonelo esiboniswe esithombeni ngenhla.

Ukuchofoza engxenyeni engalungile yeShadi

Kunezingxenye eziningi ezihlukene eshadini ku-Excel - njengendawo yendawo ephethe ishadi lekholomu elimele uchungechunge lwedatha olukhethiwe, i-legend, nesihloko seshadi.

Zonke lezi zincenye zibhekwa njengezinto ezihlukene yihlelo, futhi, ngaleyo ndlela, ngayinye ingenziwa ifomathiwe ngokwehlukana. Utshela i-Excel ukuthi iyiphi ingxenye yeshadi ofuna ukuyifometha ngokuchofoza kuyo nge-pointer yegundane.

Ezinyathelweni ezilandelayo, uma imiphumela yakho ingafani nalabo ababalwe kusifundo, cishe kungenzeka ukuthi awunayo ingxenye efanele yeshadi elikhethiwe uma ungeze ukhetho lokufometha.

Iphutha elivame ukukwenziwa ngokuchofoza endaweni yesakhiwo phakathi kwenqola lapho inhloso ukukhetha ishadi lonke.

Indlela elula yokukhetha ishadi lonke ukuchofoza ngakwesokunxele noma ngakwesokudla ngakwesokudla kude nesihloko seshadi.

Uma kwenzeka iphutha, lingalungiswa ngokushesha usebenzisa isici sokuhlehlisa i-Excel ukulungisa iphutha. Ngemva kwalokho, chofoza ngakwesokudla kweshadi uphinde uzame futhi.

04 ka 06

Ukushintsha isitayela seshadi kanye nekholomu Colors

Amathebhu we-Chart Tools

Uma ishadi lidalwe ku-Excel, noma noma nini lapho ishadi elikhona likhethwa ngokuchofoza kukho, amathebhu amabili engeziwe angeziwe kubhande njengoba kuboniswa esithombeni ngenhla.

Lezi amathebhu wamathuluzi we-Chart - ukuklama nokufometha - aqukethe izinketho zokufometha kanye nezinketho ngokukhethekile ngamashadi, futhi azosetshenziselwa izinyathelo ezilandelayo ukufometha ishadi lamakholomu.

Ukushintsha isitayela seshadi

Izitayela zeshadi kukhona inhlanganisela ehlelwe yindlela yokufometha engasetshenziswa ukufometha ngokushesha ishadi usebenzisa izinketho ezihlukahlukene.

Noma, njengoba kunjalo kulokhu okufundiswayo, angasetshenziswa njengendlela yokuqala yokufometha ngezinguquko ezengeziwe ezenziwe kwisitayela esikhethiwe.

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke
2. Chofoza kuthebhu Yokwakha yedibhoni
3. Chofoza ku- Isitayela Sokukhetha 3 esigabeni seShadi Lesitayela sebhebhoni
4. Wonke amakholomu eshadini kufanele abe nemigqa emifushane, emhlophe, enezingqimba egijima kuzo futhi iphutha kufanele lihambise phezulu kweshadi ngaphansi kwesihloko

Ukushintsha i-Column Colors

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke uma kunesidingo
2. Chofoza inketho ye- Change Colors ehlangothini lwesobunxele lwethebhu Yokuklama yebhande ukuze uvule uhlu lokudonsa phansi lokukhetha kombala
3. Hambisa isikhombisi sakho segundane phezu komugqa ngamunye wembala ukuze ubone igama lokukhetha
4. Chofoza ku- Okthoba 3 ukhetho ohlwini - okwesithathu kukhetho esigabeni esibalabala ohlwini
5. Imibala yekholomu yochungechunge ngalunye kufanele ishintshe ku-orange, ephuzi, futhi eluhlaza, kodwa imigqa emhlophe kufanele isabikho kukholomu ngayinye

Ukushintsha Umbala Wendatshana Yomdwebo

Lesi sinyathelo sishintsha imvelaphi yeshadi ukukhanya grey usebenzisa inketho Yokugcwalisa Uhlobo ekhonjiswe kuthebhu yefomathi yebhebhoni ekhonjiswe esithombeni ngenhla.

1. Chofoza ngemuva ukuze ukhethe ishadi lonke futhi ubonise amathebhu wamathuluzi eshadi elibhebheni
2. Chofoza kuthebhu yefomethi
3. Chofoza ku-Option Shape Fill ukuze uvule iphaneli yehla ye-Fill Colors
4. Khetha i- Grey -50%, i-Accent 3, i-Lighter engu-40% kusukela kusigaba se- Theme Colors sephaneli ukuze ushintshe umbala wangemuva weshadi ukukhanya okumpunga

05 ka 06

Ukushintsha Umbhalo Weshadi

Ukushintsha Umbala Wombhalo

Manje ukuthi isizinda siyimpunga, umbhalo ozenzakalelayo omnyama awubonakali. Lesi sigaba esilandelayo sishintsha umbala wazo wonke umbhalo eshadini kuya eluhlaza ukuthuthukisa umehluko phakathi kokubili usebenzisa inketho yokugcwalisa umbhalo .

Le ndlela ikhiwe kuthebhu yefomathi yebhebhoni ekhonjiswe esithombeni ekhasini langaphambilini le-tutorial.

1. Chofoza kusemuva leshadi ukuze ukhethe ishadi lonke, uma kunesidingo
2. Chofoza kuthebhu yefomathi yedibhoni
3. Chofoza kwi- Text Fill option ukuvula uhlu lwe-Text Colors
4. Khetha u- Green, i-Accent 6, i-Darker 25% kusukela kusigaba se- Theme Colors ohlwini
5. Yonke imibhalo esihlokweni, izinkomba, ne-legend kufanele ishintshe ibe luhlaza

Ukushintsha uhlobo lwefonti, Usayizi, nokugcizelelwa

Ukushintsha usayizi nohlobo lwefonti elisetshenziselwa yonke imibhalo eshadini, ngeke kube ngcono kuphela ngaphezulu kwefonti ezenzakalelayo esetshenzisiwe, kodwa kuzokwenza kube lula ukufunda amagama nezindinganiso amagama namanani eshadini. Ukufometha kweBold kuyophinde kwengezwe embhalweni ukuze kuvezwe nakakhulu ngokumelene nesizinda.

Lezi zinguquko zizokwenziwa ngokusebenzisa izinketho ezisendaweni yefonti yethebhu yaseKhaya yebhebhoni.

Qaphela : Ubukhulu befonti bulinganiselwa amaphuzu - ngokuvamile kufushaniswa ku- pt .
72 pt. umbhalo ulingana no-inch - 2.5 cm - ngosayizi.

Ukushintsha Umbhalo Wesihloko Somdwebo

1. Chofoza kanye esihlokweni seshadi ukuze ukhethe
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Engxenyeni yefonti yebhebhoni, chofoza ebhokisini lefonti ukuvula uhlu oludonsela phansi lwamafonti atholakalayo
4. Pheqa ukuze uthole futhi uchofoze ku-font Leelawadee kuhlu ukuze ushintshe isihloko kule fonti
5. Ngobhokisi befonti eduze kwebhokisi lefonti, setha isihloko samagama wefonti ku-16 pt.
6. Chofoza kusithonjana se-Bold (incwadi B ) ngezansi kwebhokisi lefonti ukuze ungeze ukufometha kwesibindi esihlokweni

Ukushintsha umbhalo we-Legend and Axes

1. Chofoza kanye kumalebula e-X axis (enezingqimba) eshadini ukuze ukhethe amagama we-cookie
2. Ukusebenzisa izinyathelo ezibalulwe ngenhla ngokushintsha umbhalo wetheksthi, setha lamalebula e-axis ku-10 pt Leelawadee, ngesibindi
3. Chofoza kanye kumalebula e-Y axis (mpo) eshadini ukuze ukhethe inani lemali ngakwesokunxele seshadi
4. Ukusebenzisa izinyathelo ezingenhla, setha lamalebula axisi ku-10 pt Leelawadee, ngesibindi
5. Chofoza kanye kwendatshana yeshadi ukuze ukhethe
6. Ukusebenzisa izinyathelo ezingenhla, setha umbhalo we-legend ku-10 pt Leelawadee, ngesibindi

Yonke imibhalo eshadini kufanele manje ifane leLewawadee kanye nohlaza obumnyama okombala. Kuleli phuzu, ishadi lakho kufanele lifane neshadi esithombeni ngenhla.

06 ka-06

Ukungeza amarekhodi weGrid nokushintsha Umbala Wabo

Ngisho noma ama-gridlines e-horizontal aqala ukufaka ngeshadi elizenzakalelayo lekholomu, ayengeyona ingxenye yomklamo omusha okhethwe esiteji sesi-3, ngakho-ke, isusiwe.

Lesi sinyathelo sizofaka amachashadi wegridi emuva endaweni yendawo yeshadi.

Uma kungabikho amalebula wedatha abonisa inani langempela lekholomu ngayinye, amakholi wegridi akwenza kube lula ukufunda amanani ekholomu kusuka emalini imali eshiwo ohlwini lwe-Y (obala).

Ama-gridlines athengiswa usebenzisa inketho ye- Add Chart Element kuthebhu Yokuklama yebhande.

1. Chofoza kanye kwenye yendawo yesakhiwo yeshadi ukuyikhetha
2. Chofoza kuthebhu Yokwakha yebhande uma kudingeka
3. Chofoza kwikhotho ye- Add Chart Element ngakwesokunxele kwebhande ukuze uvule imenyu ehlayo
4. Emenyu yokudonsela phansi, chofoza ku- Gridlines> I-Primary Horizontal Major ukuze ungeze amandla, amhlophe, amarekhodi wegridi endaweni yendawo yeshadi

Ukwenza Ukufometha Izinguquko Kusebenzisa Ifomathi Yomsebenzi Yokufometha

Izinyathelo ezilandelayo zokufundisa zisebenzisa isitayela somsebenzi wokufometha , esinezinketho eziningi zokufometha ezitholakalayo zamashadi.

Ku-Excel 2013, uma kusebenziwe, i-paneli ibonakala ngakwesokudla ngakwesokunxele kwesikrini se-Excel njengoba kuboniswe esithombeni ngenhla. Isihloko kanye nezinketho ezivela ekuguquleni kwesimo sezansi kuncike endaweni yeshadi elikhethiwe.

Isinyathelo sokuqala sizoshintsha umbala wezintambo zegridi ezifakwe ngaphezulu ngenhla kusuka kumhlophe kuya ku-olanini ukuze zenze zibonakale nakakhulu emhlabathini we-gray emuva endaweni yendawo yeshadi.

Ukushintsha Umbala we-Gridlines '

1. Egrafini, chofoza kanye nge-$ 60,000 yegridline egijima phakathi kwegrafu - wonke amarekhodi wegridi kufanele agcizelelwe (amachashazi aluhlaza okwesibhakabhaka namhlophe ekugcineni komgqa ngamunye)
2. Chofoza kuthebhu yefomethi yebhebhoni uma kunesidingo
3. Chofoza ukhetho lokufometha kwefomathi ngakwesokunxele kwebhande ukuze uvule i- Postting Task pane - okubheke phezulu kwilawenda kufanele ibe Fometha amaGrid amakhulu
4. Ephawuleni, setha uhlobo lomugqa emgqeni oqinile
5. Misa umbala wegridline ku- Orange, Accent 2, Emnyama 25%
6. Wonke amamephu wegridi endaweni yesakhiwo kumele ashintshe ku-orange omnyama ngombala

Ukufometha i-X Axis Line

Umzila we-axis we-X ukhona ngaphezu kwamalebula we-axis we-X (amagama we-cookie), kodwa, njengama-gridlines, kunzima ukubona ngenxa yesimo esiyimpunga seshadi. Lesi sinyathelo sizoshintsha umbala we-axis nobukhulu bomugqa ukufanisa lokho kwegalaridi efomethiwe.

1. Chofoza kumalebula e-axis X ukugqamisa umugqa we-axis X
2. Kufomathi yomsebenzi yokufometha, njengoba kuboniswe esithombeni ngenhla, setha uhlobo lomugqa olayini oluqinile
3. Hlela umbala wendiza ye-axis ku- Orange, i-Accent 2, i-Darker 25%
4. Setha ububanzi bomugqa we-axis ukuya ku- 0.75 pt.
5. Umzila we-axis we-X kufanele uhambelane nezitayela zegridi

Uma ulandele zonke izinyathelo kulesi sifundo, ishadi lakho lekholomu kufanele lifanise isibonelo esiboniswe phezulu kwaleli khasi.