Ungayisusa njani isihluzo kwi-Excel

Ukucoca idatha e-Excel kunyanzelekile ukuba kube lula ukusebenza neetafile kunye nezixa ezikhulu zolwazi. Ke, umzekelo, icandelo elibalulekileyo linokufihla kumsebenzisi, kwaye xa iqhuba icebo lokucoca, libonise ulwazi oluyimfuneko. Ngamanye amaxesha, xa itafile yadalwa ngokungachanekanga, okanye ngenxa yezizathu zokungafikeleli komsebenzisi, kukho isidingo sokususa isihluzo kwiikholamu ezahlukeneyo okanye kwiphepha ngokupheleleyo. Kwenzeka ntoni, siya kuhlalutya kwinqaku.

Imizekelo yeNdlela yeTheyibhile

Phambi kokuba uqale ukususa icebo lokucoca, qaphela ukuqwalasela ukhetho lokufakwa kwetafile ye-Excel:

• Ukungena kwedatha yencoko. Gcwalisa imigca kunye neekholamu ngolwazi oluyimfuneko. Emva koko, khetha idilesi yendawo yetafile, kubandakanya iintloko. Yiya kwi "data" ithebhu ephezulu yezixhobo. Sifumana "isihluzo" (siboniswe ngohlobo lwe-funnel) kwaye inqakraze kuyo yi-LKM. Isihluzi senziwe sisebenza kwizihloko eziphezulu.

Nye

• Ukucoca ngokuzenzekelayo kwi. Kule meko, itafile ikwazaliswa kwangaphambili, emva kwe "Starles" ithebhu, ifunyenwe ukuba isebenze "icebo lokucoca itafile". Kuya kubakho iifiltha ezenzekelayo kumazantsi etafile.

2.

Kwicala lesibini, kufuneka uye kwithebhu "Faka" ithebhu kwaye ufumane isixhobo setafile, cofa kuyo nge-LKM nakwezinye iindlela zilandelayo ukukhetha "itafile".

3.

Le windows ilandelayo iwindows evula, ukujongana netafile edaliweyo kuyaboniswa. Ihlala kuphela ukuze iqinisekise, kwaye iifilitha ezikwi-subtitles zivuliwe ngokuzenzekelayo.

ezine

Imizekelo ene-filter e-Excel

Shiya ukuqwalasela itheyibhile yesampulu enye eyenziwe ngaphambili kwiikholamu ezintathu.

• Khetha ikholamu apho kufuneka uhlengahlengise khona. Ngokucofa kwitolo kwiseli ephezulu, unokubona uluhlu. Ukususa enye yexabiso okanye izinto, kufuneka ususe uphawu lokuphatha ngokuchasene noko.
• Umzekelo, sifuna imifuno kuphela etafileni. Kwifestile evula, susa uphawu kunye "neziqhamo", kwaye ushiye imifuno isebenza. Vuma ngokunqakraza kwiqhosha "Kulungile".

Ntlanu

• Emva kokwenza uluhlu luya kujongeka ngolu hlobo:

6.

Khawuqwalasele omnye umzekelo wokusebenza:

• Itheyibhuli yahlulwe yaba ziikholamu ezintathu, kwaye amaxabiso okugqibela kuhlobo ngalunye lwemveliso. Kufuneka ilungiswe. Masithi kufuneka senze iimveliso zexabiso elixabisekileyo eliphantsi kunexabiso "45".
• Cofa kwi icon yokucoca kwiseli ekhethwe ngathi. Kuba ikholamu izaliswe ngamaxabiso amanani, emva koko ngefestile onokuyibona ukuba intambo ye "Failters" ikwimo esebenzayo.
• Ukuba nesikhombisi kuyo, vula ithebhu entsha enezinto ezahlukeneyo zokucoca itheyibhile yedijithali. Kuyo, khetha ixabiso "elincinci".

7.

• Emva koko faka inombolo "45" okanye ukhethe ngokuvula uluhlu lwamanani kwi-Autofilter yomsebenzisi.

