Indlela yokwenza nokufometha Ishadi lekholamu kwi-Excel 2010

01 ngo-06

Amanyathelo okwenza Ishadi lekholamu kwi-Excel 2010

Amanyathelo okudala ishadi lomhlathi wesiseko kwi-Excel 2010 ngaba:

1. Khankanya idatha ukuba ifakwe kwi-tshatyi-zibandakanya izihloko zemiqolo kunye nekholomu kodwa kungeyiyo isihloko setafile yedatha;
2. Cofa kwi- Insert ithebhu yebhebhoni ;
3. Kwibhokisi yeSetyiti yebhoni, nqakraza kwi-icon ye-Column Ishadi le-Column ukuvula uluhlu lokuhlahla lweentlobo zetshati ezikhoyo;
4. Hambisa isalathisi sakho semouse phezu kwengubo yetshathi ukuze ufunde inkcazo yetshathi;
5. Cofa kwi-chart efunwayo;

Itafile ecacileyo, engaqinisekanga - ebonisa kuphela uluhlu lweenkcukacha ezikhethiweyo, i-legend, kunye ne-axis values ​​- ziya kufakwa kwiphepha lokusebenzela elikhoyo.

Ukwahluka kweenguqu kwi-Excel

Amanyathelo kule khokelo abasebenzisa iindlela zokufomathiza kunye neendlela ezikhoyo kwi-Excel 2010 kunye no-2007. Ezi zihluke kwizinto ezifunyenwe kwiinguqulelo zangaphambili kunye nexesha elizayo leprogram. Sebenzisa ezi zilandelayo izixhumanisi zezifundo zetshathi zekholomu kwezinye iinguqulelo ze-Excel.

• Excel 2013 I-Tutorial yeKharityhulam yeKholamu
• Excel 2003 (kunye neenguqu zangaphambili) I-Tutorial yeKhadi lekholamu

Inqaku kwi-Excel's Theme Colors

I-Excel, njengenkqubo zonke zeMicrosoft Office, isebenzisa iingqikithi ukusekwa kwimiqulu yayo.

Umxholo osetyenziswe kule khokelo ngumxholo oyi- Office .

Ukuba usebenzisa enye inqaku ngelixa ulandela le tutorial, imibala efakwe kumanyathelo okufundisa ayinakufumaneka kwimxholo oyisebenzisayo. Ukuba kunjalo, khetha nje imibala ekuthandeni kwakho njengabafaka indawo kwaye uqhubeke.

• Uhlolisise kwaye utshintshe umxholo wencwadi

02 we-06

Ukudala Isatifiketi seKomkhulu esisisiseko kwi-Excel

Ukungena nokukhetha iData yeTutorial

Qaphela: Ukuba awunayo idatha esetyenziswayo kunye nale khokelo, amanyathelo kule tutorial asebenzise idatha eboniswe kumfanekiso ongentla.

Isinyathelo sokuqala ekudaleni ishati ihlala isingatha idatha yetshathi - kungakhathaliseki ukuba yintoni na ishadi elenziweyo.

Isinyathelo sesibini sibonisa ukuba idatha iya kusetyenziswa ekudaleni ishati.

Xa ukhetha idatha, izihloko zekhowudi kunye nekholomu zifakiwe ekukhetheni, kodwa isihloko esiphezulu setafile yedata asikho. Isihloko kufuneka songezwe kwitshathi ngesandla.

1. Faka idatha eboniswe kumfanekiso ngasentla kwiiseli zomsebenzi ezichanekileyo
2. Emva kokungena, khankanya uluhlu lweeseli ezivela kwi-A2 ukuya kwi-D5 - olu luhlu lweedatha oluya kumelwa ngeshati yekholomu

Ukudala Isatifiketi seKholamu esiSeko

1. Cofa kwi- Insert ithebhu yebhebhoni
2. Kwibhokisi yeSetyiti yebhebhoni, nqakraza kwi- Isalathisi yeKhadi leKholamla ukuvula uludwe ohlayo lweentlobo zeesatriki ezikhoyo
3. Hambisa isalathisi sakho semouse phezu kwengubo yetshathi ukuze ufunde inkcazo yetshathi
4. Kwinqanaba lekholam ehlanganisiweyo ye-3-D yololuhlu , nqakraza kwiKholam ehlanganisiweyo - ukongeza ishadi eliyisiseko kwiphepha lokusebenzela

03 we-06

I-Excel Chart Parts kunye nokususwa kweGridlines

Ukuchofoza kwiCandelo elingalunganga leShadi

