Mokhoa oa ho theha Chate ea Mokhoa ho Excel

Li-graph tsa Trend ke lisebelisoa tsa bohlokoa tlhahlobong ea data, kaha li u lumella ho bona ka nepo le ho utloisisa phetoho ea sete ea data ka nako. Ho Excel, e 'ngoe ea likopo tse sebelisoang haholo khoebong le lithutong, ho theha kerafo ke mosebetsi o bonolo empa o bohlokoa ho mang kapa mang ea batlang ho hlahisa le ho sekaseka data. ka katlehoSehloohong sena, re tla ithuta mohato ka mohato mokhoa oa ho theha chate ea feshene ho Excel, u sebelisa mesebetsi le likarolo tse nepahetseng tsa sesebelisoa sena.

1. Kenyelletso ea ho theha lichate tse tloaelehileng ho Excel

Ho theha lichate tsa tloaelo ho Excel ke sesebelisoa se sebetsang haholo sa ho sekaseka le ho bona data ka mahlo. Ka ho sebelisa tšobotsi ena, o ka tseba lipaterone, oa bona mekhoa, 'me oa etsa ponelopele ho latela lintlha tsa nalane. Sehloohong sena, re tla u fa tataiso ea mohato ka mohato mabapi le mokhoa oa ho theha le ho etsa lichate tse tloaelehileng ho Excel e le hore u ka sebelisa monyetla ona ka botlalo le ho etsa liqeto tse nepahetseng.

Pele o qala ho theha lichate tsa hau tse tloaelehileng, ho bohlokoa ho etsa bonnete ba hore o na le data e nepahetseng bakeng sa tlhahlobo ea hau. O ka kenya data ho tsoa mehloling e fapaneng ho Excel, joalo ka lifaele tsa CSV, datha, kapa oa etsa pokello ea matsoho. Hang ha data ea hau e se e loketse, u ka tsoela pele ho latela mehato ena:

• Khetha data eo u batlang ho e hlahloba. Sena se kenyelletsa likholomo tse nang le boleng ba mefuta e ikemetseng (mohlala, nako) le mefuta e itšetlehileng ka eona (mohlala, theko).
• Eya ho tab ya "Insert". sesebelisoa sa lisebelisoa Excel 'me u khethe mofuta oa chate eo u batlang ho e theha, joalo ka chate ea mela kapa chate e hasaneng.
• Fetosa sebopeho sa chate le likhetho tsa ho fometa ho latela khetho ea hau. U ka hlophisa sehlooho, lilepe, tšōmo 'me u sebelise mekhoa e fapaneng ea pono ho totobatsa lintlha.
• Ha u se u qetile ho itlhophisa, u ka hlahlobisisa graph ea sejoale-joale ho bona lipaterone, mekhoa, kapa liphapang ho data ea hau. U ka sebelisa mekhoa ea lipalo ho fumana metrics le likhakanyo tse nepahetseng haholoanyane.

Ho theha lichate tse tloaelehileng ho Excel ke sesebelisoa se matla ho sekaseka data le ho etsa liqeto tse nang le tsebo. Ka thuto ena ea mohato ka mohato, u tla khona ho hlahisa litšoantšo tse felletseng, tse ikhethileng ka ho penya ho se kae feela. Hopola hore senotlolo sa ho fumana liphetho tse ntle ke ho ba le data ea boleng le ho sebelisa lisebelisoa le likhetho tsa ho iketsetsa tseo Excel e fanang ka tsona.

2. Mehato ea pele ea ho theha chate e tloaelehileng ho Excel

Ka tlase ke mehato ea pele e hlokahalang ho theha chate e tloaelehileng ho Excel:

1. Bokella le ho hlophisa lintlha: Pele o theha chate e tloaelehileng ho Excel, ho bohlokoa ho bokella le ho hlophisa lintlha tse nepahetseng. Etsa bonnete ba hore data e ka sebopeho se nepahetseng, joalo ka tafole e nang le likholomo bakeng sa mofuta o mong le o mong le mela bakeng sa ntlha ka 'ngoe ea data. Hape, etsa bonnete ba hore data e hlophisitsoe hantle 'me e ngotsoe.

