01 ntawm 02
Tshem Cov Ntaub Ntawv Cov Ntaub Ntawv hauv Excel
Spreadsheet cov kev pab cuam xws li Excel yog siv raws li databases rau tej yam xws li cov khoom seem, cov ntawv muag khoom, thiab cov npe xa ntawv.
Databases hauv Excel yog ua los ntawm lub rooj ntawm cov ntaub ntawv uas nquag txhawm rau hauv cov kab lus ntawm cov ntaub ntawv hu ua cov ntaub ntawv.
Hauv cov ntaub ntawv, cov ntaub ntawv nyob hauv txhua lub xovtooj los yog teb ntawm kab lus muaj feem xyuam - xws li lub tuam txhab npe, chaw nyob thiab xov tooj.
Ib qho teeb meem tshwm sim uas tshwm sim los ntawm cov ntaub ntawv database loj me me yog tias cov ntaub ntawv sib npaug los yog kab lus ntawm cov ntaub ntawv.
Qhov kev sib hloov no tuaj yeem tshwm sim yog tias:
- Tag nrho cov ntaub ntawv teev npe nkag mus rau hauv cov ntaub ntawv ntau dua ib zaug ua rau ob lossis ntau ntau cov ntaub ntawv zoo sib xws
- Ntau cov ntaub ntawv muaj ib los yog ntau dua li cov teb - xws li lub npe thiab chaw nyob - muaj cov ntaub ntawv tib yam.
Txhua txoj kev, duplicate cov ntaub ntawv tuaj yeem ua rau tag nrho cov tswv yim ntawm cov teeb meem - xws li xa ntau cov ntawv luam ntawm cov ntaub ntawv rau tus tib neeg thaum cov ntaub ntawv database siv nyob rau hauv kev xa ntawv ua ke - yog li nws yog ib lub tswv yim zoo rau luam theej thiab tshem tawm cov ntaub ntawv sib txawv ntawm ib txwm hauv paus.
Thiab thaum nws yooj yim los xaiv cov ntaub ntawv sib txawv hauv cov qauv me me xws li ib daim duab saum toj no, cov ntaub ntawv cov lus yuav yooj yim muaj pua pua yog hais tias tsis txhiab cov ntaub ntawv ua rau nws tsis yooj yim xaiv cov ntaub ntawv sib txawv - tshwj xeeb tshaj yog cov ntaub ntawv txuam.
Kom nws yooj yim ua kom tiav txoj hauj lwm no, Excel tau ua rau hauv cov ntaub ntawv cov cuab yeej hu, tsis ceeb, Tshem Duplicates , uas siv tau los nrhiav thiab tshem tawm zoo tib yam thiab cov ntaub ntawv sib hloov.
Txawm li cas los xij, txoj kev tshem tawm Cov Cuam Tshuam tawm yog tsim, zoo tib yam thiab cov ntaub ntawv sib txawv ntawm cov ntaub ntawv yuav tsum raug sib cais nrog nyias.
Qhov no yog vim tias Tshem Tawm Tshem Tawm Tshem tawm cov lus teb rau cov lus xaiv cov lus qhia thiab koj xaiv yam kev khomob uas muaj nyob hauv kev tshawb nrhiav cov ntaub ntawv khaws tseg:
- Rau cov ntaub ntawv zoo sib xws, tshawb tag nrho cov hauj lwm - tawm ntawm cov cim ntawm kab npe tag nrho los sis cov npe ntawm thaj chaw;
- Rau cov ntaub ntawv txua me me - tawm ntawm cov cim kos rau ntawm cov cheeb tsam uas yuav tsum sib phim.
Daim Npe Npe thiab Npe Kem
Raws li tau hais, Cov Tshem Tawm Cov Tshem Tawm Tshawb tawm ntawm lub thawv uas koj xaiv xaiv qhov chaw mus tshawb nrhiav los ntawm kev khaw lub teb yam los sis lub npe kem.
Cov ntaub ntawv uas lub thawv ntawv qhia - lub npe los yog cov ntawv sau qhia kab ntawv - nyob ntawm seb koj cov ntaub ntawv muaj kab ntawm cov kab lus - los yog lub hau - ntawm sab saum toj ntawm cov ntaub ntawv raws li pom hauv daim duab saum toj no.
Yog tias nws ua - xyuas kom muaj qhov kev xaiv ntawm sab xis ntawm lub thawv sab nrauv - Kuv cov ntaub ntawv muaj cov headers - kuaj thiab Excel yuav tso tawm cov npe hauv kab no yog cov npe hauv lub thawv.
Yog tias koj cov ntaub ntawv tsis muaj lub tsho, lub thawv ntawv sib txuas lus yuav pom cov ntawv sau rau cov kab lus tsim nyog rau hauv lub thawv ntawv sib tham rau ntau ntau ntawm cov ntaub ntawv.
Contiguous ntau ntawm cov ntaub ntawv
Rau qhov Tshem Tawm Cov Tshem Tawm tshem tawm , cov ntaub ntawv yuav tsum yog ib qho kev sib txuas ntawm cov ntaub ntawv - uas yog nws yuav tsum tsis txhob muaj cov kab tsis muaj kab, txhua, thiab, yog tias ua tau, tsis muaj hlwb dawb nyob rau hauv rooj.
Tsis muaj cov lej nyob rau hauv cov ntaub ntawv cov lus qhia yog ib qho kev xyaum zoo thaum nws tuaj cuag cov ntaub ntawv tswj txhua tus thiab tsis yog thaum tshawb nrhiav cov ntaub ntawv theej tawm. Excel tus lwm cov ntaub ntawv cov cuab yeej - xws li kev cais thiab lim - ua hauj lwm zoo tshaj plaws thaum cov lus qhia cov lus yog ib qho kev sib txuas ntawm cov ntaub ntawv.
Tshem Cov Ntaub Ntawv Qhia Cov Ntaub Ntawv Cov Ntaub Ntawv
Hauv daim duab saum toj no, cov ntaub ntawv muaj 2 daim ntawv pov thawj rau A. Thompson thiab ob qho yeebyam rau R. Holt - qhov chaw txhua qhov sib piv tsuas yog tus menyuam kawm ntawv tus naj npawb.
Cov kauj ruam nram qab no qhia meej txog kev siv Cov Tshem Tawm Tshem tawm cov cuab yeej rau:
- Tshem ob ntawm ob qhov xwm txheej zoo tib yam rau A. Thompson.
- Tshem cov ntaub ntawv thib ob rau R. Holt.
Qhib Cov Tshem Tawm Tshem tawm Dialog Box
- Nias rau ntawm ib lub xov tooj uas muaj cov ntaub ntawv hauv cov qauv database.
- Tshawb cov ntaub ntawv sau rau ntawm daim ntawv sau.
- Nias ntawm Qhov Tshem Cov Duplicates Tshem tawm los tag nrho cov ntaub ntawv nyob hauv cov ntaub ntawv thiab qhib lub Tshem Tawm Tshem Xov Tooj.
- Cov Tshem Tawm Cov Tshem Tawm Tshem tawm lus qhia tag nrho cov lus qhia kiag lossis lub npe ntawm cov npe ntawm peb cov qauv ntaub ntawv
- Daim cim khij ntawm cov npe ntawm lub npe qhia tias leej twg Excel yuav sim ua kom sib piv rau cov ntaub ntawv sib txawv
- Los ntawm lub neej ntawd, thaum lub thawv qhib tawm tag nrho cov npe ntawm cov npe tau kuaj
Nrhiav Cov Ntaub Ntawv Khaws Tseg
- Vim tias peb tab tom nrhiav cov ntaub ntawv zoo sib xws tag nrho hauv qhov kev piv txwv no peb yuav tawm tag nrho cov lus qhia kiag ntawm sablaj
- Nyem OK
Txij ntawm no mus rau cov ntsiab lus nram qab no yuav tsum pom:
- Lub thawv ntawv sib tham yuav tsum kaw thiab muab hloov los ntawm cov lus hais: 1 qhov kev ntseeg qub txawb tau pom thiab tshem tawm; 7 nws qhov tseem ceeb nyob.
- Cov kab uas muaj cov duplicate A Thompson cov ntaub ntawv yuav tau raug muab tshem tawm ntawm lub database
- Txawm tias muaj ob txoj kev hloov cov ntaub ntawv rau R. Holt, vim tias tsis yog txhua lub teb zoo sib xws - tus tub ntxhais kawm tus naj npawb ntawm ob qho kev sau sib txawv - Excel xam nws yog ib daim ntawv teev cov ntaub ntawv
02 ntawm 02
Nrhiav thiab Tshem Cov Tshaj Cov Sib Tw Tshaj Nrog Tshem Cov Ntawv Sau Tseg
Khij Lub Tebchaws Ib Lub Sijhawm
Vim tias tsuas yog Excel tshem tawm cov ntaub ntawv cov ntaub ntawv khaws tseg rau cov xaiv ntawm cov ntaub ntawv, qhov zoo tshaj plaws los mus nrhiav tau cov ntaub ntawv teev cov ntaub ntawv txhawm rau tshem tawm cov cim kos rau ib qho ntawm ib lub sij hawm, raws li tau ua nyob rau hauv cov kauj ruam hauv qab no.
Cov kev tshawb nrhiav tom qab rau cov ntaub ntawv sib piv hauv txhua cheeb tsam tshwj tsis yog tias lub npe, hnub nyoog, lossis kev kawm yuav tshem tag nrho cov kev sib txuas ua ke rau cov ntaub ntawv sib txawv.
Nrhiav Ib Daim Ntawv Teev Tseg
- Nias rau ntawm ib lub xov tooj uas muaj cov ntaub ntawv nyob hauv cov ntaub ntawv yog tias tsim nyog
- Tshawb cov ntaub ntawv sau rau ntawm daim ntawv sau .
- Nias ntawm Qhov Tshem Cov Duplicates Tshem tawm los tag nrho cov ntaub ntawv nyob hauv cov ntaub ntawv thiab qhib lub Tshem Tawm Tshem Xov Tooj.
- Tag nrho cov npe ntawm lub npe los yog lub npe ntawm sab ntawv rau cov lus qhia cov lus xaiv tau raug xaiv.
- Nrhiav thiab tshem tawm cov ntaub ntawv uas tsis muaj ib qho kev sib tw hauv txhua daim teb, tshem tus cim kos los ntawm cov npe ntawm Excel uas tsis pom zoo.
- Rau qhov ua piv txwv no nias ntawm lub thawv ntawm sab nraud ntawm kem ID Student heading kom tshem lub cim kos.
- Excel yuav tam sim no tsuas yog nrhiav thiab tshem tawm cov ntaub ntawv uas muaj txuam cov ntaub ntawv ntawm Lub Xeem , Qhov Kev Xam Xaj , thiab Kev Tshawb Fawb .
- Nyem OK
- Lub thawv ntawv sib tham yuav tsum kaw thiab muab hloov los ntawm cov lus hais: 1 qhov kev ntseeg qub txawb tau pom thiab tshem tawm; 6 nws qhov tseem ceeb nyob.
- Cov kab uas muaj cov ntawv teev npe thib ob rau R. Holt nrog Tus Neeg Kawm Ntawv Tus ID ntawm ST348-252 yuav raug muab tshem tawm ntawm cov ntaub ntawv.
- Nyem OK kom kaw cov lus kaw
Txij ntawm no mus, cov piv txwv cov ntaub ntawv yuav tsum pub dawb ntawm txhua cov ntaub ntawv sib npaug.