Indlela yokudala Ishadi lekholamu kwi-Excel

01 ngo-06

Indlela yokudala Ishadi lekholamu kwi-Excel

Amanyathelo okudala ishadi lomhlathi wesiseko kwi-Excel yile:

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 kwigrafu efunwayo;

Itafile ecacileyo, engatshintshiyo - ebonisa kuphela iikholomu ezimelela uluhlu lweenkcukacha ezikhethiweyo, isihloko esicatshulwa esicatshulwayo, umxholo, kunye nemilinganiselo ye-axes - iya kufakwa kwiphepha lokusebenzela elikhoyo.

Ukwahluka kweenguqu kwi-Excel

Amanyathelo kule tutorial basebenzisa iindlela zokufometha kunye neendlela zokufumaneka ezikhoyo kwi-Excel 2013. Ezi zihluke kwizinto ezifumaneka kwiinguqulelo zangaphambili zenkqubo. Sebenzisa ezi zilandelayo izixhumanisi zezifundo zetshathi zekholomu kwezinye iinguqulelo ze-Excel.

• I-Excel 2010 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 akunjalo, khetha nje imibala ekuthandeni kwakho njengabafaka indawo kwaye uqhubeke.

02 we-06

Ukufaka iDatha yeDatha nokudala Isatifiketi seKholamu esiSeko

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

Ukufaka idatha yetshathi kuhlala kuyisinyathelo sokuqala ekudaleni ishati - kungakhathaliseki ukuba yintoni na ishadi elenziweyo.

Isinyathelo sesibini sibonisa ukuba idatha iya kusetyenziswa ekudaleni ishati.

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

Amanyathelo angezantsi azakudala ishadi lomhlathi wesiseko - isatifiketi esicacileyo, engaqinisekanga-esibonisa iziqendu ezintathu zedata, umxholo, kunye nesihloko seshati esingagqibekanga.

Emva koko, njengoko kukhankanywe, uqeqesho lubandakanya indlela yokusebenzisa ezinye iimpawu zokufomathiza eziqhelekileyo, eziya kuthi zilandelwe, ziya kutshintsha igrafu yesiseko ukufanisa enye iboniswe phezulu kwolu qeqesho.

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. Kwiphepha le- 2-D yekholam yoluhlu, nqakraza kwiKholamu eQinisiweyo - ukufaka ishadi eliyisiseko kwiphepha lokusebenzela

03 we-06

Ukongeza Isihloko soTyati

Hlela isiKhadi seTyati esingagqibekanga ngokuchofoza kuso kabini - kodwa ungaqakraza kabini

1. Nqakraza kanye kwinqaku lechasi elikhethiweyo ukulikhetha - ibhokisi kufuneka ibonakale ngeenxa zonke kwigama lesiTyhuthi
2. Cofa okwesihlandlo sesibini ukubeka i-Excel kwimodi yokuhlela , ebeka isikhombisi ngaphakathi kwebhokisi lebhokisi
3. Cima itekisi engagqibekanga usebenzisa iifayile zokuCima / i-Backspace kwikhibhodi
4. Faka isihloko setyati - I-Cookie Shop 2013 Isishwankathelo seNgeniso - kwibhokisi yebhokisi
5. Beka isikhombisi phakathi kwe- Shop kunye no- 2013 kwisihloko kwaye cinezela ukhiye wokungena kwibhodibhodi ukuhlula isihloko kwisibini ezimbini

Kule ngongoma, ishati kufuneka ifane nomzekelo oboniswe kumfanekiso ongentla.

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.

04 we-06

Ukutshintsha Isitayela seTyati kunye neColumn Colors

Iimpawu zeTyrt Tools

Xa ityati idalwa kwi-Excel, okanye nayiphi na ikhetshi ekhoyo ekhethiweyo ngokuchofoza kuyo, iithebhu ezimbini ezongezelelweyo zongezwa kwibhoni njengoko kuboniswe kumfanekiso ongentla.

Ezi ithebhu zeTyrt Tools - ukuyila nokufomathi - ziququzelele ukufomathiza kunye neendlela zokukhethwa ngokuthe ngqo kwiitshathi, kwaye ziya kusetyenziswa kula ma nyathelo alandelayo ukufomathiza iseshati yekholomu.

Ukutshintsha Isitayela seTyati

Izitayela zeetragi zidibaniselwano ezikhethiweyo zokukhethwa kwefomati ezingasetyenziselwa ukufomatha ishati ngokusetyenziswa kweendlela ezahlukeneyo.

Okanye, njengokuba kunjalo kule khokelo, bangasetyenziselwa njengendlela yokuqala yokufomathiza kunye nezinguqu ezongezelelweyo ezenziwe kwisitayela esikhethiweyo.