2. Bula Excel 'me u khethe data: E butsoe Microsoft Excel ebe u khetha data eo u batlang ho e kenyelletsa ho graph ea mekhoa. U ka khetha data ka ho tobetsa le ho hulela cursor holim'a eona kapa ka ho sebelisa sekhechana sa keyboard ea Shift + Arrow. Etsa bonnete ba hore o kenyelletsa lintlha tsohle tse amehang le lintlha tsa data.

3. Kenya kerafo e tloaelehileng: Hang ha data e se e khethiloe, e-ea ho "Insert" tab ea riboneng ea Excel 'me u khethe mofuta oa chate eo u batlang ho e sebelisa. O ka khetha ho tsoa mefuteng e mengata ea lichate, joalo ka lichate tsa mela, scatter chart, kapa sebaka. Kamora ho khetha mofuta oa chate, Excel e tla iketsetsa chate ea pele e ipapisitseng le data e khethiloeng. U ka etsa chate ka ho kenyelletsa litlotla, lileibole le likarolo tse ling tsa litšoantšo ho latela litlhoko tsa hau.

3. Khetho ea data le tlhophiso bakeng sa kerafo ea tloaelo ho Excel

Ho theha chate e tloaelehileng ho Excel, ho bohlokoa ho khetha data e nepahetseng le ho e hlophisa ka nepo. U sebelisa ts'ebetso ena ea Excel, u tla khona ho bona ka ho hlaka le ka bokhuts'oane mekhoa le lipaterone ho data ea hau. E latelang, re tla u bontša mokhoa oa ho etsa ts'ebetso ena mohato ka mohato:

1. Khetha lintlha tse amehang: Pele u qala, etsa bonnete ba hore u na le lintlha tse hlokahalang bakeng sa ho theha graph ea mekhoa. Mokhoa o motle ke ho kenyelletsa litšiea tse peli, e 'ngoe bakeng sa x-axis (mohlala, nako) le e' ngoe bakeng sa y-axis (litekanyetso tseo u batlang ho li emela). Ke habohlokoa hore data e hloeke ebile e se na lisele tse se nang letho kapa tlhahisoleseding e sa lokelang.

2. Khetha mofuta o nepahetseng oa chate: Ho Excel, ho na le mefuta e sa tšoaneng ea lichate tse fumanehang, tse kang mela, scatter, columns, har'a tse ling. Ho khetha mofuta o nepahetseng ka ho fetesisa, nahana ka mofuta oa data ea hau le liphetho tseo u batlang ho li fumana. Ka mohlala, haeba u batla ho bontša kamano pakeng tsa mefuta e 'meli, morero oa ho hasanya o tla ba o loketseng haholoanyane. Leka ka mefuta e fapaneng ho fumana e emelang data ea hau hantle.

4. Ho fometa data bakeng sa kerafo ea tloaelo ho Excel

5. Ho theha Sesebelisoa sa Chate ea Trend ho Excel

Ho theha sesebelisoa sa chate ea feshene ho Excel, latela mehato ena:

1. Bula faele ea Excel moo u batlang ho eketsa chate ea mekhoa.
2. Khetha lintlha tseo u batlang ho li kenyelletsa ho graph graph.
3. Tobetsa tab ea "Insert" ho ribone ea Excel.
4. Sehlopheng sa “Lichate,” tobetsa konopo ea “Chate” ebe u khetha mofuta oa chate o loketseng litlhoko tsa hao hantle, tse kang “Mola” kapa “Scatter.”
5. Chate ea mekhoa e tla eketsoa faeleng ea Excel mme e bonts'itsoe leqepheng la mosebetsi.

Hang ha chate ea mekhoa e se e le teng, u ka e etsa ka mokhoa o ikhethileng hore e lumellane le litlhoko tsa hau. Ka tlase ho na le likhetho le likarolo tse ling ho ntlafatsa chate ea hau:

