Kab lus no tham txog yuav ua li cas sib piv cov ntaub ntawv ntawm ob daim ntawv Excel. Thaum koj muaj peev xwm tswj hwm thiab sib piv cov ntaub ntawv, koj tuaj yeem siv qhov "Look Up", "Index" thiab "Match" ua haujlwm los pab txheeb xyuas.
Kauj ruam
Txoj Kev 1 ntawm 4: Siv "Ib Sab Ntawm Ib Sab" Zaub Qhia hauv Excel
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas xav tau los sib piv
Koj tuaj yeem pom cov ntaub ntawv phau ntawv los ntawm kev qhib Excel, nyem rau " Cov ntaub ntawv ", xaiv" Qhib ", Thiab nyem rau ntawm ob phau ntawv ua haujlwm koj xav sib piv hauv cov ntawv qhia zaub mov uas tshwm.
Mus ntsib phau ntawv khaws cia phau ntawv ua haujlwm, xaiv txhua phau ntawv cais, thiab khaws ob phau ntawv windows qhib
Kauj ruam 2. Nyem rau Saib tab
Tom qab qhib phau ntawv, koj tuaj yeem nyem tab " Saib "Ntawm qhov chaw siab tshaj ntawm Excel qhov rai.
Kauj Ruam 3. Nyem Saib Side by Side
Qhov kev xaiv no nyob hauv ntu "Window" ntawm cov ntawv qhia zaub mov " Saib "Thiab tau qhia los ntawm ob daim ntawv cim. Ob daim ntawv ua haujlwm yuav raug nthuav tawm hauv qhov me me, ntsug ntsug stacked Excel qhov rai.
- Qhov kev xaiv no yuav tsis muaj nyob ntawm " Saib "Yog tias koj tsuas muaj ib phau ntawv qhib hauv Excel.
- Yog tias muaj ob phau ntawv qhib, Excel yuav cia li xaiv ob daim ntawv los saib ib sab.
Kauj Ruam 4. Nyem Npaj Txhua Yam
Qhov teeb tsa no tso cai rau koj hloov qhov kev taw qhia ntawm phau ntawv ua haujlwm thaum saib ib sab-ib-sab.
Hauv cov ntawv qhia zaub mov uas tshwm, koj tuaj yeem xaiv qhov kev xaiv los saib ob phau ntawv ua haujlwm (piv txwv li " Kab rov tav ”, “ ntsug ”, “ Cascade ", los yog" Pobzeb ”).
Kauj Ruam 5. Pab kom "Synchronous Scrolling" feature
Tom qab qhib ob phau ntawv ua haujlwm, nyem rau " Synchronous Scrolling "(Hauv qab kev xaiv" Saib Sab Ntawm Ib Sab ") Yog li koj tuaj yeem yooj yim hla ob daim ntawv Excel ua haujlwm ib kab thiab tshawb xyuas tus kheej rau qhov sib txawv hauv cov ntaub ntawv.
Kauj Ruam 6. Luag ib qho ntawm phau ntawv ua haujlwm txhawm rau hla ob nplooj ntawv
Thaum qhov "Synchronous Scrolling" feature tau qhib, koj tuaj yeem rub los ntawm ob nplooj ntawv ua haujlwm tib lub sijhawm thiab yooj yim sib piv cov ntaub ntawv uas twb muaj lawm.
Txoj Kev 2 ntawm 4: Siv Qhov "Nrhiav" Ua Haujlwm
Kauj Ruam 1. Qhib ob phau ntawv ua haujlwm uas xav tau los sib piv
Koj tuaj yeem pom nws los ntawm kev qhib Excel, nyem rau ntawm cov ntawv qhia zaub mov " Cov ntaub ntawv ", nyem" Qhib ", Thiab xaiv ob phau ntawv ua haujlwm los sib piv los ntawm cov ntawv qhia zaub mov.
Mus ntsib phau ntawv khaws cia phau ntawv, xaiv txhua phau ntawv cais, thiab khaws ob phau ntawv qhov rais qhib
Kauj Ruam 2. Qhia meej lub thawv uas tuaj yeem xaiv los ntawm tus neeg siv cov ntawv
Hauv lub npov no, cov npe sau cia yuav tshwm.
Kauj Ruam 3. Nyem rau lub npov
Cov kab sib chaws yuav tshwm sim tsaus dua tom qab txhaj.
Kauj Ruam 4. Nyem rau DATA tab ntawm lub cuab yeej
Thaum tab tau nyem, xaiv " VALIDATION "Hauv cov ntawv qhia zaub mov nco-down. Cov ntawv qhia zaub mov pop-up yuav tshwm tom qab ntawd.
Yog tias koj siv Excel qub, "DATA" toolbar yuav tshwm tom qab koj xaiv "tab". DATA ", Thiab qhia qhov kev xaiv" Kev Txheeb Xyuas Cov Ntaub Ntawv "nyob rau hauv qhov kev xaiv" Kev lees paub ”.
Kauj Ruam 5. Nyem Sau rau ntawm daim ntawv "ALLOW"
Kauj Ruam 6. Nyem lub pob nrog tus xub liab
Lub pob no tso cai rau koj xaiv lub hauv paus (hauv lwm lo lus, thawj kab ntawv) kom ua tiav rau hauv cov ntaub ntawv rau cov ntawv qhia zaub mov nco-down.
Kauj Ruam 7. Xaiv thawj kab ntawm daim ntawv thiab nyem Enter
Nyem " OK "Thaum lub qhov rai lees paub cov ntaub ntawv tau tshwm. Koj tuaj yeem pom lub npov uas muaj tus xub nyob hauv nws. Cov xub no yuav tso saib cov npe teev cia thaum nyem.
Kauj Ruam 8. Xaiv lub thawv uas koj xav siv los qhia lwm cov ntaub ntawv
Kauj Ruam 9. Nyem rau Insert and Reference tab
Hauv cov qauv ua ntej ntawm Excel, koj tsis tas yuav nyem " Ntxig "thiab tuaj yeem xaiv ncaj qha tab" Kev ua haujlwm "Los qhia qeb" Nrhiav & Siv ”.
Kauj Ruam 10. Xaiv Saib & Siv los ntawm cov npe ntawm pawg
Kauj Ruam 11. Tshawb nrhiav hauv daim ntawv
Thaum qhov kev xaiv tau nyem ob zaug, lwm lub thawv yuav tshwm thiab koj tuaj yeem xaiv qhov kev xaiv OK ”.
Kauj Ruam 12. Xaiv lub npov uas muaj daim ntawv teev npe nkag rau qhov "lookup_value" nkag
Kauj Ruam 13. Xaiv thawj kab hauv kab npe rau “Lookup_vector” nkag
Kauj Ruam 14. Xaiv kab thib ob hauv cov npe rau qhov "Result_vector" nkag
Kauj Ruam 15. Xaiv qhov nkag los ntawm daim ntawv teev npe
Cov ntaub ntawv yuav hloov pauv tom qab ntawd.
Txoj Kev 3 ntawm 4: Siv XL Comparator Service
Kauj Ruam 1. Qhib qhov browser thiab mus ntsib
Koj yuav raug coj mus rau XL Comparator lub vev xaib uas koj tuaj yeem luam ob phau ntawv Excel uas koj xav sib piv.
Kauj Ruam 2. Nyem Xaiv Cov Ntaub Ntawv
Lub qhov rai tshiab yuav qhib thiab koj tuaj yeem tshawb nrhiav ib qho ntawm ob daim ntawv Excel uas koj xav sib piv. Nco ntsoov tias koj xaiv cov ntawv los ntawm ob daim teb muaj nyob ntawm nplooj ntawv web.
Kauj Ruam 3. Nyem Next> mus ntxiv
Thaum qhov kev xaiv raug xaiv, cov lus pop-up yuav tshwm nyob rau sab saum toj ntawm nplooj ntawv qhia rau koj tias cov txheej txheem xa cov ntaub ntawv twb tau pib lawm, thiab cov ntaub ntawv loj yuav siv sijhawm ntev dua los ua. Nyem " Ok "Kom kaw cov lus.
Kauj Ruam 4. Xaiv kab ntawv koj xav luam theej duab
Hauv qab txhua lub npe cov ntaub ntawv, muaj cov ntawv qhia zaub mov nco tseg " Xaiv ib kem " Nyem rau cov ntawv qhia zaub mov nco-down ntawm txhua cov ntaub ntawv los xaiv kab uas koj xav kos thiab sib piv.
Cov npe kab ntawv yuav tshwm sim thaum koj nyem rau ntawm cov ntawv qhia zaub mov nco-down
Kauj Ruam 5. Xaiv cov ntsiab lus rau cov ntawv ua tiav
Muaj plaub txoj kev xaiv nrog cov zais zais ib sab ntawm lawv hauv pawg no. Ib ntawm lawv koj yuav tsum xaiv raws li phau ntawv qhia hom ntawv rau cov ntaub ntawv tshwm sim.
Kauj Ruam 6. Xaiv qhov kev xaiv kom yooj yim kem sib piv
Hauv lub npov hauv qab hauv cov ntawv sib piv, koj yuav pom ob lub lim dej ntxiv rau kev sib piv cov ntaub ntawv: " Tsis quav ntsej cov ntawv loj/ntawv me "thiab" Tsis quav ntsej "chaw" ua ntej thiab tom qab qhov tseem ceeb " Nyem rau ntawm lub checkboxes ntawm ob qho kev xaiv ua ntej txuas ntxiv.
Kauj Ruam 7. Nyem Next> mus ntxiv
Koj yuav raug coj mus rau nplooj ntawv rub tawm ntawm cov ntaub ntawv tshwm sim tom qab.
Kauj Ruam 8. Rub daim ntawv sib piv
Kauj Ruam 1. Nrhiav phau ntawv ua haujlwm thiab npe ua haujlwm
-
Hauv txoj hauv kev no, peb yuav siv peb phau ntawv ua piv txwv uas tau txais kev cawmdim thiab muaj npe raws li hauv qab no:
- C: / Thov rov hais dua Books1.xls (thauj cov ntawv nthuav qhia sau tias "Muag 1999")
- C: / Thov rov hais dua Books2.xls (thauj daim ntawv nthuav qhia "2000 Muag")
- Ob phau ntawv ua haujlwm muaj thawj kab “A” nrog lub npe khoom, thiab kab ntawv thib ob “B” nrog tus lej muag txhua xyoo. Thawj kab yog lub npe kab.
Kauj Ruam 2. Tsim phau ntawv sib piv
Koj yuav tsum tsim Buku3.xls los sib piv cov ntaub ntawv. Siv ib kab ntawv los tso saib cov npe khoom, thiab kab ntawv tom ntej rau qhov sib txawv ntawm cov khoom muag ntawm xyoo sib piv.
C: / Thov rov hais dua Books3.xls (thauj daim ntawv ua haujlwm sau tias "Qhov txawv")
Kauj Ruam 3. Muab lub npe tso rau hauv kab ntawv
Tsuas yog qhib daim ntawv "Book3.xls", tom qab ntawv nyem rau lub pob "A1" thiab ntaus:
- = 'C: / Thov rov hais dua [Book1.xls] Muag Xyoo 1999'! A1
- Yog tias koj tau khaws cov ntawv hauv cov npe sib txawv, hloov "C: / Banding \" nrog qhov chaw nyob ntawm cov npe ntawd. Yog tias koj siv lwm lub npe cov ntaub ntawv, hloov "Book1.xls" thiab nkag mus rau lub npe cov ntaub ntawv tsim nyog. Yog tias koj siv lwm daim ntawv npe/daim ntawv lo, hloov "Muag 1999" nrog cov npe ntawv/daim ntawv tsim nyog. Nco ntsoov tsis txhob qhib cov ntaub ntawv hais txog ("Book1.xls"). Excel tuaj yeem hloov pauv qhov siv ntxiv yog tias koj qhib nws. Koj tuaj yeem tau txais ib lub thawv uas muaj cov ntsiab lus/cov ntaub ntawv zoo ib yam li lub npov uas tau siv los ua kev qhia.
Kauj Ruam 4. Luag lub npov "A1" qis rau kom pom tag nrho cov npe khoom
Nyem rau sab xis sab xis ntawm lub npov thiab rub nqes los tso saib txhua lub npe.
Kauj Ruam 5. Npe lub kem thib ob
Txog qhov piv txwv no, koj tuaj yeem ntaus "Sib txawv" hauv "B1" lub npov.
Kauj Ruam 6. Kwv yees qhov sib txawv ntawm txhua qhov khoom muag (ua piv txwv rau kab lus no)
Hauv qhov ua piv txwv no, ntaus cov lus hauv qab no rau hauv lub thawv “B2”:
- = 'C: / Thov rov hais dua [Book2.xls] Muag 2000'! B2-'C: / Thov rov hais dua [Book1.xls] Muag 1999 '! B2
- Koj tuaj yeem siv Excel ib txwm ua haujlwm nrog lub thawv cov ntaub ntawv los ntawm cov ntaub ntawv siv.
