Sefa ho Excel - Metheo

Ho sefa data ho Excel ho u lumella ho bonts'a har'a palo e kholo ea tlhahisoleseling feela seo u se hlokang hajoale. Ka mohlala, ho ba le lethathamo la likete tsa thepa ka har'a hypermarket e kholo ka pel'a hau, u ka khetha li-shampoos kapa litlolo feela ho eona, 'me u pate tse ling ka nakoana. Thutong ena, re tla ithuta ho sebelisa li-filters ho manane a Excel, ho beha sefa holim'a likholomo tse 'maloa ka nako e le ngoe, le ho tlosa lihloela.

Haeba tafole ea hau e na le lintlha tse ngata, ho ka ba thata ho fumana lintlha tseo u li hlokang. Li-filters li sebelisetsoa ho fokotsa palo ea data e bontšitsoeng leqepheng la Excel, e leng se u lumellang hore u bone feela boitsebiso boo u bo hlokang.

Ho sebelisa filthara ho Excel

Mohlaleng o latelang, re tla sebelisa filthara lethathamong la tšebeliso ea Iron ho bonts'a feela lilaptop le matlapa a fumanehang bakeng sa tlhahlobo.

1. Kgetha sele efe kapa efe tafoleng, mohlala sele A2.

Hore ho sefa ho sebetse ka nepo ho Excel, leqephe la mosebetsi le tlameha ho ba le mola oa lihlooho o sebelisetsoang ho reha kholomo ka 'ngoe. Mohlaleng o latelang, lintlha tse leqepheng la mosebetsi li hlophisitsoe e le litšiea tse nang le lihlooho moleng oa 1: ID #, Mofuta, Tlhaloso ea Iron, joalo-joalo.

1. Click ea Lintlha, ebe o tobetsa taelo filthara.
2. Likonopo tsa metsu li hlaha lihloohong tsa kholomo ka 'ngoe.
3. Tobetsa konopo e joalo kholomong eo u batlang ho e sefa. Tabeng ea rona, re tla sebelisa filthara ho kholomo ea B ho bona feela mefuta ea lisebelisoa tseo re li hlokang.
4. Ho tla hlaha lenane la sefe.
5. Hlakola lebokose Khetha tsohleho tlosa dintho tsohle kapele.
6. Sheba mabokose bakeng sa mefuta ea lisebelisoa tseo u batlang ho li siea tafoleng, ebe u tobetsa OK. Mohlala oa rona, re tla khetha dilepothopo и Tabletsho bona feela mefuta eo ea lisebelisoa.
7. Lethathamo la lintlha le tla hloekisoa, 'me ka nakoana ho pate litaba tsohle tse sa lumellaneng le maemo. Mohlala oa rona, ke lilaptop le matlapa feela a ileng a lula a bonahala.

Ho sefa ho ka boela ha sebelisoa ka ho khetha taelo Hlopha le ho sefa tab ya Home.

Kenya li-filters tse ngata ho Excel

Li-filters ho Excel li ka akaretsoa. Sena se bolela hore o ka sebelisa li-filters tse ngata tafoleng e le 'ngoe ho fokotsa liphetho tsa sefe. Mohlala o fetileng, re se re ntse re sefa tafole ho bonts'a lilaptop le matlapa feela. Joale mosebetsi oa rona ke ho fokotsa datha le ho feta le ho bonts'a lilaptop le matlapa a rometsoeng ho hlahlojoa ka Phato.

1. Tobetsa konopo ea motsu kholomong eo u batlang ho e sefa. Tabeng ena, re tla sebelisa sefe e 'ngoe ho kholomo ea D ho bona lintlha ka letsatsi.
2. Ho tla hlaha lenane la sefe.
3. Sheba kapa u tlose ho hlahloba mabokose ho latela data eo u batlang ho e sefa, ebe u tobetsa OK. Re tla tlosa likhetho tsohle ntle le August.
4. Sefahla se secha se tla sebelisoa, 'me ke li-laptops le matlapa feela a rometsoeng hore a netefatsoe ka Phato tse tla sala tafoleng.

Ho tlosa filthara ho Excel

Kamora ho sebelisa filthara, kapele kapa hamorao ho tla hlokahala ho e tlosa kapa ho e tlosa e le ho sefa litaba ka tsela e fapaneng.

1. Tobetsa konopo ea motsu kholomong eo u batlang ho tlosa sefe ho eona. Mohlala oa rona, re tla tlosa filthara ho tsoa kholomong ea D.
2. Ho tla hlaha lenane la sefe.
3. Khetha ntho Tlosa sefe ho tsoa kholomong… Mohlala oa rona, re tla tlosa filthara ho tloha kholomong E rometsoe ho hlahlojoa.
4. Sefahla se tla tlosoa 'me data e neng e patiloe pele e tla hlaha hape leqepheng la Excel.

Ho tlosa lihloela tsohle tafoleng ea Excel, tobetsa taelo filthara tab ya Lintlha.