• Ho fetola sehlooho sa chate, e tobetse habeli ebe u ngola sehlooho se hlalosang.
• Ho kenya lileibole tsa data lethathamong la data, tlanya ka ho le letona chate ebe u khetha "Eketsa lileibole tsa data."
• Haeba u batla ho fetola mokhoa oa chate, tobetsa ka ho le letona ho chate ebe u khetha "Fetola Mofuta oa Chate."
• Ho lokisa mefuta e fapaneng ea lilepe, tobetsa ka ho le letona ho chate ebe u khetha "Fetola Lilepe".

Hopola hore o ka etsa liteko ka mefuta e fapaneng ea lichate tsa feshene, mekhoa le likhetho tsa ho fometa ho latela litlhoko tsa hau. Ikutloe u lokolohile ho hlahloba le ho sebelisa lisebelisoa tsena tse matla ho bona ka mahlo a kelello lintlha tsa hau ka katleho ho Excel!

6. Ho Khetha Mofuta oa Chate e nepahetseng ho Excel

E 'ngoe ea lintlha tsa bohlokoa ka ho fetisisa tseo u lokelang ho li hopola ha u sebetsa le data ho Excel ke ho khetha mofuta o nepahetseng oa chate. Kemiso ea setšoantšo ke setšoantšo se bonts'ang kamano pakeng tsa mefuta e 'meli ka nako. E thusa haholo ho tsebahatsa lipaterone, mekhoa le likhakanyo tsa nako e tlang. Ka tlase ke mehato ea ho khetha mofuta o nepahetseng oa chate ho Excel.

1. Sekaseka lintlha tsa hau: Pele u khetha mofuta oa chate e tloaelehileng ho Excel, ho bohlokoa ho utloisisa lintlha tsa hau le kamano pakeng tsa mefuta-futa. Sekaseka mofuta oa data ea hau 'me u bone hore na u na le data e tsoelang pele kapa e hlakileng. Ho feta moo, tseba hore na u na le phapang e le 'ngoe e ikemetseng kapa mefuta e mengata.

2. Hlahloba likhetho tse teng tsa lichate: Excel e fana ka mefuta e mengata ea mekhoa ea mekhoa e metle, e kang mela, mekoallo, libaka le ho hasana. Mofuta o mong le o mong oa chate o na le litšobotsi tsa oona 'me o loketse ka ho fetisisa mefuta e fapaneng ea data. Batlisisa likhetho tse fumanehang 'me u itloaetse litšobotsi tsa mofuta o mong le o mong oa chate.

3. Khetha chate e nepahetseng: Hang ha u se u hlahlobile lintlha tsa hau le ho hlahloba likhetho tsa chate, khetha mofuta oa chate e lumellanang hantle le litlhoko tsa hau. Nahana ka ho hlaka ha pono, bonolo ba ho hlalosa, le bokhoni ba ho bontša kamano pakeng tsa mefuta-futa ka katleho. Hopola hore o ka leka likhetho tse fapaneng mme o lokisa li-setting tsa chate ho Excel ho fumana sephetho se lakatsehang.

Ho khetha mofuta o nepahetseng oa chate ho Excel ho bohlokoa ho hlahisa lintlha tsa hau ka mokhoa o hlakileng le ka katleho. Latela mehato ena 'me u nke monyetla oa lisebelisoa tse fumanehang ho Excel ho khetha chate e nepahetseng ka ho fetisisa bakeng sa data ea hau. Ikutloe u lokolohile ho sebelisa lithupelo le mehlala e le tataiso 'me u hopole hore u ka khona ho fetola le ho hlophisa lichate tsa hau ho fumana liphetho tse ntle ka ho fetisisa.

7. Ho itloaetsa le moralo oa kerafo ea tloaelo ho Excel

Ho Excel, o na le likhetho tse 'maloa tsa ho etsa le ho rala kerafo ea data ea hau. Sesebelisoa sena se u lumella ho bona ka ho hlaka le ka bokhuts'oane ho fetoha ha litekanyetso tsa hau ha nako e ntse e ea. Ka mor'a moo, re tla hlalosa mokhoa oa ho etsa tlhophiso le moralo ona ka mehato e seng mekae e bonolo.