Kukho amaninzi ahlukeneyo kwitshathi e-Excel - njengendawo yesalathisi equlethe ityhula yekholomu ebonisa i- series ekhethiweyo yedatha , umgca, kunye nesihloko seetati.

Zonke ezi ndawo zibhekwa njengezinto ezihlukeneyo kwinkqubo, kwaye, ngoko kunjalo, nganye inokufomelwa ngokuhlukileyo. Utshela i-Excel nayiphi inxalenye yetshathi ofuna ukuyifomatha ngokuchofoza kuyo nge-pointer ye mouse.

Kwimanyathelo alandelayo, ukuba iziphumo zakho azifani nazo ezidweliswe kwi-tutorial, kunokwenzeka ukuba awukho inxalenye efanelekileyo yetshathi ekhethiweyo xa ungeze ukhetho lokufomatha.

Impazamo eqhelekileyo eyenziwa ngokuchofoza kwindawo yesalathisi phakathi kwinqwelo xa injongo ukukhetha isatshi sonke.

Indlela elula yokukhetha iseshati yonke kukucofa kwikhohlo eliphezulu okanye ngakwesokudla ukusuka kwisihloko seshati.

Ukuba kukho impazamo, iyakulungiswa ngokukhawuleza usebenzisa isicatshulwa se-Excel sokulungisa umpazamo. Emva koko, nqakraza kwicala elifanelekileyo letshathi uze uzame kwakhona.

Ukususwa kweGridlines ukusuka kwiNgingqi yeSicwangciso

Umgca wesiseko wesigcawu uquka igaladi ye-grid ehamba ngokubanzi kwindawo yesebe ukwenzela ukuba kube lula ukufunda amaxabiso kumaphulo athile yedatha - ingakumbi kwiitshathi eziqukethe idatha eninzi.

Ekubeni kukho kuphela uluhlu lwesithathu lweedatha kule tstshi, iinkcukacha zedatha zilula ukuzifunda, ngoko iifayile zegrid ziyakwenziwa.

1. Kwitshathi, nqakraza kanye kwi-60,000 ye-gridline ehamba phakathi kwegrafu ukugqamisa zonke ii- gridlines - ezincinane izibhakabhaka ezibhakabhaka kufuneka zibonwe ekupheleni kwegridline nganye.
2. Cinezela ikhiye lokucima kwibhodibhodi ukususa igalari

Kule ngongoma, ishati kufuneka ifane nomzekelo oboniswe kumfanekiso ongentla.

04 we-06

Ukutshintsha itekiti yombhalo

Iimpawu zeTyrt Tools

Xa ithetshi idalwe kwi-Excel 2007 okanye ngo-2010, okanye nayiphi na isati ekhoyo ekhethiweyo ngokuchofoza kuyo, iithebhu ezongezelelweyo ezintathu zongezwa kwibhebhoni njengoko kuboniswe kumfanekiso ongentla.

Ezi ithebhu zeTyrt Tools - Design, Layout, kunye neFomathi-ziqukethe ukufomatha nokhetho olukhethiweyo ngokukodwa kwiitshathi, kwaye ziya kusetyenziswa kula ma nyathelo alandelayo ukuze ungeze isihloko kwisiqendu sekholomu uze utshintshe imibala yetshathi.

Ukongeza kunye nokuHlalwa kweSihloko soTyati

Kwi-Excel ka-2007 kunye no-2010, amashadi ayisiseko awabandakanyi izihloko zeetati. Ezi zimele zongezwe ngokwahlukileyo usebenzisa inketho yeSihloko soTyati efunyenwe kwiTyhu yoLungiselelo kwaye ihlelwe ukubonisa isihloko esifunwayo.

1. Cofa kanye kwitshathi ukuze ukhethe, ukuba kuyimfuneko, ukufaka iithebhu zamathuluzi ezitshati
2. Cofa kwiTyhu yoTywala
3. Cofa kwiKhetho leSihloko soTyati ukuvula uluhlu lwezinto ezikhethiweyo
4. Khetha i- Chart ephezulu ukusuka kuloluhlu ukubeka ibhokisi leetayiti engagqibekanga kwitshati engentla kwiikholomu zeenkcukacha
5. Cofa kanye kwibhokisi yecatshulwa ukuze uhlele umbhalo wesicatshulwa
6. Cima iteksi engagqibekanga kwaye faka isihloko sesitifiketi - I-Cookie Shop 2013 Isishwankathelo seNgeniso - kwibhokisi yebhokisi
7. Beka isikhombisi phakathi kwe- Shop kunye no- 2013 kwisihloko kwaye cinezela ukhiye wokungena kwibhodibhodi ukuhlula isihloko kwisibini ezimbini

