Ntau zaus, qhov xwm txheej tshwm sim thaum, thaum luam ntawv, nplooj ntawv tawg hauv qhov chaw tsis tsim nyog tshaj plaws. Piv txwv, qhov tseem ceeb ntawm lub rooj yuav tshwm rau ntawm ib nplooj ntawv, thiab kab kawg ntawm thib ob. Hauv qhov no, qhov teeb meem tsiv los lossis tshem tawm qhov sib txawv no muaj feem cuam tshuam. Cia peb pom yuav ua li cas nws thiaj ua tiav thaum ua haujlwm nrog cov ntaub ntawv hauv ib qho Excel spreadsheet processor.
Saib ntxiv: Yuav ua li cas thiaj li tshem tau nplooj ntawv nplooj hauv Excel
Hom ntawm ntu ntawm daim ntawv thiab cov txheej txheem rau lawv tshem tawm
Ua ntej tshaj, koj yuav tsum paub tias nplooj ntawv so tuaj yeem tuaj yeem ua ob hom:
- Ntaus tes los ntawm tus neeg siv;
- Yuav tso rau ntawm qhov program ntawd.
Raws li, cov hau kev rau kev tshem tawm ob hom kev sib cais no sib txawv.
Thawj zaug ntawm lawv tshwm nyob rau hauv daim ntawv tsuas yog tus neeg siv nws tus kheej ntxiv nws siv cov cuab yeej tshwj xeeb. Nws tuaj yeem txav thiab tshem tawm. Qhov thib ob hom kev tsis pom kev yog affixed cia li los ntawm lub programme. Nws tsis tuaj yeem raug tshem tawm, tab sis tuaj yeem hloov mus xwb.
Txhawm rau pom qhov chaw ntu ntu ntawm nplooj ntawv yog nyob ntawm saib, tsis tas luam daim ntawv nws tus kheej, koj yuav tsum hloov mus rau nplooj ntawv hom. Qhov no tuaj yeem ua los ntawm txhaj rau lub cim. "Nplooj ntawv", uas yog lub cim zoo nyob hauv peb navigation cim ntawm nplooj ntawv saib hom. Cov cim no tau nyob hauv lub xwm txheej bar rau sab laug ntawm qhov cuab yeej zoom.
Kuj tseem muaj kev xaiv nkag mus rau nplooj ntawv hom los ntawm mus rau hauv tab "Saib"Cov. Muaj koj yuav tsum tau nyem rau ntawm lub pob, uas yog hu ua - Nplooj Hom thiab muab tso rau daim kab xev rau hauv block Phau Ntawv Saib Cov Qauv.
Tom qab hloov mus rau nplooj ntawv hom, dissections yuav pom. Cov uas muaj kev cog lus ncaj qha los ntawm qhov kev zov me nyuam yog qhia los ntawm kab sau kab, thiab cov tau siv los ntawm cov neeg siv tau qhia los ntawm cov kab xiav xiav.
Peb rov qab mus rau qhov qub version ntawm kev ua haujlwm nrog daim ntawv. Nyem rau lub cim "Li Qub" ntawm cov xwm txheej bar lossis los ntawm cov qub icon ntawm tus xov hauv lub tab "Saib".
Tom qab hloov mus rau hom kev saib zoo li qub los ntawm nplooj ntawv hom, qhov cim ntawm qhov khoob tseem yuav tshwm rau ntawm daim ntawv. Tab sis qhov no yuav tshwm sim tsuas yog tus neeg siv hloov mus rau nplooj ntawv saib ntawm daim ntawv. Yog tias nws tsis ua li ntawd, ces nyob hauv hom kev teeb tsa tus kheej, nws yuav tsis pom kev. Yog li, hauv cov txheej txheem ib txwm, cov kev cais tawm tau pom me ntsis txawv. Cov uas tau txais los ntawm qhov kev zov me nyuam yuav pom zoo li cov kab me me, thiab artificially tsim los ntawm cov neeg siv raws li cov kab loj loj.
Txhawm rau saib seb daim ntawv "nraus" yuav zoo li cas rau luam tawm, tsiv mus rau ntawm lub tab Cov ntaub ntawvCov. Tom ntej no, mus rau ntu ntawd "Luam Tawm"Cov. Nyob rau sab xis ntawm lub qhov rais yuav yog thaj chaw saib ua ntej. Koj tuaj yeem saib cov ntaub ntawv los ntawm kev hloov chaw lub pob txav thiab hauv qab.
Tam sim no cia peb kawm seb yuav kho qhov teeb meem no li cas.
Txoj Kev 1: rho tawm txhua daim ntawv ntxig ua manually
Ua ntej tshaj plaws, cia saib xyuas ntawm kev tshem tawm cov nplooj ntawv ua haujlwm manually.
- Mus rau hauv lub tab Nplooj Phaj NtawvCov. Nyem rau ntawm txoj hlua khawm Txhawmmuab tso rau hauv lub block Nplooj Ntawv ChawCov. Daim ntawv teev cia nyob rau. Ntawm cov kev xaiv uas tau nthuav tawm hauv nws, xaiv Rov Pib Nplooj Ntawv.
- Tom qab cov kauj ruam no, tag nrho cov nplooj ntawv so ntawm Excel tam sim no uas tau muab sau los ntawm tus kheej siv los ntawm cov neeg siv yuav raug muab tshem tawm. Tam sim no, thaum luam ntawv, nplooj ntawv yuav tawg tsuas yog qhov twg daim ntawv thov taw qhia nws.
Txoj kev 2: rho tawm ib tug neeg manually ntxig rau kis
Tab sis deb ntawm txhua qhov xwm txheej, nws yog qhov yuav tsum tau rho tawm txhua nplooj ntawv phau ntawv rhuav tshem los ntawm cov neeg siv. Hauv qee qhov xwm txheej, qee feem ntawm kev tsim txom yuav tsum sab laug, thiab qee qhov yuav tsum tau muab tshem tawm. Saib seb yuav ua li cas thiaj ua tau tiav li no.
- Xaiv ib lub xov tooj ntawm nyob ncaj nraim rau hauv qhov sib txawv uas yuav tsum tau tshem tawm los ntawm cov ntawv. Yog hais tias qhov dissection yog ntsug, tom qab qhov no peb xaiv lub keeb mus rau sab xis ntawm nws. Txav mus rau tab Nplooj Phaj Ntawv thiab nias rau ntawm lub cim TxhawmCov. Lub sijhawm no koj yuav tsum xaiv xaiv los ntawm daim ntawv teev hauv qab. "Rho tawm nplooj so".
- Tom qab qhov kev txiav txim no, tsuas yog cov dissection uas tau nyob sab saud ntawm tes yuav raug tshem tawm.
Yog tias tsim nyog, tib txoj kev, koj tuaj yeem tshem tawm qhov kev txiav ntxiv ntawm daim ntawv, uas tsis muaj qhov xav tau.
Txoj Kev 3: tshem tawm qhov sib txuam manually los ntawm kev txav nws
Koj tseem tuaj yeem tshem tawm cov ntxig ntawm tes tau txav los ntawm kev tsiv lawv mus rau ciam teb ntawm daim ntawv.
- Mus rau nplooj ntawv saib ntawm phau ntawv. Teem tus cursor rau cov kis sib txawv ua cim los ntawm kab xiav xiav ruaj khov. Hauv qhov no, tus cursor yuav tsum hloov pauv mus rau hauv lub cim qhia txog ob-txoj kev taw qhia. Tuav lub khawm laug nas thiab sau cov kab ntawv no coj los rau ciam teb ntawm daim ntawv.
- Tom qab koj mus txog tus ciam teb ntawm daim ntawv, tso tus nas khawm. Ntu no yuav muab tshem tawm los ntawm cov nplooj ntawv tam sim no.
Txoj Kev 4: kev txav sib tsoo tsis siv neeg
Tam sim no cia saib yuav ua li cas nplooj ntawv tawg tau tsim los ntawm qhov kev zov me nyuam tuaj yeem muab tshem tawm, yog tias tsis tshem tawm, tom qab ntawd tsawg kawg tsiv raws li tus neeg siv xav tau.
- Mus rau nplooj ntawv hom. Hover hla ntu ntu qhia los ntawm kab zas. Tus cursor tau hloov dua siab tshiab rau ob-qhov kev taw qhia lub xub. Clamp rau sab laug nas khawm. Txheeb qhov sib txawv rau sab uas peb xav tias tsim nyog. Piv txwv li, dissections feem ntau yuav txav mus rau ciam teb ntawm daim ntawv. Ntawd yog, peb ua tus txheej txheem zoo ib yam nrog tus txheej txheem uas tau ua hauv dhau los ntawm kev ua.
- Hauv qhov no, kev so tsis siv neeg yuav tuaj yeem nqa tawm rau cov ciam teb ntawm daim ntawv, lossis tsiv mus rau qhov chaw zoo rau tus neeg siv. Hauv rooj plaub tom kawg, nws yuav hloov pauv mus ua qhov cuav kev sib txawv. Tam sim no nws yog ntawm lub sijhawm no thaum luam ntawv yuav tsoo nplooj ntawv.
Raws li koj tuaj yeem pom, ua ntej ua cov txheej txheem rau kev tshem tawm qhov sib txawv, koj yuav tsum paub seb hom khoom twg nws muaj: tsis siv neeg lossis tsim neeg siv. Cov txheej txheem tshem tawm nws feem ntau yuav yog nyob ntawm qhov no. Tsis tas li ntawd, nws yog qhov tseem ceeb heev kom nkag siab txog yam dab tsi uas yuav tsum tau ua nrog nws: tshem tawm nws kiag li lossis hloov nws mus rau lwm qhov chaw hauv daim ntawv. Lwm lub ntsiab lus tseem ceeb yog li cas cov khoom tawg ntawd cuam tshuam rau lwm qhov kev txiav rau ntawm daim ntawv. Tom qab tag nrho, thaum koj rho tawm lossis tshem ib lub sijhawm, txoj haujlwm rau ntawm daim ntawv thiab lwm qhov khoob yuav hloov. Yog li no, qhov nuance no yog qhov tseem ceeb heev uas yuav tau xav txog tam sim ua ntej yuav pib txoj kev tshem tawm.