1. Cofa kwi-background yangesetyati ukuze ukhethe lonke isati
2. Cofa kwiThebhu yoyilo yerbhoni
3. Cofa kwiSimboli sesi-3 kwisigaba seStrt Styles sebhebhoni
4. Zonke iikholomu kwitshati kufuneka zibe nemigca emifutshane, emhlophe, emigxina ehamba ngayo kwaye igalelo kufuneka lihambe phezulu kwitshati phantsi kwesihloko

Ukutshintsha imibala yekholomu

1. Cofa kwi-background yangesetyati ukukhetha yonke isati xa kuyimfuneko
2. Ukuchofoza kwiKhetho lokuTshintsha imibala ekhohlo kwicala lasekhohlo lweTydi yoyilo yebhanethi ukuvula uluhlu olukhethiweyo lokukhetha umbala
3. Hambisa isalathisi semouse yakho phezu komqolo ngamnye wembala ukuze ubone igama lokukhetha
4. Cofa kwiNketho yoMbala 3 kwoluhlu - ukhetho lwesithathu kwiCandelo eliMbala kwoluhlu
5. Imibala yekholomu nganye uchungechunge kufuneka ishintshe kwi-orange, ephuzi, kwaye eluhlaza, kodwa imigca emhlophe imele ibe khona kwikholamu nganye

Ukutshintsha Umbala weTrafik's Color

Eli nyathelo lishintsha imvelaphi yetshathi ukukhanya grey usebenzisa inketho yokugcwalisa ifom ekhoyo kwifomathi yefomathi yerbhoni echazwe kumfanekiso ongentla.

1. Cofa kwimvelaphi ukukhetha yonke isati kwaye ubonise iithebhu zeTyrt Tool kwibhoni
2. Cofa kwiTebhu yefomathi
3. Cofa kwi- Shape Fill option ukuze uvule iphaneli yokulahla yebala lokugcwalisa
4. Khetha i- Gray -50%, i-Accent 3, i-40% yeLighter ukusuka kwiCandelo leMbala ye-Color Colors ukuze utshintshe umbala wesiqalo sombala ukukhanya okuluhlaza

05 ka 06

Ukutshintsha itekiti yombhalo

Ukutshintsha Umbala Wombhalo

Ngoku ukuba imvelaphi imhlophe, umbhalo obumnyama ongabonakaliyo awubonakali. Eli candelo lilandelayo litshintsha umbala wezobhaliweyo kwitshathi ukuya eluhlaza ukuphucula umbahluko phakathi kwezi zibini usebenzisa i- Text Fill option.

Olu khetho lusekhompyutheni yetrbhoni ebonwe kumfanekiso kwiphepha langaphambili le-tutorial.

1. Cofa kwi-background yangesetyati ukukhetha yonke isati, ukuba kuyimfuneko
2. Cofa kwi Fomati ithebhu yerbhoni
3. Cofa kwiTekisi Gcwalisa inketho yokuvula uluhlu lwe-Text Colors
4. Khetha i- Green, Accent 6, Darker 25% ukusuka kwiCandelo leMbala yoLuhlu lwoluhlu
5. Yonke isicatshulwa kwisihloko, iisethi, kunye nommiselo kufuneka zitshintshe zibe ziluhlaza

Ukutshintsha uhlobo lwefonti, ubukhulu, nokugxininiswa

Ukutshintsha ubukhulu kunye nohlobo lwefonti elisetyenziselwa yonke into ebhalwe kwitshathi, akuyi kuphucula kuphela ukusetyenziswa kwefonti engagqibekanga, kodwa kuya kwenza kube lula ukufunda imbali kunye namagama enkcazo kunye nezindinganiso kwitshathi. Ukufometha kweBold kuya kwongezwa kwisicatshulwa ukwenzela ukuba kuvelele ngakumbi nangemvelaphi.

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 Leelawadee kuloluhlu ukutshintsha isihloko kule fom
5. Kwibhokisi lefonti elisecaleni kwebhokisi lefonti, setha ubungakanani besitayela sefonti ukuya kwi-16 pt.
6. Cofa kwi-Bold icon (ileta B ) ngaphantsi kwebhokisi yePolisi ukuze ungeze ifomathi yefayili kwisihloko

Ukutshintsha iThe Legend and Axes Text

1. Cofa kanye kwii-eksti ze-axis (ezisezantsi) kwiitekthi ukukhetha amagama e-cookie
2. Ukusebenzisa amanyathelo adweliswe ngasentla ngenjongo yokutshintsha itekisi yetayitile, setha iilebula ze-axis kwi-10 pt Leelawadee, ngesibindi
3. Nqakraza kamva kwiibhali ze-Y axis (vertical) kwitshathi ukuze ukhethe inani lemali kwicala lasekhohlo kwetshathi
4. Ukusebenzisa amanyathelo angentla, setha iilebula ze-axis kwi-10 pt Leelawadee, ngesibindi
5. Nqakraza kamva kwitekto yetshathi ukuze ukhethe
6. Ukusebenzisa amanyathelo angentla, faka umbhalo wendatshana ku-10 pt Leelawadee, ngesibindi

