Kenyelletso ea "Mokhoa oa ho etsa Lenane le theohang ho Excel"
Las listas ho theoha ho Excel Ke sesebelisoa se sebetsang haholo sa ho hlophisa le ho sefa data ka katleho. Haeba u hloka ho theha lethathamo la li-dropdown ho li-spreadsheet tsa hau, u sebakeng se nepahetseng.
Sehloohong sena, ke tla u tataisa mohato ka mohato Ka ts'ebetso ho theha lethathamo la litheolelo ho Excel. Ho tloha ho lokisa lintlha ho isa ho kenya ts'ebetsong lenane ho spreadsheet ea hau, u tla fumana litaelo tsohle tse hlokahalang ho phethela ts'ebetso ena ka katleho.
Hore na o ncha ho Excel kapa o se o ntse o na le boiphihlelo ka sethala, tataiso ena ea tekheniki e tla u thusa ho tseba manane a theoha le ho sebelisa ts'ebetso ea ona hantle.
Kahoo ntle le ho feta, a re qaleng ho ithuta ho etsa lenane le theoha ho Excel le mokhoa oa ho le sebelisa litlhoko tsa hau tse ikhethileng. Ha re kenelle lefatšeng le letle la li-spreadsheet le manane a theoha!
1. Kenyelletso ea manane a theohang ho Excel
Manane a theohang ho Excel ke sesebelisoa se molemo haholo se re lumellang ho khetha boleng ka potlako lethathamong le boletsoeng esale pele. Manane ana a hlahisoa ka boiketsetso ha re tobetsa sele e tsamaellanang le ho re lumella ho khetha khetho kapele le ha bonolo. Sehloohong sena, re tla u bontša mokhoa oa ho sebelisa manane a theoha ho Excel, mohato ka mohato.
Ho theha lenane la ho theoha ho Excel, re tlameha ho qala ka ho hlalosa lenane la likhetho tseo re batlang ho li hlahisa. Ho etsa sena, re ka sebelisa kholomo kapa mola holim'a lakane ea ho bala. Ha re se re hlalositse lethathamo la rona la likhetho, re ka latela mehato e latelang:
- Khetha sele kapa mefuta ea lisele moo u batlang hore lethathamo la litheolelo le hlahe.
- Eya ho tab ya "Data". sesebelisoa sa lisebelisoa Excel, ebe o tobetsa konopo ea "Data Validation".
- Ka fensetere e butsoeng, khetha "Litlhophiso" ebe u khetha "List" karolong ea "Lumella".
- Karolong ea "Origin", o tlameha ho kenya tšupiso ea lenane la likhetho. Mohlala, haeba lenane la hau le le kholomong A, o ka kenya "A1:A10" joalo ka mohloli.
- Tobetsa "Ho lokile" 'me u tla bona hore joale u na le lenane le theoha ka seleng kapa mefuta ea sele e khethiloeng.
Ha u se u thehile lethathamo la li-dropdown ho Excel, u ka le etsa ka mokhoa o ikhethileng. Mohlala, o ka hlakisa hore na u lumella litekanyetso tsa moetlo hore li kenngoe kapa hore na u batla hore ho khethoe boleng feela lethathamong. U ka boela ua kenya melaetsa le melaetsa ea liphoso ho fana ka tlhahisoleseding e eketsehileng ho mosebedisi. Lekola likhetho tse fapaneng tsa ho itlhophisa ho ikamahanya le manane a theoha ho latela litlhoko tsa hau.
2. Mehato ea ho theha lenane le theoha ho Excel
Haeba u batla ho theha lenane le theoha ho Excel, latela mehato ena e bonolo:
Mohato oa 1: Bula Excel ebe u khetha sele eo u batlang ho kenya lenane la ho theoha ho eona.
- Haeba u batla feela lethathamo la ho theoha le nang le likhetho tsa kamehla, khetha sele e se nang letho.
- Haeba u batla lenane la ho theoha le nang le likhetho tse thehiloeng ho mofuta o teng, khetha sele moo sebaka se leng teng.
Mohato oa 2: Eya ho "Data" ka holimo ho fensetere ea Excel.
- Tobetsa konopo ea "Data Validation" sehlopheng sa "Data Tools".
Mohato oa 3: Ka fensetere ea pop-up ea "Data Validation Settings", khetha "Settings" tab.
- Karolong ea "Lumella", khetha "List" ho tsoa ho menu e theoha.
- Lebaleng la "Mohloli", kenya litekanyetso tse arotsoeng ke lifeeloana ho theha lenane le theoha.
- Haeba u batla ho sebelisa mofuta o teng e le mohloli, u ka etsa joalo ka ho kenya mofuta o lumellanang.
3. Ho sebelisa khetho ea netefatso ea data ho Excel
La validación de data ho Excel ke ts'ebetso e sebetsang haholo e u lumellang ho hlalosa melao le lithibelo tse lokelang ho finyelloa ha u kenya data ka har'a sele kapa marang-rang. Karolo ena e re thusa ho thibela le ho lokisa liphoso tsa ho kena, hammoho le ho netefatsa bonnete ba litaba tse ho li-spreadsheet tsa rona.
Ho sebelisa khetho ea netefatso ea data ho Excel, re tlameha ho latela mehato ena:
1. Khetha sele kapa mofuta oa lisele tseo u batlang ho sebelisa netefatso ea data ho tsona.
2. Eya ho "Data" tab ya ho Excel toolbar.
3. Tobetsa konopo ea "Data Validation" sehlopheng sa "Data Tools".
Ka mor'a moo, lebokose la "Tiiso ea Boitsebiso" le tla bula moo u ka lokisang melao le lithibelo bakeng sa data e kentsoeng. Likhetho tse fapaneng li teng, joalo ka linomoro tse netefatsang, matsatsi, mongolo kapa manane a ikhethileng. U ka boela ua beha meeli ea linomoro, bolelele ba mongolo, bonyane le boleng bo phahameng, har'a likhetho tse ling.
Hang ha u se u lokiselitse melao ea ho netefatsa lintlha, u tla khona ho bona phello ea bona ha u leka ho kenya data e sa finyelle maemo a behiloeng. Haeba data e fosahetse, Excel e tla hlahisa molaetsa oa phoso o bontšang hore na ke molao ofe o robiloeng. Sena se thusa basebelisi ho utloisisa le ho lokisa liphoso kapele le ha bonolo. Hopola hore khetho ea netefatso ea data ho Excel ke sesebelisoa se matla sa ho ntlafatsa boleng ba li-spreadsheet tsa hau le ho netefatsa botsitso ba tlhahisoleseling e kentsoeng.
4. Ho theha lethathamo la tloaelo bakeng sa lenane le theoha
Ho theha lethathamo la tloaelo bakeng sa lenane le theoha, ho na le likhetho tse 'maloa tse fumanehang. Tsela e 'ngoe ke ho iketsetsa lenane ka letsoho ho sebelisa HTML le CSS. O ka etsa element
Kgetho e 'ngoe ke ho sebelisa laeborari ea JavaScript, joalo ka jQuery kapa React, ho theha lethathamo la litheolelo tse tloaelehileng. Lilaebrari tsena li fana ka mesebetsi le mekhoa e etsang hore ho be bonolo ho theha manane a theolelang, a tloaelehileng. U ka batla lithupelo le mehlala inthaneteng ho ithuta ho kenya lilaebrari tsena ts'ebetsong.
Hang ha u se u thehile lenane la tloaelo bakeng sa lenane le theoha, u ka eketsa mekhoa e meng ea CSS ho iketsetsa ponahalo ea eona. O ka fetola boholo, 'mala oa bokamorao, mofuta oa fonte le litšobotsi tse ling ho tsamaisana le moralo oa hau websaete. Hopola ho lekola lenane le theoha ho libatli le lisebelisoa tse fapaneng ho etsa bonnete ba hore le hlaha ka nepo.
5. Ho beha likhetho tsa lenane la ho theoha ho Excel
Ha re sebetsa ka manane a theohang ho Excel, re ka hlophisa likhetho tse fapaneng ho li fetola ho latela litlhoko tsa rona. Ka tlase, ke tla hlalosa mohato ka mohato mokhoa oa ho hlophisa likhetho tsena le ho eketsa ts'ebetso ea tsona.
Taba ea pele, khetha sele eo u batlang ho kenya lenane la li-dropdown. Ebe u ea ho "Data" ho toolbar ea Excel. Tobetsa "Netefatso ea data" 'me fensetere ea pop-up e tla buleha. Ka fensetereng ena, khetha "Litlhophiso" ebe u khetha "List" karolong ea "Lumella".
Joale, ke nako ea ho hlalosa boleng ba lenane le theoha. U ka kenya litekanyetso ka letsoho tšimong ea "Mohloli", u li arola ka li-commas. Mohlala, haeba u batla ho theha lenane la litheolelo le nang le mabitso a likhoeli tsa selemo, u ka kenya "Pherekhong, Hlakola, Hlakubele, Mmesa, Mots'eanong, Phuptjane, Phupu, Phato, Loetse, Mphalane, Pulungoana, Tšitoe. ." U boetse u na le khetho ea ho khetha boleng ka kotloloho ho kholumo e teng kapa lethathamo la data ho spreadsheet ea hau. Ho etsa sena, tobetsa konopo ea "Origin" ka har'a "Qalo".
Hopola hore u ka tsoela pele ho etsa khetho ea lenane le theoha. Ho "Litlhophiso" tab, o ka sheba lebokose la "Ignore blank" haeba u sa batle ho lumella sele hore e siee e se na letho. Ho feta moo, o ka hlahisa molaetsa kapa molaetsa wa temoso ha o kgetha sele. Melaetsa ena e ka thusa ho fana ka litaelo tse eketsehileng kapa tlhakisetso mabapi le lenane le theolelang. Qetellong, tobetsa "Ho lokile" 'me lethathamo la hau le theoha le tla hlophisoa' me le loketse ho sebelisoa.
Ka mehato ena e bonolo, u tla khona ho hlophisa likhetho tsa lenane la ho theoha ho Excel kapele le ka nepo! Re tšepa hore tataiso ena e bile molemo ho uena. Bakeng sa tlhaiso-leseling e batsi kapa mehlala e ikhethileng, re khothaletsa ho hlahloba lithupelo tsa rona le lisebelisoa tse ling. Sebelisa ts'ebetso ena hamolemo 'me u ntlafatse tlhophiso ea data le mesebetsi ea khetho ho Excel.
6. Ho thibela ho kenngoa ha data ho sebelisa manane a theoha
A tsela e sebetsang hantle Tsela e 'ngoe ea ho thibela ho kenngoa ha data ka foromo ke ka ho sebelisa manane a theoha. Manane ana a lumella mosebelisi ho khetha khetho e boletsoeng esale pele, ho qoba liphoso tse ka bang teng kapa likenyo tse fosahetseng. Thutong ena, re tla u bontša mokhoa oa ho kenya mefuta ena ea manane ka foromo ea hau mohato ka mohato.
Pele o qala, etsa bonnete ba hore o na le phihlello ea khoutu ea mohloli oa foromo ea hau. E latelang, latela mehato ena:
- E supa sebaka sa ho kenya data seo u batlang ho se sebelisa lethathamong la ho theoha.
- Kenya karolo ea HTML
, eketsa likhetho u sebelisa element. - Bakeng sa khetho e 'ngoe le e 'ngoe, hlakisa boleng le mongolo oo u lokelang ho o bontša mosebelisi.
- Boloka le ho tsosolosa foromo ea hau ho bona liphetoho tse hlahang.
Hopola hore manane a theoha a fana ka mokhoa o hlakileng le o potlakileng oa ho thibela ho kena ha data. Ho feta moo, li ka hlophisoa ka mekhoa le boitšoaro bo eketsehileng ka tšebeliso ea CSS le JavaScript. Leka ka likhetho tse fapaneng 'me u fumane mokhoa oa ho ntlafatsa ts'ebeliso ea liforomo tsa hau!
7. Ho iketsetsa chebahalo ea lenane le theohang ho Excel
Ho iketsetsa ponahalo ea lenane le theoha ho Excel, ho na le likhetho tse 'maloa tse u lumellang ho fetola ponahalo ea lona hore e lumellane le likhetho tsa hau. Mehato e latelang ke e latelang ho fihlela sena:
1. Khetha sele kapa mofuta oa lisele tseo u batlang ho theha lethathamo la litheolelo.
2. Eya ho "Data" tab ya ho Excel toolbar.
3. Tobetsa ho khetho ea "Data Validation" ho bula lebokose la puisano le lumellanang.
4. Ka "Settings" tab ya lebokose la puisano, khetha "Lethathamo" ho tsoa lethathamong la "Lumella" ho theoha.
5. Kenya litekanyetso tseo u batlang ho hlaha ho tsona lethathamong la "Mohloli". O ka thaepa boleng ka kotloloho kapa oa khetha mefuta e fapaneng ho spreadsheet ea hau.
6. Ho tobetsa OK ho tla theha lenane la ho theoha ka litekanyetso tse boletsoeng.
Ha u se u thehile lethathamo la li-drop-down, u ka qala ho hlophisa ponahalo ea lona u sebelisa lisebelisoa tse fumanehang ho Excel. Tse ling tsa likhetho li kenyelletsa:
- Fetola mofuta oa fonte: U ka khetha mofuta oa fonte, boholo ba eona le setaele ho tsoa ho "Lehae" letlapeng la lithulusi. Sena se tla u lumella ho eketsa setaele se ikhethileng linthong tsa lenane.
- Sebelisa ho fomata ho nang le maemo: Khetho ea "Conditional formatting" ho "Home" tab e tla u lumella ho totobatsa lintlha tsa lethathamo ho latela maemo a itseng. Mohlala, o ka totobatsa ka bofubelu boleng bo sa lokelang ho khethoa.
- Eketsa meeli le mebala: Ho tsoa ho "Lehae" tab, o ka eketsa meeli le mebala liseleng tse nang le lethathamo le theoha. Sena se tla thusa ho e khetholla ho lisele tse ling le ho fa spreadsheet ea hau ponahalo ea setsebi haholoanyane.
Ka ho latela mehato ena le ho hlophisa chebahalo ea lenane la hau le theoha, o ka theha spreadsheet e khahlang le e bonolo ho e sebelisa ho Excel. Leka ka likhetho tse fapaneng tse fumanehang 'me u fumane setaele se lumellanang hantle le litlhoko tsa hau.
8. Ho hokahanya lenane le theoha le sele e 'ngoe ea Excel
Ho hokahanya lenane la ho theoha le sele e 'ngoe ea Excel, ho na le mehato e mengata eo u lokelang ho e latela. Taba ea pele, khetha sele eo u batlang hore lethathamo la li-dropdown le hlahe. Ka mor'a moo, e ea ho "Data" ho toolbar ea Excel ebe o tobetsa "Validation Data." Sena se tla bula fensetere ea pop-up.
Ka fensetere ea pop-up, e ea ho "Settings" tab ya. Leqepheng la "Origin", kenya mefuta e mengata ea lisele ho tsoa lethathamong le theoha. Ka mohlala, haeba u na le lenane la litekanyetso ho lisele tsa A1 ho ea ho A5, u tla kenya "A1: A5." Etsa bonnete ba hore u khetha "List" ho "Lumella" kgetho.
Hang ha u qetile mehato ena, lenane la ho theoha le tla hokahanngoa le sele e khethiloeng. Sena se bolela hore ha o khetha boleng ho tsoa lethathamong le theoha, boleng boo bo tla hlahisoa seleng e khethiloeng. U ka tsoela pele ho etsa lethathamo la li-drop-down ho sebelisa likhetho tse fumanehang ho "Litlhophiso" tsa fensetere ea pop-up, joalo ka ho kenya molaetsa kapa molaetsa oa phoso.
9. Automating apdate ya dikgetho lenaneng la dropdown
Ho ntlafatsa likhetho tsa lenane le theoha, ho na le litharollo le lisebelisoa tse fapaneng tse ka thusang ts'ebetso ena.
Tsela e 'ngoe ea ho finyella sena ke ho sebelisa JavaScript le HTML. Taba ea pele, u tla hloka ho tseba lenane la litheolelo tseo u batlang ho nchafatsa likhetho ho tsona. U ka etsa sena ka ho sebelisa tšobotsi ea "id" ea "select" tag. Hang ha u se u khethile lethathamo la ho theoha, u ka sebelisa JavaScript ho fetola litaba tsa likhetho.
Mohlala, o ka sebelisa loop ho theola sehlopha kapa ntho e nang le boleng boo u batlang ho bo bonts'a lethathamong le theoha. Ebe, o ka sebelisa mokhoa oa "createElement" ho theha likhetho tse ncha le mokhoa oa "appendChild" ho li kenyelletsa lenaneng le theoha. Hopola hore khetho ka 'ngoe e tlameha ho ba le boleng le mongolo o bonahalang ho mosebelisi.
Sesebelisoa se sebetsang sa ho etsa othomathike ena ke jQuery. Laeborari ena ea JavaScript e fana ka mesebetsi le mekhoa e mengata e nolofatsang ts'ebetso ea ho qhekella ea DOM. Mohlala, o ka sebelisa "letho" ho tlosa likhetho tsohle tse seng li le teng lethathamong la litheolelo pele o kenya likhetho tse ncha. Joale, o ka sebelisa mokhoa oa "append" ho eketsa likhetho tse ncha habonolo.
Ka bokhutšoanyane, ho iketsetsa ntlafatso ea likhetho lethathamong le theoha ho ka nolofatsa taolo ea data le ho ntlafatsa boiphihlelo ba mosebelisi. Hore na o sebelisa JavaScript e hloekileng kapa laeborari e kang jQuery, ho bohlokoa ho utloisisa hore na likarolo tsa DOM li sebetsa joang le hore na u ka li qhekella joang ho fihlela sephetho se lakatsehang. Hopola ho hloaea lenane la li-dropdown, etsa likhetho tse ncha 'me u li kenye ka mekhoa e nepahetseng. Etsa bonnete ba hore u leka le ho lokisa khoutu ea hau bakeng sa liphetho tse ntle!
10. Ho lokisa mathata a tloaelehileng ha ho etsoa manane a theoha ho Excel
Ha u theha manane a theoha ho Excel, ho tloaelehile ho kopana le mathata a ka thatafatsang ts'ebetso. Leha ho le joalo, u se ke ua tšoenyeha, mona ke tse ling tsa tharollo bakeng sa mathata a tloaelehileng haholo.
1. Sheba mohloli oa data: Etsa bonnete ba hore mohloli oa data oo u o sebelisang ho theha lethathamo la litheolelo o nepahetse 'me o ka sebopeho se nepahetseng. Netefatsa hore lenane le teng kholomong e itseng kapa mofuteng oa lisele, le hore ha le na sebaka se sesoeu kapa litlhaku tse khethehileng. U ka boela ua sebelisa List Wizard Li-dropdown tsa Excel, e tla u tataisa mohato ka mohato.
2. Sheba likhetho tsa netefatso ea data: Lethathamo le theoha e kanna ea se be teng ka lebaka la litlhophiso tse fosahetseng tsa khetho ea netefatso ea data. Ho lokisa sena, khetha sele eo u batlang hore lethathamo le theolelang le hlahe ho eona, e ea ho "Data" tab e lenteng, tobetsa "Netefatso ea data," 'me u netefatse hore likhetho li setiloe ka nepo, joalo ka mofuta oa ho theoha. list (inline kapa lethathamong) le mefuta e mengata ea lisele tse nang le data.
11. Papiso pakeng tsa manane a theolelang a tsitsitseng le a matla a Excel
Manane a theohang ke sesebelisoa sa bohlokoa haholo ho Excel kaha a lumella mosebelisi ho khetha khetho habonolo lethathamong le boletsoeng esale pele. Leha ho le joalo, ho na le mefuta e 'meli ea manane a theoha: a tsitsitseng le a matla. Papisong ena, re tla hlahloba phapang lipakeng tsa mefuta ka bobeli le ts'ebeliso ea eona.
Manane a theolelang a tsitsitseng ke ao likhetho li tsitsitseng 'me ha a fetohe ha nako e ntse e ea. Manane ana a loketse ha o hloka ho khetha ho tsoa sehlopheng sa likhetho tse lulang li sa fetohe ha nako e ntse e ea. Ho theha lenane le theohang le sa fetoheng ho Excel, o kenya feela likhetho ka kholomong ebe o abela kholomo eo joalo ka mohloli oa data oa lenane le theohang. Hang ha e se e bōpiloe, lenane le theolelang la static le tla bontša likhetho tse tšoanang ho sa tsotellehe liphetoho ho data sheet.
Ka lehlakoreng le leng, manane a theolelang a matla ke ao likhetho li fetohang ka botsona ho latela data e ho spreadsheet. Lenane la mofuta ona le bohlokoa haholo ha o sebetsa le data e nchafatsoang khafetsa. Ho theha lenane le theolelang le matla ho Excel, o hloka ho sebelisa litafole kapa marang-rang a nang le mabitso a hlalositsoeng. Mabitso ana a mahlahahlaha a lumella lenane le theoha hore le intlafatse ha likhetho li eketsoa kapa li tlosoa letlapeng. Ka tsela ena, u tla lula u e-na le lenane le theolelang le ntlafalitsoeng le le sebetsang.
Ka kakaretso, manane a theoha a tsitsitseng a loketse ha o hloka ho khetha ho tloha sehlopheng sa likhetho tse tsitsitseng, ha manane a theoha a matla a loketse maemo ao likhetho li hlokang ho nchafatsoa ka botsona. Mefuta ka bobeli ea manane a theolelang a na le ts'ebeliso ea ona mme ho bohlokoa ho utloisisa phapang ea bona ho khetha khetho e nepahetseng ho latela litlhoko tsa projeke ka 'ngoe. [QETA
12. Ho ntlafatsa bokhoni ba ho sebelisa manane a theohang ho Excel
Ho ntlafatsa bokhoni ba ho sebelisa manane a theohang ho Excel, ho bohlokoa ho latela mehato e 'maloa ea bohlokoa. Taba ea pele, etsa bonnete ba hore u kentse mofuta oa morao-rao oa lenaneo, kaha sena se tla etsa bonnete ba hore u na le monyetla oa ho fumana likarolo tsohle tsa morao-rao. Joale u ka qala ho theha lethathamo la litheolelo u sebelisa khetho ea "Netefatso ea Lintlha" ho "Lisebelisoa tsa data".
Ha u se u khethile khetho ena, fensetere e tla bula moo u ka hlalosang mohloli oa data bakeng sa lenane le theoha. U ka khetha lethathamong le teng ho spreadsheet kapa kenya data ka letsoho lebokoseng la mongolo. Ho feta moo, o ka sebelisa mela ea lisele ho li-spreadsheet tsa hau ho ntlafatsa ka bo eona data ea lenane le theoha ha e fetoha.
Qetellong, hang ha u se u thehile lenane la li-dropdown, u ka le etsa ka mokhoa o ikhethileng. Mohlala, o ka eketsa melaetsa le melaetsa ea liphoso ho tataisa basebelisi ho khetha likhetho tse nepahetseng. U ka boela ua sebelisa fomete e nang le maemo ho sele e nang le lenane la ho theoha ho totobatsa likhetho tse entsoeng. Se ke oa lebala ho lekola lenane la litheolelo pele u le arolelana! le basebelisi ba bang ho etsa bonnete ba hore e sebetsa hantle!
13. Ho atolosa menyetla ea manane a theoha ho Excel
Manane a theohang ho Excel ke sesebelisoa sa bohlokoa sa ho hlophisa le ho khetha data kapele le ha bonolo. Leha ho le joalo, hangata re iphumana re lekanyelitsoe ke likhetho tse boletsoeng esale pele tseo e re fa Excel. Ka lehlohonolo, ho na le mekhoa e mengata ea ho holisa menyetla ea manane a theolelang, ho re fa monyetla oa ho a etsa le ho a fetola ho latela litlhoko tsa rona.
Tsela e 'ngoe ea ho ntlafatsa manane a rona ke ho sebelisa liforomo ho e-na le litekanyetso tse tsitsitseng. Sena se re lumella ho inchafatsa likhetho tsa manane ka botsona ho latela liphetoho tse ling data. Re ka sebelisa lits'ebetso tse kang "COUNT", "IF" kapa "INDEX" ho tseba ka matla lenane la likhetho. Ntle le moo, re ka kopanya liforomo tse 'maloa ho fumana liphetho tse rarahaneng.
Kgetho e 'ngoe ke ho sebelisa fomete e nang le maemo ho totobatsa likhetho tse itseng lenaneng la ho theoha. Mohlala, re ka sebelisa molao oa ho fometa o nang le maemo ho totobatsa boleng bohle bo fihlelang maemo a itseng. Sena se re thusa ho tseba ka potlako likhetho tse bohlokoa kapa tse bohlokoa. Hape re ka sebelisa li-icon kapa libaka tsa data ho emela bohlokoa ba khetho ka 'ngoe.
14. Liqeto le likhothaletso tsa tšebeliso ea manane a theohang ho Excel
Qetellong, manane a theolelang ho Excel ke sesebelisoa se molemo haholo ho thusa ho kenya data le ho ntlafatsa tlhophiso ea tlhahisoleseling ho li-spreadsheet. Ka bokhoni ba ho hlahisa lenane le hlalositsoeng esale pele la likhetho tseo u ka khethang ho tsona, manane a theoha a u thusa ho qoba liphoso tsa ho kena le ho tsamaisa mokhoa oa ho kenya data.
Ha u sebelisa manane a theoha ho Excel, ho bohlokoa ho latela likhothaletso tse ling bakeng sa ts'ebeliso ea ona e nepahetseng. Taba ea pele, ho bohlokoa ho hlalosa ka nepo likhetho tse lethathamong, ho netefatsa hore li hlakile ebile li emela likhetho tsohle tse ka khonehang. Ho phaella moo, ho eletsoa ho sebelisa mokhoa o nepahetseng bakeng sa lenane la ho theoha, ebang ke ka sele e le 'ngoe kapa kholomong eohle.
Khothaletso e 'ngoe ea bohlokoa ke ho netefatsa lintlha tsa lenane le theoha ho qoba ho kenya litekanyetso tse sa batleheng. Sena se ka finyelloa ka ho sebelisa likhetho tsa netefatso ea data ho Excel, moo melao e ka beoang ho amohela litekanyetso tse lumelletsoeng feela. Ho feta moo, khetho ea ho lumella ho kenya litloaelo le eona e ka nolofalloa, ea lumella litekanyetso tse ncha hore li ekeletsoe lethathamong le theoha ha ho hlokahala.
Qetellong, ho ithuta ho etsa lethathamo le theoha ho Excel e ka ba tsebo ea bohlokoa ho mosebelisi ofe kapa ofe oa sesebelisoa sena se matla sa spreadsheet. Ka ho tseba mokhoa ona, o tla khona ho ntlafatsa katleho ea mesebetsi ea hau ea letsatsi le letsatsi, joalo ka ho kenya data le taolo ea tlhahisoleseling.
Ho pholletsa le sengoloa sena, re hlahlobile mehato e hlokahalang ho theha lenane le theoha ho Excel, ho qala ka ho khetha data ho isa ho ts'ebeliso ea netefatso ea data. Ho feta moo, re buisane ka lintlha tse ling tsa bohlokoa, joalo ka ho kenyelletsa tse ncha, ho hlophisa lethathamo, le ho rarolla mathata a tloaelehileng.
Re tšepa hore sengoloa sena se bile le thuso le hore u fumane tsebo e eketsehileng mabapi le mokhoa oa ho etsa lenane le theoha ho Excel. Hopola hore ho ikwetlisa le ho etsa liteko ka litlhophiso tse fapaneng ho tla u fa monyetla oa ho tseba tšobotsi ena le ho fumana molemo ho li-spreadsheet tsa hau.
Bokhoni ba ho etsa manane a theoha ho Excel bo tla u lumella ho ntlafatsa boleng le ho nepahala ha mosebetsi oa hau, hammoho le ho boloka nako le boiteko ka ho fokotsa liphoso tsa ho kenya data. Ka tsebo ena, u tla ba mohato o le mong haufi le ho ba setsebi sa Excel le ho ntlafatsa tsebo ea hau mosebetsing kapa lefapheng la thuto.
Seke oa tsilatsila ho sebelisa seo u ithutileng sona 'me u hlahlobe menyetla eohle eo manane a theohang ho Excel a ka u fang eona! Tsoela pele ho hlahloba likarolo tse ncha le mesebetsi ea sesebelisoa sena ho tsoela pele ho ntlafatsa tsebo ea hau le ho fihlela bokhoni ba hau bo felletseng. mererong ea hau ea li-spreadsheets. Mahlohonolo 'me u natefeloe ke boiphihlelo ba hau ba Excel!
Ke 'na Sebastián Vidal, moenjiniere oa k'homphieutha ea chesehelang theknoloji le DIY. Ho feta moo, ke 'na moetsi oa tecnobits.com, moo ke arolelanang lithupelo ho etsa hore theknoloji e fumanehe le ho utloisisoa ke motho e mong le e mong.