Ukutshintsha uhlobo lwemibuzo

Ukutshintsha uhlobo lwefonti oluthatyathwa ngokungafuneki kuwo wonke umbhalo kwisatiyi akuyi kuphucula kuphela ukubonakala kwetshathi, kodwa kuya kwenza kube lula ukufunda imbali kunye namagama exabiso kunye namanani.

Olu tshintsho luya kwenziwa ngokusebenzisa iindlela ezikhethwe kwicandelo lefonti lethebhu yaseKhaya yebhebhoni.

Qaphela : Ubungakanani befonti bulinganiswa kumaphuzu - kaninzi kufutshane ukuya kwi- pt.
72 pt. Umbhalo ulingana no-intshi - 2.5 cm - ngobukhulu.

Ukutshintsha umxholo weTyati

1. Cofa kanye kwihloko yetshathi ukuze ukhethe
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Kwifayile yefonti yebhoni, nqakraza kwibhokisi yePolisi ukuvula uluhlu lokuhla lweentlobo ezikhoyo
4. Skrolela ufumane kwaye uqhosha kwifonti Arial Black kuloluhlu ukuguqula isihloko kule fom

Ukutshintsha iThe Legend and Axes Text

1. Phinda ulandele amanyathelo angentla apha ukutshintsha itekisi kwisiganeko seesati kunye ne-X ne-Y axxes ku-Arial Black

05 ka 06

Ukutshintsha imibala kwiKhadi lekholamu

Ukutshintsha Umbala woMgangatho kunye neNxweme elingaphandle

Amanyathelo ekufundiseni aquka ukutshintsha umbala wecatshi yomgangatho kunye nodonga olusecaleni kumnyama njengoko kuboniswe kumfanekiso ongentla.

• Umgangatho wetshathi ngumxande ongezantsi ongaphantsi kweenkcukacha zedata kwindawo yendawo.
• Udonga olusecaleni lusekhohlo lwendawo yesalathisi phakathi kwamacolomnatha yedatha kunye neileyibhile ze-Y (zecala).

Zozo zombini izinto ziza kukhethwa ngokusebenzisa i- chart elements ehla phantsi uluhlu olukho kwicala elingakwesokunxele lweTy Layout yerbbon.

1. Cofa kwi-background yangesetyati ukukhetha yonke isati xa kuyimfuneko
2. Cofa kwiTyhu yoLungiselelo yerbhoni
3. Ngeseshati ekhethiweyo, uludwe lwezinto zeshati kufuneka lubonise igama leTyati yeSithili kwikhoneni eliphezulu lasekhohlo lebhoni.
4. Cofa kwinqolo engezantsi kwitshathi yetshathi yokukhetha ukuvula uluhlu olwehlayo lweengxenye zetshathi
5. Khetha Umgangatho ukusuka kuhlu lweengxenye zetshathi ukugqamisa umgangatho weseshati
6. Cofa kwi Fomati ithebhu yerbhoni
7. Cofa kwi- Shape Fill option ukuze uvule iphaneli yokulahla yebala lokugcwalisa
8. Khetha i- Black, Umbhalo 1 kwiSahluko seNqakrazo yemixholo yepaneli ukuze utshintshe umbala webala lomtshini kumnyama
9. Phinda amanyathelo 2 ukuya ku-6 apha ngentla ukutshintsha umbala weBhanti elingaphandle kwetafile ukuya kumnyama

Ukuba ulandele onke amanyathelo kwinqanaba lokufundisa, ngeli nqanaba, ishati yakho kufuneka ifane nomnye obonwayo kumfanekiso ongentla.

06 we-06

Ukutshintsha iikholam yebala kunye nokuhambisa ishadi

Ukutshintsha Umbala weedatha zeDatha yeDatha

Eli nyathelo ekutshintshiseni ukufundiswa kwimiqolo yeenkcukacha ngokuguqula imibala, ukongeza i-gradient, kunye nokongeza isicatshulwa kwikholamu nganye.

Ubume obuzalisekileyo kunye nokukhethwa kweenkcazo zeenkcazo , ezikwiphepha leFomathi ziya kusetyenziswa ukuchaphazela ezi tshintsho. Iziphumo ziza kufana namakholomu abonwe kumfanekiso ongentla.

Ukutshintsha Umvuzo weKholeji yeRevenue

