Ntau zaus, qhov kawg tshwm sim ntawm kev ua haujlwm ntawm daim ntawv Excel yog luam ntawv nws. Yog tias koj xav sau tag nrho cov ntsiab lus ntawm cov ntawv rau lub tshuab luam ntawv, ces qhov no yooj yim heev. Tab sis yog tias tsuas yog ib feem ntawm daim ntawv yuav tsum luam tawm, teeb meem pib nrog kev teeb tsa qhov txheej txheem no. Cia peb pom cov nuances lub ntsiab ntawm cov txheej txheem no.
Ntawv luam tawm ntawm nplooj ntawv
Thaum luam cov nplooj ntawv ntawm ib daim ntawv, koj tuaj yeem tsim thaj chaw luam tawm txhua zaus, lossis koj tuaj yeem ua qhov no ib zaug thiab khaws nws rau hauv cov ntawv teev cia. Hauv rooj plaub thib ob, cov kev zov me nyuam yuav ib txwm muab rau tus neeg siv los sau cov lus tseeb uas nws tau qhia ua ntej. Cia peb xav txog ob qho ntawm cov kev xaiv no siv piv txwv ntawm Excel 2010. Txawm hais tias qhov kev txiav txim siab no tuaj yeem siv rau cov tom qab hloov ntawm qhov program no.
Txoj Kev 1: kev teeb ib zaug
Yog tias koj npaj siab yuav luam thaj tsam ntawm daim ntawv mus rau lub tshuab luam ntawv ib zaug xwb, tom qab ntawv tsis muaj ib qho yuav raug teeb meem ntawm thaj chaw luam tawm hauv nws. Nws yuav txaus los thov qhov kev ua ib zaug, uas qhov kev zov me nyuam yuav tsis nco qab.
- Xaiv thaj chaw ntawm daim ntawv uas koj xav sau nrog nas thaum tuav khawm sab laug. Tom qab ntawd, mus rau hauv lub tab Cov ntaub ntawv.
- Hauv seem ntawm qhov rais uas qhib, mus rau "Luam Tawm"Cov. Nyem rau ntawm daim teb uas nyob tam sim ntawd hauv qab lo lus "Teeb"Cov. Daim ntawv teev cov npe xaiv kev xaiv qhib:
- Luam tawm cov nplooj ntawv ua haujlwm nquag;
- Sau tag nrho phau ntawv;
- Xaiv xaiv.
Peb xaiv cov kev xaiv kawg, vim nws tsuas haum rau peb rooj plaub.
- Tom qab ntawd, tsis yog tag nrho cov nplooj ntawv tseem nyob hauv thaj chaw saib ua ntej, tab sis tsuas yog xaiv tau ua ntu. Tom qab ntawd, txhawm rau coj cov txheej txheem luam tawm ncaj qha, nyem rau ntawm lub pob "Luam Tawm".
Tom qab ntawv, qhov tseeb ntawm daim ntawv uas koj xaiv yuav raug luam tawm ntawm lub tshuab luam ntawv.
Txoj Kev 2: Teeb Chaw Nyob ruaj khov
Tab sis, yog tias koj npaj ua ntu ua ntu sau tib thooj ntawm cov ntawv, nws ua rau nws pom nws ua thaj chaw luam tawm tas li.
- Xaiv qhov ntau ntawm daim ntawv uas koj yuav ua rau thaj chaw luam tawm. Mus rau hauv lub tab Nplooj Phaj NtawvCov. Nyem rau feem khawm "Luam Cheeb Tsam", uas yog nyob ntawm lub xov xov hauv pab pawg pawg Nplooj Ntawv ChawCov. Hauv cov ntawv qhia me uas tshwm sim, muaj ob yam, xaiv lub npe "Teeb".
- Tom qab ntawd, cov chaw ruaj khov tau teeb tsa. Kom paub tseeb tias qhov no, mus rau lub tab dua Cov ntaub ntawv, thiab tom qab ntawd tsiv mus nyob rau ntu ntawd "Luam Tawm"Cov. Raws li koj tuaj yeem pom, hauv qhov saib ua ntej lub qhov rais koj tuaj yeem pom raws nraim thaj chaw uas peb tau teev tseg.
- Txhawm rau tuaj yeem luam tawm cov ntawv tawg tshwj xeeb no los ntawm lub neej ntawd raws li cov ntaub ntawv qhib tom qab, peb rov qab mus rau ntawm lub tab "Tsev"Cov. Txhawm rau kom txuag tau cov kev hloov pauv, nyem rau ntawm lub pob hauv daim ntawv ntawm tsis sib cais rau ntawm kaum tsev sab sauv ntawm lub qhov rais.
- Yog tias koj yuav tsum luam tawm tag nrho cov ntawv ntuag lossis lwm daim ntawv tawg, ces hauv qhov no koj yuav xav tau tshem tawm thaj chaw luam tawm. Nyob hauv kab Nplooj Phaj Ntawvnyem rau ntawm txoj hlua ntawm khawm "Luam Cheeb Tsam"Cov. Hauv daim ntawv qhib uas, nyem rau ntawm qhov khoom "Tshem tawm"Cov. Tom qab cov yeeb yam no, qhov chaw luam tawm hauv cov ntawv no yuav raug neeg xiam, uas yog, kev teeb tsa yuav raug xa rov qab rau lub xeev xwm txheej, zoo li tus neeg siv tsis tau hloov dab tsi.
Raws li koj tuaj yeem pom, teev qhov tshwj xeeb ib qho rau cov zis rau lub tshuab luam ntawv hauv cov ntaub ntawv Excel tsis yog qhov nyuaj li nws yuav zoo li rau ib tug neeg thaum xub thawj siab ib muag. Ib qho ntxiv, koj tuaj yeem tsim qhov chaw luam tawm tsis tu ncua, uas qhov kev zov me nyuam yuav muab rau cov ntaub ntawv luam tawm. Txhua lub sijhawm tau ua nyob rau hauv qee yam kev nias.
