Koala le ho sireletsa libuka tsa mosebetsi ho Excel

Haeba u lebeletse ho arolelana buka ea hau ea mosebetsi ea Excel le basebelisi ba bang, joale hoa utloahala ho pata tlhahisoleseding eohle ea botho le ea lekunutu, hlahloba tokomane bakeng sa liphoso, le ho sireletsa buka ea mosebetsi ka e 'ngoe ea litsela tse ka khonehang. Mokhoa oa ho etsa sena sohle, o tla ithuta thutong ena.

Ho hlahloba mopeleto

Pele o arolelana buka ea mosebetsi ea Excel, ho ka ba molemo ho e hlahloba bakeng sa liphoso tsa mopeleto. Ke nahana hore ba bangata ba tla lumela hore liphoso tsa mopeleto tokomaneng li ka senya botumo ba mongoli haholo.

  1. Ho Advanced tab Ho hlahloba ka sehlopha Ho ngola tobetsa taelo Ho ngola.
  2. Lebokose la puisano le tla hlaha Ho ngola (ho rona ke ). Sehlahlobi sa mopeleto se fana ka litlhahiso tsa ho lokisa phoso e 'ngoe le e 'ngoe ea mopeleto. Khetha khetho e nepahetseng ebe o tobetsa konopo Sebaka.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  3. Ha tlhahlobo ea mopeleto e felile, lebokose la puisano le tla hlaha. Tobetsa OK ho tlatsa.Koala le ho sireletsa libuka tsa mosebetsi ho Excel

Haeba ho se na khetho e nepahetseng, u ka lokisa phoso ka bouena.

Liphoso tse sieo

Sehlahlobi sa spelling ho Excel ha se sebetse hantle kamehla. Ka linako tse ling, esita le mantsoe a peletoang ka nepo a tšoauoa joalo ka mopeleto o fosahetseng. Hangata sena se etsahala ka mantsoe a sieo bukeng e hlalosang mantsoe. Hoa khoneha hore u se ke ua lokisa phoso e boletsoeng ka phoso u sebelisa e 'ngoe ea likhetho tse tharo tse teng.

  • Skip – e siea lentsoe le sa fetohe.
  • Tlola kaofela - e siea lentsoe le sa fetoha, 'me o le tlola liketsahalong tse ling tsohle bukeng ea mosebetsi.
  • Kenya bukantswe - e eketsa lentsoe bukeng ea mantsoe, kahoo e ke ke ea hlola e tšoauoa e le phoso. Etsa bonnete ba hore lentsoe le ngotsoe ka nepo pele u khetha khetho ena.

Mohlahlobi oa Litokomane

Lintlha tse ling tsa botho li ka itlhahisa bukeng ea mosebetsi ea Excel. Ka ho sebelisa Mohlahlobi oa Litokomane o ka fumana le ho hlakola data ena pele o arolelana tokomane.

Hobane data e hlakotsoe Mohlahlobi oa Litokomane ha e fumanehe kamehla, re u eletsa hore u boloke kopi e eketsehileng ea buka ea mosebetsi pele u sebelisa tšebeletso ena.

Kamoo Mohlahlobi oa Litokomane a sebetsang kateng

  1. Click ea faele, Ho fallela ho pono e ka morao.
  2. Ka sehlopha Intelligence tobetsa taelo Batla mathata, ebe ho tsoa ho menu e theoha, khetha Mohlahlobi oa Litokomane.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  3. E tla bula Mohlahlobi oa Litokomane. Ka lebokoseng la puisano, khetha li-checkbox tse loketseng ho khetha mefuta ea litaba tseo u batlang ho li hlahloba, ebe u tobetsa Sheba. Mohlala oa rona, re siile lintho tsohle.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  4. Liphetho tsa liteko li lokela ho hlaha. Setšoantšong se ka tlase, u ka bona hore buka ea mosebetsi e na le lintlha tsa botho. Ho hlakola data ena, tobetsa konopo hlakola tsohle.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  5. Tobetsa ha o qetile Close.Koala le ho sireletsa libuka tsa mosebetsi ho Excel

Tšireletso ea Buka ea Mosebetsi

Ka tloaelo, mang kapa mang ea nang le phihlello ea buka ea hau ea mosebetsi a ka bula, a kopitsa, le ho hlophisa litaba tsa eona, ntle le haeba e sirelelitsoe.

Mokhoa oa ho sireletsa buka

  1. Click ea faele, Ho fallela ho pono e ka morao.
  2. Ka sehlopha Intelligence tobetsa taelo Sireletsa buka.
  3. Khetha khetho e nepahetseng ka ho fetisisa ho menu e theoha. Mohlala oa rona, re khethile Tšoaea e le ea ho qetela. Sehlopha Tšoaea e le ea ho qetela e o lumella ho lemosa basebelisi ba bang ka ho se khonehe ho etsa liphetoho bukeng ena ea mosebetsi. Litaelo tse setseng li fana ka tekanyo e phahameng ea taolo le tšireletso.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  4. Ho tla hlaha khopotso ea hore buka e tla tšoauoa e le ea ho qetela. Tobetsa OK, ho boloka.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  5. Khopotso e 'ngoe e tla hlaha. Tobetsa OK.Koala le ho sireletsa libuka tsa mosebetsi ho Excel
  6. Buka ea hau ea mosebetsi e se e tšoailoe e le ea ho qetela.Koala le ho sireletsa libuka tsa mosebetsi ho Excel

Team Tšoaea e le ea ho qetela ha e khone ho thibela basebelisi ba bang ho hlophisa buka. Haeba u batla ho thibela basebelisi ba bang ho hlophisa buka, khetha taelo Fokotsa ho kena.

Leave a Reply