1. Khetha data eo u batlang ho e graph. U ka e etsa ka ho toba ho spreadsheet kapa tafoleng e ka ntle. Etsa bonnete ba hore o kenyelletsa matsatsi le boleng bo lumellanang likholomong tse haufi.

2. Hang ha data e khethiloe, e-ea tabeng ea "Insert" ka har'a toolbar ea Excel 'me u tobetse ho "Line Chart" kapa "Scatter Chart". Mefuta ena ea lichate e atisa ho sebelisoa ho emela mekhoa.

3. Ka chate e entsoeng, u ka qala ho e etsa. Tobetsa chate ka ho le letona ebe u khetha "Likhetho tsa Format" ho fihlella menyetla e mengata ea meralo. Mona o ka fetola likarolo tse kang mebala, fonte, lihlooho, lilepe le tse ling tse ngata. Hopola hore, ho ipapisitse le litlhoko tsa hau, u ka theha maikutlo a fapaneng le likhetho tsa moralo ho ikamahanya le setaele kapa tlhahiso ea hau.

Seke oa tsilatsila ho hlahloba likhetho tsohle tseo Excel e u fang tsona ho etsa le ho rala kerafo ea data ea hau. Hopola hore ha o ntse o ikoetlisa le ho hlahloba lisebelisoa le mesebetsi e fapaneng, o tla ntlafatsa tsebo ea hau mme o tsebe ho theha lipono tse sebetsang hantle le tse khahlang. Leka mekhoa e fapaneng, mebala, le lileibole ho fumana motsoako o phethahetseng o thusang ho fetisa molaetsa oa hau ka katleho. Natefeloa ke ho leka lichate tsa hau tsa Excel!

8. Fetola Lilepe le Likhetho tsa Label bakeng sa Trend Chart ho Excel

Ho Excel, ho lokisa li-axis le likhetho tsa li-label bakeng sa chate ea mekhoa ho etsa hore ho be bonolo ho hlalosa lintlha le ho ntlafatsa tlhahiso ea pono ea chate. Ho etsa litlhophiso tsena, latela mehato ena:

1. Khetha chate ea mekhoa eo u batlang ho sebelisa liphetoho ho eona. U ka tobetsa ka ho toba graph ho e khetha.

2. Tobetsa ka ho le letona chate ebe u khetha khetho ea "Format Axis" ho tsoa ho menu e theoha. Sena se tla bula phanele ea Likhetho tsa Axes Format.

3. Ka phanele ea likhetho tsa sebopeho sa axis, u tla fumana li-tab tse fapaneng ho hlophisa likhetho tsa axis le label. O ka fetola mefuta e mengata ea lilepe, oa fetola mokhoa oa li-label, oa etsa mokhoa oa ho etsa palo, le tse ling tse ngata.

4. Ho lokisa mefuta e mengata ea li-axis, khetha "Axis" tab 'me u tsamaise ho fihlela u fumana likhetho tsa "Axis Range". Mona o ka hlakisa bonyane le boleng bo phahameng boo u batlang ho bo bontša chate. Ntle le moo, o ka fetola sekala sa axis haeba o hloka.

5. Ho iketsetsa li-label tsa axis, khetha "Axis Labels" tab. Mona o ka fetola sebopeho sa linomoro, joalo ka palo ea libaka tsa decimal, mokhoa oa fonte, boholo le boemo ba lileibole.

Hopola hore tsena ke litlhophiso tsa mantlha tseo u ka li etsang ho Excel ho etsa lilepe le lileibole tsa chate e tloaelehileng. Excel e fana ka mefuta e mengata ea likhetho tsa ho fometa tse u lumellang hore u hlophise chate ho latela litlhoko tsa hau tse ikhethileng. Leka ka likhetho tse fapaneng 'me u sebelise lisebelisoa tse teng ho fihlela tlhahiso ea pono e lakatsehang. Ikutloe u lokolohile ho sheba lithuto le mehlala bakeng sa mehopolo le malebela a ho lokisa lilepe le lileibole ho Excel!

9. Tlhaloso le tlhahlobo ea liphello tsa kerafo ea mekhoa ho Excel

