Dikgetho tsa ho netefatsa dintlha tsa Excel di kenyelletsa ho theha lethathamo la theohase le fokotsang dintlha tse ka kenngwang seleng e itseng ho e thathamisitsoeng pele ho lenane.
Ha lethathamo le theoha le kenngoa seleng, motsu o bonts'a haufi le oona. Ho tobetsa motsu ho tla bula lenane mme ho u lumelle hore u khethe ntho e le 'ngoe ea lenane ho kenya seleng.
Lintlha tse sebelisoang lenaneong li ka ba teng:
- leqepheng le ts'oanang le lethathamo
- leqepheng le fapaneng la lipampiri lebenkeleng le le leng
- bukeng e fapaneng ea libuka
Thuto: Ho sebelisa Dintlha tse bolokiloeng ho Buka e fapaneng ea mosebetsi
Thutong ena, re tla etsa lethathamo le theoha ka ho sebelisa lenane la likalo tse ngotsoeng bukeng e fapaneng ea libuka.
Melemo ea ho sebelisa lenane la litlhaloso tse ngotsoeng bukeng e fapaneng e kenyelelitse ho kenyelletsa lethathamo la lintlha haeba le sebelisoa ke basebelisi ba bangata le ho sireletsa lintlha ho tloha phetohong ea kotsi kapa ka boomo.
Tlhokomeliso: Ha lethathamo la lintlha li bolokiloe bukeng ea buka e fapaneng libuka tsa mosebetsi li lokela ho buloa e le hore lenane le sebetse.
Ho latela mehato ea lihlooho tsa lithupelo tse latelang ho u tsamaisa ka ho bopa, ho sebelisa, le ho fetola lethathamo le theoleloang le tšoanang le le bonngoeng setšoantšong ka holimo.
Tsena litaelo tsa thupelo, leha ho le joalo, ha li kenyelle mekhoa ea ho etsa litlhahiso bakeng sa lipampiri.
Sena se ke ke sa kena-kenana le ho tlatsa thupelo. Lethathamo la hau la mosebetsi le tla shebahala le fapaneng ho feta mohlala o leqepheng la 1, empa lethathamo la theolelo le tla u fa liphetho tse tšoanang.
Thuto Lihlooho
- Ho bula Lifaele le ho Boloka Tutorial Data
- Ho theha Litsela Tse peli Tse Tsejoang
- Ho bula Lebokose la Dijo la Tiiso ea Data
- Ho kenya mohloli oa Data le ho Finyella Letšoao la ho Hlaseloa
- Ho fetola Lintho tsa Lintlha
- Mekhoa ea ho sireletsa ho theoha tlaase
01 ea 06
Ho kenya Tutorial Data
Ho bula Libuka tse peli tsa mosebetsi oa Excel
Joalokaha ho boletsoe, bakeng sa thupelo ena data ea lenane la theolelo e tlaase e tla fumanoa bukeng e fapaneng ea mosebetsi ho tloha lethathamong le theoleloang.
Bakeng sa thupelo ena latela mehato ena:
- Bula libuka tse peli tsa mosebetsi oa Excel
- Boloka buka e le 'ngoe ea mosebetsi e nang le lebitso la data-source.xlsx - buka ena ea libuka e tla ba le letoto la lenane le theoleloang
- Boloka buka ea bobeli e nang le lebitso la ho theola-list.xlsx - buka ena ea buka e tla ba le lethathamo le theoha
- Tlohela libuka tsa bobeli tse sebetsang ka mor'a hore u boloke.
Ho kenya Tutorial Data
- Kenya data mona ka tlase ho lisele tse A1 ho A4 tsa buka ea data-source.xlsx joalokaha ho bonngoe setšoantšong se ka holimo.
- A1 - Gingerbread A2 - Lemon A3 - Oatmeal Raine A4 - Chocolate Chip
- Boloka buka ea mosebetsi 'me ee bulehe
- Kenya data mona ka tlase ho li-cell B1 tsa buka ea ho theola-list-list.xlsx .
- B1 - Mofuta oa Cookie:
- Boloka buka ea mosebetsi 'me ee bulehe
- Lenane la theolelo le tla theoleloa seleng C1 ea buka ena ea buka
02 ea 06
Ho theha Litsela Tse peli Tse Tsejoang
Ho theha Litsela Tse peli Tse Tsejoang
Sebaka se bitsoang lebitso se u lumella hore u bue leboteng le itseng la lisele tsa buka ea Excel.
Mebala e mengata e sebelisitsoe ho Excel ho akarelletsa ho e sebelisa ka litlhahlobo le ha ho thehoa lichate.
Maemong 'ohle, lebitso le bitsoang lebitso le sebelisitsoe sebakeng sa mefuta e mengata ea lisele tse bonts'ang sebaka sa lintlha lefapheng la lipampiri.
Ha e sebelisoa lethathamong le theohang lethathamong le fapaneng, mekhahlelo e 'meli e rehiloeng e lokela ho sebelisoa.
- E 'ngoe e bōpiloe bakeng sa lintho tse thathamisitsoeng lenaneong la ho sebetsa moo data e leng teng
- Ea bobeli e bōptjoa bukeng ea ho sebetsa moo lethathamo la theoha le teng. Sehlooho sena sa bobeli se bitsoang lihlahisoa tse amanang le sebaka se boletsoeng bukeng ea pele ea libuka
Lithuto tsa Thuto
Range ea Pele ea Lebitso
- Khetha lisele tsa A1 - A4 tsa buka ea data-source.xlsx ho li totobatsa
- Tobetsa lebokose la lebitso le fumanehang ka holimo ho lintlha tsa A
- Tšoaea "Li-Cookie" (ha ho litemana) ho Lebokose la Lebitso
- Tobetsa konter ENTER ho lebokose
- Lisele tse A1 ho A4 tsa buka ea data-source.xlsx hona joale li na le lebitso la li- Cookie
- Boloka buka ea buka
Range ea Bobeli e Tsejoang
Lebitso lena la bobeli le bitsoang range ha le sebelise lisele tse hlahang libukeng tsa li-drop-down-list.xlsx .
Ho e-na le hoo, ho tla ba joalo, joalokaha ho boletsoe, ho amahanya le lebitso la li-Cookie ho buka ea data-source.xlsx .
Sena se hlokahala hobane Excel e ke ke ea amohela litlaleho tsa lisele tse tsoang bukeng e fapaneng ea libuka bakeng sa lebitso le bitsoang. E tla ba leha ho le joalo, ntle le lebitso le leng la mabitso.
Ka hona, ho theha moeli oa bobeli o boletsoeng, ha o etsoe ka Lebitso la Lebokose empa ka ho sebelisa khetho ea Mookameli oa Lebitso e hlahang tabeng ea Foromolas ea lebone.
- Tobetsa seleng ea C1 bukeng ea ho theola-down-list.xlsx
- Tobetsa Litlhahlobo> Mookameli oa Lebitso holim'a lekareche ho bula Motlatsi oa Lebitso la lebokose la lebokose la lihlooho
- Tobetsa konopo e Ncha ho bula lebokose le reng New Name dialog box
- Lethathamong la lebitso la lebitso: Dintlha
- Ha e hlalosa mofuta oa line: = 'data-source.xlsx'! Cookies
- Tlanya KELE ho qeta lebitso le reriloeng mme u khutlele ho lebokose la lebokose la lebokose la lebitso
- Tlanya Haufinyane ho koala lebokose la lebokose la lebokose la lebitso
- Boloka buka ea buka
03 ea 06
Ho bula Lebokose la Dijo la Tiiso ea Data
Ho bula Lebokose la Dijo la Tiiso ea Data
Litsela tsohle tsa ho netefatsa dintlha tsa Excel, ho kenyelletsa lethathamo la theoha, li behoa ho sebelisa boitsebiso ba boitsebiso ba boitsebiso ba data.
Ntle le ho eketsa lethathamo la theolelo ho leqephe la lipampiri, ho netefatsa dintlha ho Excel ho ka boela ha sebelisoa ho laola kapa ho fokotsa mofuta oa data o kenyelletsoang lisele tse itseng kahare.
Lithuto tsa Thuto
- Tobetsa seleng ea C1 ea buka ea ho theola-list-list.xlsx ho e etsa hore e be sele e sebetsang - ena ke moo lenane la theoha le tla ba teng
- Tobetsa Taba ea Data ea menu ea lekareche ka holimo ho leqephe la mosebetsi
- Tobetsa ho Letšoao la Tlhaloso ea Data ho Ribbon ho bula menu ea theoha
- Tobetsa ho Tlhaloso ea Tlhaloso ea Data ho menu ho bula lebokose la boitsebiso la Dintlha
- Tloha lebokose la lebokose le bulehileng bakeng sa mohato o latelang thupelong
04 ea 06
Ho sebelisa Lethathamo la Tiiso ea Data
Ho Khetha Lethathamo la Tlhahlobo ea Data
Joalokaha ho boletse moo ho na le mekhoa e mengata ea ho netefatsa dintlha ho Excel ho phaella ho lethathamo la theoha.
Ka mohato ona re tla khetha kgetho ea Lethathamo e le mofuta oa ho netefatsa ha data ho sebelisoa bakeng sa sele ea D1 ea leqephe.
Lithuto tsa Thuto
- Tobetsa ho Litebelisoa tab ho lebokoseng la lebokose
- Tobetsa motsu o ka tlaase ho qetellong ea Let line ea ho lumella ho bula menyetla e theoha
- Tobetsa Lethathamong ho khetha lethathamo la theoha bakeng sa ho netefatsa dintlha ka seleng ea C1 le ho kenya mohloli oa Mohloli lebokoseng la lebokose
Ho kenya mohloli oa Data le ho Finyella Letšoao la ho Hlaseloa
Kaha mohloli oa data oa lethathamo la theoha o teng bukeng e fapaneng ea mosebetsi, bobeli bo boletsoeng ka bobeli bo bōpiloeng pejana bo tla kenngoa mohloling oa Mohloli lebokoseng la lebokose.
Lithuto tsa Thuto
- Tobetsa Mohloli oa Mohloli
- Tšoaea "= Data" (ha ho litemana) Mohloling oa Mohloli
- Tlanya Kantle ho tlatsa lenane le theoha le ho koala lebokose la lebokose le tiisitsoeng la Data
- Setšoantšo se senyenyane sa motsu se ka tlas'a lehlakoreng le letona la sele C1
- Ho tobetsa motsu o ka tlaase o lokela ho bula lenane le theoha le nang le mabitso a mane a cookie a kenngoa liseleng tsa A1 ho A4 tsa buka ea data-source.xlsx
- Ho tobetsa ho le leng la mabitso o lokela ho kenya lebitso leo ka seleng ea C1
05 ea 06
Ho Fetola Lethathamo la Ho theoha
Ho fetola Lintho tsa Lintlha
E le ho boloka letoto la theolelo ho fihlela joale le liphetoho tsa data ea rona, ho ka 'na ha hlokahala hore nako le nako u fetole liqeto tsethathamong.
Kaha re sebelisitse mabitso a mangata e le mohloli oa lintho tsa rona tsa lethathamo ho e-na le mabitso a lenane la lenane, ho fetola mabitso a li-cookie boemong bo boletsoeng bo ka liseleng tsa A1 ho A4 bukeng ea data-source.xlsx hang-hang ho fetola mabitso ho theoha lenane.
Haeba data e kenngoa ka ho toba ka lebokose la lebokose, ho etsa liphetoho lenaneng ho akarelletsa ho khutlela ka lebokoseng la lebokose le ho fetola mohloli oa mohloli.
Mohato ona re tla fetola Lemon ho Shortbread hothathamong ea theoha ka ho fetola boitsebiso ka seleng A2 ea boitsebiso bo boletsoeng bukeng ea data-source.xlsx .
Lithuto tsa Thuto
- Tobetsa seleng ea A2 bukeng ea data-source.xlsx (Lemon) ho e etsa sele e sebetsang
- Tšoaea nako e khutšoanyane ka seleng ea A2 mme o tobetsa konopo ea Kena ho lebokose
- Tobetsa motsu o ka tlaase bakeng sa lenane la theoha ka seleng ea C1 ea buka ea ho theola-list-list.xlsx ho bula lenane
- Sehlooho sa 2 sethathamong se lokela ho balloa Nakoana e khutšoanyane ho e-na le Lemon
06 ea 06
Mekhoa ea ho sireletsa ho theoha tlaase
Mekhoa ea ho sireletsa ho theoha tlaase
Ho tloha ha dintlha tsa rona li fumaneha lethathamong le fapaneng la dikgetho tse ka tlase ho dikgetho tse fumanehang bakeng sa ho sireletsa dintlha tse kenyeletsang:
- Sireletsa leqephe la mosebetsi le akarelletsang ho thibela lisele tse A1 ho A4 leqepheng la 2
- Ho hloka password bakeng sa ho fetola buka ea mosebetsi
- Ho ba le buka ea mosebetsi e bulehileng e le Buka feela