Microsoft Excel yog lub cuab yeej zoo rau kev npaj koj cov ntaub ntawv. Nov yog phau ntawv qhia rau lub hauv paus tab sis muaj txiaj ntsig zoo ua haujlwm, txheeb koj cov ntaub ntawv raws tus lej.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Txheeb Raws Tus Qauv
Kauj Ruam 1. Hom kab taub hau
Kab ntawv kab taub hau yog kab saum toj kawg nkaus ntawm koj daim ntawv teev npe, nrog cov npe ntawm koj kab ntawv. Excel qee zaum yuav txheeb cov kab no xav tias nws yog ib feem ntawm koj cov ntaub ntawv, tshwj xeeb tshaj yog tias koj daim ntawv nthuav qhia yog cov ntawv nkaus xwb. Nov yog ob peb txoj hauv kev los tiv thaiv qhov no:
- Format koj header kab txawv. Piv txwv li, ua siab tawv cov ntawv lossis ua kom nws txawv xim.
- Nco ntsoov tias tsis muaj cov xov tooj ntawm tes dawb huv hauv koj kab kab lus.
- Yog tias Excel tseem tau txheeb xyuas qhov xaiv, xaiv kab ntawv kab ntawv sab saum toj thiab siv cov ntawv qhia zaub mov saum toj kawg nkaus txhawm rau nyem Tsev → Hloov Kho → Sort & Filter → Custom Sort → Kuv cov ntaub ntawv muaj headers.
Kauj Ruam 2. Xaiv kab ntawv uas koj xav ua tus tsiaj ntawv
Koj tuaj yeem nyem lub header cell rau kab ntawv ntawd, lossis tsab ntawv saum toj no (A, B, C, D, thiab lwm yam).
Kauj Ruam 3. Qhib Cov Ntaub Ntawv tab
Nyem Cov Ntaub Ntawv hauv cov ntawv qhia zaub mov sab saum toj kom pom cov ntaub ntawv xaiv hauv kab ntawv kab ntawv saum toj no koj daim ntawv nthuav qhia.
Kauj Ruam 4. Saib rau Sort and Filter section
Cov ntawv qhia zaub mov ribbon tau muab faib ua thaj chaw muaj feem cuam tshuam nrog lub npe nyob hauv qab txhua tus. Saib rau thaj tsam uas muaj npe Sort & Filter.
Yog tias koj tsis pom nws ntawm Cov Ntawv Qhia zaub mov, sim rov qab mus rau Lub Tsev tab thiab nrhiav rau Sort & Filter khawm hauv ntu Kho kom raug
Kauj Ruam 5. Nyem rau A -Z khawm
Txhawm rau txheeb cov ntawv nthuav tawm hauv tus lej, tsuas yog nyem lub cim A → Z hauv Sort and Filter section. Qhov no yuav rov teeb tsa daim ntawv nthuav tawm raws li tus lej ntawm kab ntawv xaiv. Ntawm feem ntau ntawm Excel, lub pob no yog nyob rau sab laug sab laug ntawm Sort and Filter section.
Txhawm rau txheeb nws hauv qhov rov qab ua cov ntawv raws tus lej, nyem Z -A lub cim hloov chaw
Txoj Kev 2 ntawm 2: Txheeb Los Ntawm Lub Xeem
Kauj Ruam 1. Siv qhov no thaum koj daim ntawv teev npe siv tag nrho cov npe hauv ib lub cell
Yog tias koj muaj cov npe tag nrho teev nyob rau hauv ib kab lus, kev ua niam txiv yuav tsuas yog txheeb raws lub npe. Nrog cov lus qhia no, koj tuaj yeem faib cov npe ua ob kab ua ntej yog li koj tuaj yeem txheeb los ntawm kab ntawv lub npe kawg.
Kauj Ruam 2. Ntxig kab ntawv tshiab tshiab
Muab qhov no tam sim rau sab xis ntawm cov npe kab.
Kauj Ruam 3. Nkag mus rau tus lej rau lub npe
Nkag mus rau cov qauv no hauv lub cell sab saum toj ntawm kab ntawv tshiab: = LEFT (A1, Nrhiav ("", A1)) xyuas kom suav nrog qhov chaw nruab nrab ntawm cov lus hais. Cov mis no yuav saib hauv kab npe tag nrho thiab luam txhua yam ua ntej qhov chaw
- Yog tias tsim nyog, hloov ob qhov xwm txheej ntawm A nrog tsab ntawv ntawm kab ntawv uas muaj cov npe tag nrho teev tseg.
- Hloov ob qho piv txwv ntawm 1 nrog tus lej ntawm kab koj tab tom ntaus.
Kauj Ruam 4. Luam cov mis no mus rau tag nrho kab ntawv
Nyem lub taub hau ntawm kab ntawv tshiab no thiab luam-muab cov mis uas koj nyuam qhuav nkag mus. Koj yuav tsum pom txhua lub npe tshwm ntawm lawv tus kheej hauv kab ntawv no.
Kauj Ruam 5. Tsim lub npe kab sab saud
Tsim kab ntawv tshiab rau sab xis ntawm thawj lub npe kab. Luam-muab cov mis no tso rau hauv kab nrog lub xeem lub npe:
= RIGHT (A1, LEN (A1) -FIND ("", A1))
Kauj Ruam 6. Txheeb los ntawm kab ntawv lub xeem
Tam sim no koj tuaj yeem txheeb npe lub npe kab ntawv raws tus lej, raws li tau piav qhia hauv cov txheej txheem saum toj no.