Chate ea maemo ho Excel ke sesebelisoa se matla sa ho toloka le ho sekaseka data. Chate ena e bonts'a tataiso e akaretsang ea lintlha ka nako e itseng 'me e thusa ho tseba mekhoa le mekhoa. Karolong ena, ke tla u tataisa mabapi le mokhoa oa ho fetolela le ho sekaseka liphetho tsa kerafo ea tloaelo ho Excel.

Mohato oa pele oa ho hlalosa chate ea mekhoa ke ho hlahloba tataiso ea mola. Mohala o nyolohang o bontša ho eketseha ha data ka nako, ha moeli o theoha o bontša ho fokotseha. Haeba mohala o otlolohile, ho bolela hore ha ho na liphetoho tse kholo ho data.

Ho phaella ho tataiso ea mola, ke habohlokoa ho hlahloba letsoapo la mola. Moepa o moepa o bontša phetoho e potlakileng kapa e matla ea data, athe moepa o motle o bontša phetoho butle-butle. Ha u khetha moepa, ho bohlokoa ho nahana ka mefuta e mengata ea boleng ho y-axis, kaha letsoapo le lenyenyane holim'a mefuta e mengata e ka bonts'a phetoho e kholo.

10. Ho ntlafatsa le ho fetola kerafo ea mekhoa ho Excel

E ka etsoa habonolo ka ho latela mehato e meng ea bohlokoa. Taba ea pele, ho bohlokoa ho etsa bonnete ba hore data ea hau e nchafalitsoe ebile e hlophisitsoe ka har'a tafole ea Excel. Ka mor'a moo, khetha data eo u batlang ho e kenyelletsa chate ebe u tobetsa "Insert" tab ea top toolbar.

Hang ha u le tabeng ea "Insert", u ka khetha mofuta oa chate e loketseng litlhoko tsa hau, joalo ka mola, bar, kapa lichate tsa sebaka. Ka mor'a ho khetha mofuta oa chate, u ka e fetola ka ho tobetsa ka ho le letona linthong tse fapaneng tsa lichate, tse kang li-axis kapa legend, 'me u lokise thepa ea tsona ha ho hlokahala.

Ho feta moo, Excel e fana ka mefuta e mengata ea likhetho tsa ho fomata ho etsa hore chate ea hau e be le tšusumetso e matla le ho e utloisisa habonolo. O ka fetola mebala, oa eketsa litlotla le lileibole, oa sebelisa mekhoa e boletsoeng esale pele, le tse ling tse ngata. Hopola hore u ka lula u etsa liphetoho tse ling ka nako efe kapa efe, ka ho khetha chate le ho sebelisa lisebelisoa tsa ho fometa tse fumanehang ho "Design" kapa "Format" tab ea toolbar.

11. Malebela le maqheka a ho ntlafatsa tlhahiso ea kerafo ea mokhoa ho Excel

Ho fana ka tlhahisoleseding ka tsela e hlakileng le e ipiletsang ka tsela e bonahalang ke ea bohlokoa tlhahisong leha e le efe, 'me lichate tsa mekhoa ea Excel ke sesebelisoa sa bohlokoa sa ho finyella sena. Mona re u fa tse ling malebela le maqheka Ho ntlafatsa tlhahiso ea litšoantšo tsena le ho li etsa hore li hlahelle:

1. Khetha lintlha tse nepahetseng: Pele u theha graph ea hau ea tloaelo, ho bohlokoa ho khetha ka hloko data eo u batlang ho e emela. Khetha likholomo kapa mela e bonts'ang hantle lintlha tseo u batlang ho li hlahisa 'me u tlose lintlha tse sa hlokahaleng.
2. Khetha mofuta o nepahetseng oa chate: Excel e fana ka lichate tse fapaneng tse fapaneng, joalo ka mela, litšiea, mekoallo kapa lichate tsa sebaka. Khetha mofuta oa graph o lumellanang hantle le data ea hau le molaetsa oo u batlang ho o fetisa. Hopola hore kerafo e bonolo le e bonolo ho e toloka hangata e sebetsa haholoanyane.
3. Hlophisa chate 'me u iketsetse eona: Nka monyetla ka lisebelisoa tsa Excel tsa ho fometa le ho li etsa ka mokhoa o ikhethileng ho ntlafatsa chebahalo ea chate ea hau. U ka fetola mebala, eketsa litlotla, lileibole le litšōmo, fetola lilepe le ho fetola sekala. Hopola hore tlhahiso e ntle ea pono e ka etsa phapang ea ho fetisa molaetsa oa hau ka katleho.