Yonke isicatshulwa kwitshathi kufuneka ngoku i-font Leelawadee kunye nohlaza obumnyama ngombala. Ngeli nqanaba, itshati yakho ifanele ifane kwitshathi emfanekisweni ongentla.

06 we-06

Ukongeza iiGridlines kunye nokutshintsha umbala wabo

Nangona iigridi ezigciniweyo ezingabonakaliyo zazisekho ekuqaleni kweshadi engapheliyo, zazingekho inxalenye yoluyilo olutsha olukhethiweyo kwisinyathelo esithathu, kwaye, ngoko, lususwe.

Eli nyathelo liya kwengeza ii-gridlines kwi- plot plot endaweni yeseshati.

Ukungabikho kwamabhalana eenkcukacha ezibonisa ukubaluleka kwangempela kwekholomu nganye, iifayile zegridi zenza kube lula ukufunda amanani ekholomu kwixabiso lemali elidweliswe kwi-Y (vertical) axis.

Iifowuni zegridi zongezwa ngokusebenzisa inketho yokongeza i- Chart Element kwiThebhu yoyilo yerbhoni.

1. Cofa kanye kwenye yendawo yesalathisi yetshathi ukuyikhetha
2. Cofa kwiThebhu yoyilo yerbhoni xa kuyimfuneko
3. Cofa kwiNketho ye-Element ye-Chart Yongeza kwinqanaba lasekhohlo lebhebhoni ukuvula imenyu ehlayo
4. Kwimenyu ehlayo, nqakraza kwiGridlines> I-Primary Horizontal Major ukuba ungeze i-faint, emhlophe, iigridlines kwindawo yendawo yesatriki

Ukwenza Ukufometha Iinguqulelo usebenzisa Ifayile Yefayile Yokufometha

Amanqanaba alandelayo ootitshala abasebenzisa ifomathi yomsebenzi yokufomathiza , equlethe inketho enkulu yokukhethwa kweefayili.

Kwi-Excel ka-2013, xa isebenze, ikhefu ibonakala ngakwesokunene kwicala le-Excel kwesikrini njengoko kuboniswe kumfanekiso ongentla. Isihloko kunye neenketho ezibonakala kwiphetshana lokutshintsha ngokuxhomekeke kwingingqi yetshathi ekhethiweyo.

Isinyathelo sokuqala siya kutshintsha umbala wegridlines ezifakwe apha ngasentla ukusuka kumhlophe ukuya kwilalanki ukwenzela ukuba zenzeke ngakumbi kwiindawo eziluhlaza ezikwindawo yesalathisi yetshathi.

Ukutshintsha Umbala weGridlines

1. Kwigrafu, nqakraza kanye kwi $ 60,000 yegridline ehamba phakathi kwegrafu - zonke iifayile zegridi kufuneka zigqitywe (amacatshi amhlophe kunye amhlophe ekupheleni kwegridline nganye)
2. Cofa kwi Fomati ithebhu yebhebhoni xa kuyimfuneko
3. Cofa kwikhetho lokukhethwa kwefomathi kwicala lasekhohlo lebhebhoni ukuvula ifowuni yefomathi yokuFometha - i-heading ephezulu kwifowuni kufuneka ifake iifayile ezinkulu zeGrid
4. Kwifowuni, setha uhlobo lomgca kumgca we-Solid
5. Beka umbala wegridline kwi- Orange, Accent 2, Emnyama 25%
6. Zonke ii-gridlines kwindawo yesalathisi kufuneka zitshintshe kwi-orange orange embala

Ukufometha i-X Axis Line

Umgca we-axis we-X ukhona ngaphaya kweebhile ze-axis ze-X (amagama e-cookie), kodwa, njengamajelo e-grid, kunzima ukubona ngenxa yengcambu ye-chart. Eli nyathelo liza kutshintsha umbala we-axis kunye nobukhulu bomgca ukufanisa neefowuni zefriji ezifomathiweyo.

1. Cofa kwiibhile ze-axis ze-X ukugqamisa umgca we-axis
2. Kwifowuni yomsebenzi wefomathi, njengokuba kuboniswe kumfanekiso ongentla, setha uhlobo lomgca kumgca weSolid
3. Beka umbala we-axis umbala kwi- Orange, kwi-Accent 2, emnyama 25%
4. Hlela ububanzi bomgca we-axis ukuya kwi- 0.75 pt.
5. Umgca we-axis we-X kufuneka ngoku udibanise iifridi zegridi

Ukuba ulandele onke amanyathelo kule khokelo, ishadi lakho lekholomu kufuneka ngoku lifanise umzekelo oboniswe phezulu kweli phepha.