1. Cofa kanye ngeyinye yee-columns ezipheleleyo zeBlue Total Revenue kwitshathi ukukhetha zonke iikholomu ezintathu zeblue
2. Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko
3. Cofa kwi- Shape Fill option ukuze uvule iphaneli yokulahla yebala lokugcwalisa
4. Khetha iBlue Blue, Umbhalo wesi-2, I-Lighter engu-60% ukusuka kwiCandelo leMbala leMbala yePaneli ukuze utshintshe umbala wekholomu ukukhanya okuhlaza okwesibhakabhaka

Ukongeza i-Gradient

1. Iikholeji ezipheleleyo ezikhethiweyo zikhethiweyo, nqakraza kwi- Shape Fill option okwesibini ukuvula iMenyu yokuThola imibala ehla phantsi
2. Khupha isalathisi se mouse phezu kwekhetho elifutshane ngasezantsi kwoluhlu ukuvula iPanelient Gradient
3. KwiCandelo lokuKhanya koKhanya kwiphaneli, cofa kwiNqakrazo yeNqakrazo yokunene ukuze ungeze igradient elula ngakumbi ukusuka kwesobunxele ukuya ngasekunene kwikholam

Ukongeza Inkcazo yekholamu

1. Iikholeji zeNgeniso zeNgeniso ezikhethiweyo zikhethiweyo, nqakraza kwikhetho ye-Outline ye-Shape ukuvula imenyu ye-Downline ye-Shape Outline
2. Kwinqanaba le- Colors edidiyele yepaneli, khetha i- Dark Blue ukuze ungeze umgca omnyama obomvu kwikholam nganye
3. Cofa kwiCandelo loPhuhliso lweSombululo okwesibini
4. Cofa kwiCandelo lesisindo kwimenyu ukuvula imenyu engaphantsi yezinto ozikhethayo
5. Khetha 1 1/2 pt. ukwandisa ubukhulu beenkcukacha zekholomu

Ukufometha iLuhlu lweZindleko zoLonke

Phinda usebenzise amanyathelo asetshenziselwa ukufomatha iikholeji ezipheleleyo zeRevenue, usebenzisa iifom ezilandelayo:

• Umbala Wokuzalisa Umbala: I-Akhawunti yesiBomvu 2, Ubumnyama 50%
• I-Gradient: UkuKhanya koMbane , uLungelo oluMgca
• Umbala weKholam u-Colorline: I-Accent ebomvu 2, Ubumnyama 50%
• Ikholamu Inkcazo yomgca we-Weight: 1 1/2 pt.

Ukufomathiza iSingqinisiso seNzuzo / Ukulahleka

Phinda usebenzise amanyathelo asetshenziselwa ukufomatha iikholeji ezipheleleyo zeRevenue, usebenzisa iifom ezilandelayo:

• Umbala wokugcwalisa umbala: I- Olive Green Accent 3, i-Darker 25%
• I-Gradient: UkuKhanya koMbane , uLungelo oluMgca
• Umbala woMgca woMgca: I- Olive Green Accent 3, i-Darker 50%
• Ikholamu Inkcazo yomgca we-Weight: 1 1/2 pt.

Kule ngongoma, ukuba onke amanyathelo okufomatha alandelwe, ididi yekholomu ifanele ifane neshadi elibonwe kumfanekiso ongentla.

Ukuhambisa Isatifiketi kwiSahluko esahlukileyo

Isinyathelo sokugqibela kwisifundo sifaka ishati kwiphepha elihlukileyo kwincwadi yokusebenzela usebenzisa ibhokisi yencoko yebhodi yebhodi.

Ukuhambisa ishati kwiphepha elihlukileyo kwenza kube lula ukuphrinta istyati kwaye kunokunciphisa ukudibanisa kwiphepha elibanzi lokusebenzela eligcwele idatha.

1. Cofa kwiimvelaphi zetshathi ukukhetha yonke isati
2. Cofa kwiThebhu yoyilo yerbhoni
3. Cofa kwi icon yeMoji yeTyhuda kwicala elide lasebhoni ukuze uvule ibhokisi yencoko yebhodi yebhodi
4. Njengokuba kuboniswe kumfanekiso ongentla, cofa kwiKharityhulam entsha kwindlela yebhokisi yencoko kwaye - ngokuzikhethela-nikela iphepha, njenge-Cookie Shop 2013 Income Summary
5. Cofa OK ukuvala ibhokisi yencoko - ithathi kufuneka ibekwe kwiphepha elihlukile kunye negama elitsha elibonakalayo kwiphepha leshidi ngaphantsi kwesikrini.