Malebela ana Li tla u thusa ho ntlafatsa tlhahiso ea lichate tsa hau tse tloaelehileng ho Excel le ho etsa hore li khahle le ho feta ho li utloisisa habonolo. Hopola ho leka mekhoa e fapaneng le likhetho tsa ho fometa ho fumana mokhoa o motle oa ho bonts'a data ea hau. Seke oa tsilatsila ho li sebelisa 'me u makatse bamameli ba hau ka litšoantšo tsa profeshenale le tse khahlang!

12. Ho rarolla mathata a tloaelehileng ha ho etsoa chate ea mekhoa ho Excel

Ha u theha chate e tloaelehileng ho Excel, ho tloaelehile ho tobana le mathata a ka etsang hore ts'ebetso e be thata. Ka lehlohonolo, ho na le tharollo e sebetsang mathateng ana a tla u thusa ho fihlela liphetho tse lakatsehang habonolo. Mona ke tse ling tsa litharollo tsa bohlokoa mathateng a atileng haholo ha u theha chate ea maemo ho Excel.

1. Lintlha tse fosahetseng: Etsa bonnete ba hore data eo u e sebelisang e nepahetse ebile e hlophisitsoe hantle. Hlahloba hore na lisele li tlatsitsoe ka linomoro kapa boleng bo nepahetseng le hore na ha ho na liphoso tsa ho fomata. Sebelisa mesebetsi e nepahetseng ea Excel ho etsa lipalo le ho hlophisa lintlha tsa hau ka katleho.

2. Khetho e fosahetseng ea chate: Ha u theha chate e tloaelehileng ho Excel, mofuta oa chate o khethiloeng e ka 'na ea se ke ea e-ba o loketseng ka ho fetisisa bakeng sa lintlha tseo u batlang ho li emela. Etsa bonnete ba hore u utloisisa sepheo sa chate ea hau le likhetho tse fapaneng tsa lichate tse fumanehang ho Excel. Leka ka mefuta e fapaneng ea lichate (joalo ka mela, mekoallo, kapa scatter) ho fumana e lumellanang hantle le litlhoko tsa hau.

13. Reka ntle le ho tlisa kerafo ea sejoale-joale ho Excel ho lifomete tse ling

Ho romela kantle ho naha le ho kenya chate ea sejoale-joale ho Excel ho lifomate tse ling, ho na le likhetho tse 'maloa tse fumanehang tse tla u lumella ho arolelana le ho sebelisa data ka tsela e fapaneng. Ka mor'a moo, re tla u bontša mekhoa e meraro e fapaneng ea ho e etsa:

1. Boloka e le Setšoantšo: Tsela e bonolo ea ho romela lichate tse tloaelehileng ke ho li boloka e le setšoantšo. Ho etsa sena, khetha chate ebe o tobetsa ho eona ka ho le letona. Ebe, khetha khetho ea "Boloka e le" 'me u khethe sebopeho sa setšoantšo seo u se ratang, joalo ka PNG kapa JPEG. Khetho ena e na le thuso haeba u batla ho kenya chate tokomaneng ea mongolo kapa ho e arolelana inthaneteng.

2. Kopitsa le ho manamisa lits'ebetsong tse ling: Mokhoa o mong o potlakileng oa ho romella chate e tloaelehileng ke ho e kopitsa le ho e manamisa lits'ebetsong tse ling, joalo ka Word kapa PowerPoint. Ho etsa sena, khetha chate ebe o tobetsa linotlolo "Ctrl + C" ho keyboard ea hau ho e kopitsa. Ebe u bula sesebelisoa seo u batlang ho beha chate ho sona ebe u tobetsa linotlolo tsa "Ctrl + V" ho e beha. Khetho ena e u lumella ho sebelisa setšoantšo ho mananeo a fapaneng ntle le ho boloka setšoantšo se arohaneng.

