Microsoft ipabole ke lenaneo le matla le le feto-fetohang le ka thusang basebelisi ho hlophisa, ho sekaseka le ho hlahisa lintlha tsa bona. Ke e 'ngoe ea li-program tsa spreadsheet tse tsebahalang haholo 'me e sebelisoa libakeng tse ngata tse fapaneng le ea liindasteri. Hore na u motho ea qalang kapa u mosebelisi ea tsoetseng pele, u ka rua molemo thupelong ea mahala ea ho ithuta ho sebelisa Excel le ho sebelisa likarolo tsa eona haholo. Sehloohong sena, re tla sheba likarolo tsa mantlha tsa Excel mme re u bolelle hore na u ka rua molemo joang ka koetliso ea mahala ea ho li tseba hantle.
Likarolo tse kholo tsa Excel
Excel e fana ka mefuta e mengata ea likarolo ho thusa basebelisi ho laola le ho sekaseka lintlha tsa bona. Likarolo tsa bohlokoa li kenyelletsa taolo ea data, lipalo le tlhahlobo ea data, lichate le litafole tsa pivot (DCTs).
- Tsamaiso ea data: Excel e lumella basebelisi ho hlophisa, ho hlophisa, ho sefa le ho hlophisa lintlha tsa bona. U ka boela ua kenya data ho tsoa mehloling e ka ntle le ho etsa liforomo ho bala lintlha.
- Palo le tlhahlobo: Excel e ka sebelisoa ho etsa lipalo le tlhahlobo e rarahaneng ho data ea hau. U ka sebelisa mesebetsi e hahelletsoeng ho etsa lipalo tsa lipalo-palo le tlhahlobo e tsoetseng pele ea data.
- Lits'oants'o: Excel e u lumella ho etsa lichate ho emela lintlha tsa hau ka pono. U ka khetha ho tsoa mefuteng e fapaneng ea lichate joalo ka lichate tsa li-bar, li-pie charts, likholomo le lichate tsa scatter.
- Litafole tsa Pivot: Li-PCT li u lumella ho sekaseka data kapele le ha bonolo. U ka etsa li-TCD ho hlahisa data litafoleng le lirapeng.
Ithute ho ipabola Excel
Ho na le mekhoa e mengata ea ho ithuta ho ipabola Excel. U ka fumana lithuto tsa mahala tsa marang-rang, litataiso tsa basebelisi le libuka tsa mosebelisi. U ka boela ua nka lithuto tse khethehileng kapa mananeo a ho ithuta hole.
- Lithupelo tsa mahala tsa Marang-rang: Lithupelo tsa Marang-rang li fana ka mokhoa o bonolo oa ho ithuta ho sebelisa Excel. U ka fumana lithuto tsa mahala liwebsaeteng tse kang YouTube kapa li-blog.
- Litaelo tsa Basebelisi: Litaelo tsa Basebelisi ke litokomane tse fanang ka lintlha tse qaqileng mabapi le likarolo le ts'ebeliso ea Excel. U ka fumana litataiso tsa basebelisi inthaneteng kapa mabenkeleng a likhomphutha.
- Libukana tsa mosebelisi: Libukana tsa mosebelisi ke mokhoa o motle oa ho ithuta ho sebelisa Excel. Ba fana ka lintlha tse qaqileng le tlhaloso ea tšobotsi ka 'ngoe. U ka fumana libuka tsa basebelisi Inthaneteng kapa mabenkeleng a lik'homphieutha.
- Lithuto tse khethehileng: Lithuto tse khethehileng ke mokhoa o motle oa ho ithuta ho sebelisa Excel. U ka fumana lithuto tse khethehileng inthaneteng le likolong tsa lehae. Litlelase li ka nka lihora tse 'maloa ho isa matsatsing a' maloa 'me li ka ba tsa mahala kapa tsa lefuoa.
- Ho ithuta hole: Ho ithuta hole ke mokhoa o mong o bonolo oa ho ithuta ho sebelisa Excel. U ka fumana lithuto tsa hole libakeng tsa marang-rang tse kang Udemy kapa li-platform tsa ho ithuta inthaneteng joalo ka Coursera.
Koetliso ea mahala ea Excel
Ho na le mekhoa e mengata ea ho fumana koetliso ea mahala ea Excel. U ka fumana lithupelo tsa mahala, libuka le lithuto tsa inthaneteng tse tla u thusa ho tseba lenaneo.
- Lithuto tsa mahala: Lithupelo tsa Marang-rang li fana ka mokhoa o bonolo le o sa lefelloeng oa ho ithuta ho sebelisa Excel. U ka fumana lithuto tsa mahala liwebsaeteng tse kang YouTube kapa li-blog.
- Libuka tsa mahala: Ho na le libuka tse ngata tsa mahala tse tla u thusa ho ithuta ho sebelisa Excel. U ka li fumana liwebsaeteng tse kang Amazon kapa li-platform tsa khatiso tse kang Leanpub.
- Lithuto tsa mahala tsa inthanete: Lithuto tsa mahala tsa inthanete ke mokhoa o motle oa ho ithuta ho ipabola Excel. U ka fumana lithuto tsa mahala tsa marang-rang libakeng tse kang Udemy, edX, le Coursera.
fihlela qeto e
Microsoft Excel ke lenaneo le matla le le feto-fetohang le ka thusang basebelisi ho hlophisa, ho sekaseka le ho hlahisa lintlha tsa bona. Ka lehlohonolo, ho na le mekhoa e mengata ea ho fumana koetliso ea mahala ea Excel. U ka fumana lithupelo tsa inthaneteng, libuka tsa mahala, le lithuto tsa mahala tsa inthanete tse tla u thusa ho tseba lenaneo.