Kananjalo, ngoncedo lwalo msebenzi, amaxabiso ayahlulwa kudidi oluthile lwedijithali. Ukwenza oku, kufuneka wenze iqhosha "okanye" kwi-Autofilter yomsebenzisi. Emva koko ngasentla bebeka ixabiso "elincinci", kwaye apha ngezantsi ". Kwimitya yokujonga ngasekunene, iiparamitha ezifunekayo zoluhlu lwamaxabiso zisetwe ukuba zihambe. Umzekelo, ungaphantsi kweminyaka engama-30 nangaphezulu kwe-45. Ngenxa yoko, itafile iya kugcina amaxabiso amanani angama-25 kunye ne-150.

Sibhozo

Idatha yolwazi yokucoca i-Filthang iyothusa kakhulu. Ukongeza kwimizekelo, kunokwenzeka ukuba uhlengahlengise idatha ngombala weeseli, ngokutsho koonobumba bokuqala bamagama kunye namanye amaxabiso. Ngoku, xa sasiqhuba ngokuqhelekileyo kunye neendlela zokwenza izihluzo kunye nemigaqo-nkqubo yokusebenza kunye nabo, yiya kwiziphumo zokususa.

Susa isihluzi sekholamu

1. Okokuqala, sifumana ifayile egciniweyo ngetafile kwikhompyuter yakho kunye nokucofa kabini i-LKM ukuyivula nge-Excel. Ephepheni eneetafile, unokubona ukuba isihluzo sikwimeko esebenzayo kwikholam yamaxabiso.

Thoba

1. Cofa kwindawo ye-arrow phantsi.
2. Kwibhokisi yencoko yababini evula, uyabona ukuba uphawu lwetsheki malunga namaNxambazana "25" uyasuswa. Ukuba ukucoceka okusebenzayo kwasuswa kwindawo enye kuphela, ke eyona ndlela ilula yokufaka ilebhile kwaye ucofe iqhosha u "Kulungile".
3. Ngaphandle koko, kuyimfuneko ukucima icebo lokucoca. Ukwenza oku, kwifestile enye kuya kufuneka ufumane umtya "Cima isihluzo esivela kwikholamu" ... "kwaye ucofe kuyo i-LKM. Kuya kubakho ukuvalwa okuzenzekelayo, kwaye yonke idatha efakiweyo iya kuboniswa ngokupheleleyo.

10

Ukususa isihluzo kwiphepha lonke

Ngamanye amaxesha iimeko zinokwenzeka xa kufuneka isuse icebo lokucoca wonke itafile. Ukwenza oku, kuya kufuneka wenze ezi zinto zilandelayo:

1. Vula ifayile ngedatha egciniweyo kwi-Excel.
2. Fumana ikholamu enye okanye aliqela apho isihluzo senziwa khona. Kule meko, eli likholamu "yegama".

Shumi elinanye

1. Cofa kuyo nayiphi na indawo etafileni okanye uyibalaseli ngokupheleleyo.
2. Ngaphezulu, fumana "idatha" kwaye usebenze i-LKM yazo.

12

1. "Isihluzi". Ukuchasene nekholamu ziimpawu ezintathu ngendlela ye-funnel ngeendlela ezahlukeneyo. Cofa kwiqhosha lokuSebenza "Icacile" kunye ne-furnel ebonisiweyo kunye ne-Red Cherhair.
2. Okulandelayo kuya kucima iifilitha ezisebenzayo kwitafile.

Ukuqukumbela

Izinto zokucoca kunye neenqobo zokuziphatha zetafile ziququzelela umsebenzi nge-Excel, kodwa ngelishwa, umntu unomdla wokwenza iimpazamo. Kule meko, inkqubo ye-Excenlity ye-Excel ye-Excel iza kuhlangula, eya kuthi incede icwangcise idatha kwaye isuse iifilitha ezingafunekiyo ezingeniswe ngaphambili ngolondolozo lwedatha yemithombo. Eli nqaku liluncedo ngakumbi xa ugcwalisa iitafile ezinkulu.

Umyalezo Ungayisusa njani icebo lokucoca i-Excel kwi-Excel kuqala kwitekhnoloji yolwazi.