3. Boloka Joalo ka Faele ea PDF- Haeba o hloka ho boloka boleng le sebopeho sa chate ea feshene, o ka boloka faele ea Excel joalo ka Tokomane ea PDF. Ho etsa sena, e ea ho "File" ho Excel 'me u khethe khetho ea "Save As". Ebe u khetha "PDF" joalo ka sebopeho sa faele ebe u boloka tokomane sebakeng seo u se batlang. Ka ho boloka faele e le PDF, u ka e arolelana le ho e shebella lisebelisoa tse fapaneng ntle le ho lahleheloa ke boleng.

14. Liqeto le lintlha tsa ho qetela mabapi le ho theha lichate tsa maemo ho Excel

Ka kakaretso, ho theha lichate tse tloaelehileng ho Excel e ka ba mosebetsi o bonolo le o sebetsang haeba mehato e nepahetseng e lateloa. Sengoliloeng sena re hlahlobile likhetho tse fapaneng tseo Excel e fanang ka tsona bakeng sa ho emela lintlha ho lichate tsa feshene mme re fane ka thuto e felletseng ea ho sebelisa likarolo tsena.

Ho bohlokoa ho hlokomela hore senotlolo sa ho theha lichate tse sebetsang hantle ho Excel ke khetho e nepahetseng le tlhophiso ea data. Pele o qala ho theha chate ea hau, ho bohlokoa ho netefatsa hore data ea hau e hlophisitsoe hantle le hore u khethile mofuta o nepahetseng oa chate ho emela mokhoa o ikhethileng oo u batlang ho o bontša.

Ho feta moo, re arolelane malebela a bohlokoa a ho ntlafatsa tlhahiso ea kerafo ea hau, joalo ka ho sebelisa lifomate le mekhoa e nepahetseng, ho kenyeletsoa lileibole tse hlalosang, le ho khetha mebala e fapaneng. Mekhoa ena e ka thusa ho totobatsa se etsahalang le ho etsa hore data e be bonolo ho e hlalosa le ho e sekaseka.

Qetellong, ho theha chate ea maemo ho Excel ke sesebelisoa sa bohlokoa sa ho sekaseka le ho bona sete ea data ka nako. Ka thuso ea likarolo tse hahelletsoeng ka har'a Excel tse kang tlhahlobo ea data le charting, hoa khoneha ho tseba mekhoa, ho lekola kholo kapa ho fokotseha ha lintho tse fapaneng, le ho etsa likhakanyo tsa nako e tlang.

Ka ho tseba mehato e boletsoeng sehloohong sena, u tla khona ho hlahisa lichate tsa mekhoa ea tsela e sebetsang hantle le ho nepahala. Ka ho latela mokhoa oa mokhoa le ho etsa bonnete ba ho khetha litlhophiso tse nepahetseng ha ho etsoa kerafo, u tla khona ho fumana lintlha tsa bohlokoa bakeng sa ho etsa liqeto.

Hopola hore tlhahlobo ea mekhoa ke ts'ebetso ea bohlokoa libakeng tse ngata, joalo ka khoebo, lichelete, papatso le mahlale a data. Ka hona, bokhoni ba ho theha le ho utloisisa lichate tse tloaelehileng ho Excel bo ka ba molemo haholo bophelong ba hau ba botsebi kapa ba thuto.

Ka bokhutšoanyane, ho tseba ho theha lichate tse tloaelehileng ho Excel ho tla u lumella ho fetola data hore e be tlhahisoleseling e nang le moelelo, e ipiletsang ka pono. Ka ho nka monyetla ka bokhoni ba Excel ba tlhahlobo ea data le ho sebelisa lits'ebetso ka nepo, u tla khona ho etsa liqeto tse nang le tsebo le ho hlahisa liphetho tsa hau ka mokhoa o hlakileng le ka bokhuts'oane. Ka boitlhakiso le boinehelo, u tla itokisetsa ho tobana le phephetso efe kapa efe eo tlhahlobo ea mekhoa e e hlokang nakong e tlang.