Yenza iitshathi kwi-Excel
Un itshathi kwi-Excel Sisixhobo esibonakalayo esisetyenziselwa ukumela idatha ngendlela eqondakalayo nesebenzayo. I-Excel, ephuhliswe nguMicrosoft, ivumela abasebenzisi ukuba benze iindlela ezahlukeneyo zeetshathi besebenzisa idatha efakwe kwi-spreadsheet interface yayo.
Imisebenzi yokwenza iitshathi kwi-Excel
Faka iTshati kwi-Excel
ukuba faka itshathi kwi-Excel, kufuneka kuqala ukhethe idata ofuna ukuyimela. Emva koko, le nkqubo ilandelayo ilandelwa:
- Khetha Idatha: Iphawula iiseli eziqulethe idatha.
- Yiya kwi Faka iTab: Kwiribhoni, cofa ithebhu ethi "Faka".
- Ukukhetha Uhlobo lweTshati: Apha uya kufumana iintlobo ezahlukeneyo zeetshathi, ezifana nekholamu, umgca, ipayi, ibha, indawo, ukusabalalisa, phakathi kwabanye.
- Lungiselela iTshati: Emva kokufaka itshati, ungayenza ngokwezifiso ngokuhlengahlengisa imibala, iilebhile, kunye nezimbo ukuze zihambelane neemfuno zakho.
Iindidi zeetshathi ezifumaneka kwi-Excel
I-Excel ibonelela ngeendlela ezahlukeneyo iintlobo zemizobo eziqhelanisa neentlobo ezahlukeneyo zedatha kunye nohlalutyo:
Iitshathi zeKholam
Los iitshati zekholamu Ziluncedo ekuboniseni utshintsho kwidatha kwixesha elithile okanye ukuthelekisa izinto ezahlukeneyo. Zisebenza ngakumbi xa kukho iindidi ezininzi okanye amaqela edatha ukuthelekisa.
Iitshathi zomgca
Los iigrafu zomgca Zikulungele ukubonisa iintsingiselo ngokuhamba kwexesha. Ngokuqhelekileyo zisetyenziselwa uhlalutyo lwemali kunye nesayensi ukumela utshintsho kwiinguqu kwixesha eliqhubekayo.
Iitshathi zepayi
Los iitshathi zephayi Zikulungele ukubonisa umlinganiselo wamalungu ngaphakathi ngokupheleleyo. Ziyasebenza ekuboniseni ukuhanjiswa kwepesenti phakathi kwamacandelo.
Iitshathi zeBar
Los iitshathi zebha Zifana nekholamu kodwa zimelelwe ngokuthe tye. Ziluncedo xa amagama odidi made okanye xa ufuna ukuthelekisa iinguqu ezininzi.
Iitshathi zoMmandla
Los iitshathi zendawo Ziluncedo ekuboniseni iintsingiselo kunye nendlela amagalelo avela kumaqela ahlukeneyo atshintsha ngayo ngokuhamba kwexesha. Ziyafana neegrafu zemigca kodwa zineendawo ezizalisweyo ezimele iindidi ezahlukeneyo.
Ukuchithachitha amaPlathi
Los ukusasaza iindawo Zisetyenziselwa ukuhlalutya ubudlelwane phakathi kwezinto ezimbini ezahlukeneyo. Zisebenza kakhulu kwizifundo zamanani kunye nokuchonga iipateni okanye ulungelelwaniso.
Ukulungelelanisa iitshathi kwi-Excel
Guqula iTitle kunye neeleyibhile
Emva kokudala itshati, i-Excel ikuvumela ukuba uyiguqule. izihloko kunye neethegi ukwenza igrafu iqondeke ngakumbi.
- Khetha iTshati: Cofa kwitshathi uze ukhethe isihloko okanye ileyibhile ofuna ukuyilungisa.
- Hlela Isiqendu: Chwetheza umbhalo omtsha ngokuthe ngqo kumgca wongeniso.
Lungisa Imibala kunye neZimbo
Unokwenza ngokwezifiso iifayile ze umbala kunye nesimbo yeetshathi ezisuka kwithebhu ethi "Izixhobo zeTshati":
- Khetha iTshati: Cofa kwigrafu.
- Vula iThebhu yoYilo: Fumana ithebhu ethi "Yilwayo" okanye "Ufomatho".
- Khetha Isimbo: Khetha kwiintlobo ezahlukeneyo zokhetho lwesitayile esichazwe kwangaphambili okanye uhlengahlengise ngesandla imibala kunye neefomathi.
Ukongeza kunye nokususa izinto
Ukongeza okanye ukususa izinto ezifana imigca yereferensi, iintsomi, okanye iilebhile zedatha, landela la manyathelo:
- Khetha iTshati: Cofa kwigrafu.
- Yiya kwi-Design Tab: Khetha "Yongeza iNqaku yeTshati" kwithebhu ethi "Yilwayo".
- Khetha iNqanaba elifunekayo: Khetha uhlobo lwento ofuna ukuyongeza okanye ukuyisusa.
Ukuyila iitshathi ezinamandla
Las iitshathi eziguqukayo zihlaziywa ngokuzenzekelayo xa idatha esisiseko itshintsha. Ukwenza itshati yepivot:
- Khetha Idatha: Khetha uluhlu lwedatha.
- Faka iTheyibhile yePivot: Kwithebhu ethi "Faka", khetha "PivotTable."
- Yenza itshathi yePivot: Nje ukuba wenze itafile yakho yepivot, khetha u-"Faka iTshati yePivot" kwaye ukhethe uhlobo lwetshati olufunekayo.
IiNzuzo zeMfundo zeTshati ze-Excel
Ukusetyenziswa kwemizobo kwi iimeko zemfundo okanye iingcali zivumela ukuqonda okucacileyo kunye nokusebenza kakuhle kwedatha. Ngokusebenzisa ukubonakaliswa okubonakalayo, kunokwenzeka ukuchonga iipatheni, ukuthelekisa ubuninzi, kunye nokuqonda ubudlelwane phakathi kwezinto eziguquguqukayo nge-intuitively.
Izixhobo zeDijithali kunye neeNkxaso
Ukwandisa ukuphathwa kweetshathi kwi-Excel, kukho izixhobo zedijithali ezifana nezifundo kunye nezikhokelo. Umzekelo, Zoom Tutorials kunye namanye amaqonga ezemfundo anika iikhosi ezineenkcukacha.
Izicelo kuMmandla woBuchule
Kwintsimi yobuchwephesha, ukusetyenziswa okuchanekileyo kweetshathi ze-Excel kukhulisa umboniso we ingxelo kunye nohlalutyo lwedatha. Amacandelo afana nezezimali, ukuthengisa, kunye nolawulo lweprojekthi bayazuza ngakumbi ekusebenziseni ezi zixhobo.
I-Excel ayivumeli kuphela i ukudala kunye nokwenza ngokwezifiso yemizobo, kodwa ikwaququzelela i uhlalutyo olunzulu yedatha ngemisebenzi eyahlukeneyo ephucukileyo kunye ne-automations, isisixhobo esisisiseko kuhlalutyo lwedatha yanamhlanje.
Ukufumana iinkcukacha ezithe kratya kunye nezifundo kwi ukwenza iitshathi kwi-Excel, kucetyiswa ukuba uhlolisise indawo yakho esemthethweni kunye namanye amaqonga emfundo akhethekileyo.