01 ntawm 08
Cov Ntaub Ntawv Tswj hauv Excel
Tej lub sij hawm, peb yuav tsum khaws cov lus qhia. Nws yog ib daim ntawv teev cov xov tooj ntawm tus kheej, tus neeg sau npe rau cov koom haum ntawm lub koom haum lossis pab pawg, lossis sau nyiaj ntawm npib, ntawv teev lus, lossis cov phau ntawv.
Txhua yam ntaub ntawv uas koj muaj, daim ntawv khom nqi , zoo li Excel, yog qhov chaw zoo khaws nws. Excel tau ua nws cov cuab yeej los pab koj kom khiav ntawm cov ntaub ntawv thiab nrhiav cov lus qhia thaum koj xav tau. Zoo li, nrog nws pua pua kab thiab txhiab tus kab, ib qho Excel spreadsheet muaj peev xwm tuav tau ntau npaum li cas ntawm cov ntaub ntawv .
Excel kuj yog yooj yim los siv dua ib qhov kev pabcuam database uas muaj xws li Microsoft Access. Cov ntaub ntawv yuav raug nkag tau yooj yim mus rau hauv lub spreadsheet, thiab, nrog ib txhia clicks ntawm nas koj tuaj yeem txheeb los ntawm koj cov ntaub ntawv thiab nrhiav yam koj xav tau.
02 ntawm 08
Tsim Cov Ntxhuav thiab Cov Npe
Cov txheej txheem yooj yim rau kev khaws cov ntaub ntawv hauv Excel yog lub rooj. Nyob rau hauv ib lub rooj, cov ntaub ntawv sau tseg hauv cov kab. Txhua kab yog hu ua cov ntaub ntawv .
Thaum twg ib lub rooj tsim tau, Excel cov ntaub ntawv cov cuab yeej siv tau los tshawb, cais, thiab lim cov ntaub ntawv los nrhiav cov ntaub ntawv.
Txawm hais tias muaj ntau txoj hauv kev uas koj siv tau cov cuab yeej cov ntaub ntawv no hauv Excel, qhov yoojyim tshaj ntawm kev ua tau li ntawd, los tsim tej yam uas tau hu ua cov npe hauv cov ntaub ntawv.
03 ntawm 08
Kev Sau Cov Ntaub Ntawv Tiag
Thawj kauj ruam hauv kev tsim ib lub rooj yog nkag mus rau cov ntaub ntawv. Thaum ua li ntawd, nws yog ib qho tseem ceeb los xyuas kom meej tias nws nkag mus kom raug.
Cov ntaub ntawv yuam kev, vim yog cov ntaub ntawv nkag tsis raug, yog lub hauv paus ntawm ntau cov teeb meem ntsig txog kev tswj cov ntaub ntawv. Yog tias cov ntaub ntawv nkag mus rau thaum pib, qhov kev zov me nyuam yuav ua rau koj rov qab tau cov kev tshwm sim uas koj xav tau.
04 ntawm 08
Cov Kab Yog Cov Ntaub Ntawv
Raws li hais, cov kab ntawm cov ntaub ntawv raug hu ua cov ntaub ntawv. Thaum nkag mus rau cov ntaub ntawv khaws cia cov lus qhia hauv lub hlwb:
- Tsis txhob sau ib kab lus nyob rau hauv lub rooj rau tsim, tsis yog txawm ntawm lub hau thiab thawj kab ntawm cov ntaub ntawv.
- Ib cov ntaub ntawv tuaj yeem muaj cov ntaub ntawv hais txog ib qho khoom tshwj xeeb nkaus xwb.
- Ib cov ntaub ntawv tseem yuav tsum muaj TXHUA cov ntaub ntawv hauv daim ntawv teev npe rau cov khoom ntawd. Yeej tsis tuaj yeem yog cov ntaub ntawv hais txog cov khoom hauv ntau tshaj ib leej.
- Txhawm rau tsim cov npe, ib cov lus ntawm cov ntaub ntawv yuav tsum muaj tsawg kawg yog ob daim ntawv teev cov ntaub ntawv.
05 ntawm 08
Txhua Haiv Neeg
Thaum kab hauv lub rooj raug xa mus ua cov ntaub ntawv, txhua txhua lub npe hu ua cov liaj teb . Txhua kem yuav tsum muaj lub ntsiab lus txheeb xyuas cov ntaub ntawv nws muaj. Cov hau lus no hu ua npe npe.
- Cov npe ntawm cov npe yog siv los xyuas kom meej tias cov ntaub ntawv rau txhua cov ntaub ntawv raug muab teev cia hauv tib lub sib lawv liag.
- Nco ntsoov tias tag nrho cov ntaub ntawv nyob rau hauv ib kem yog nkag mus siv tib hom. Yog tias koj pib nkag mus rau cov lej (xws li 10 lossis 20) khaws nws. Tsis txhob hloov ib feem ntawm txoj kev thiab pib cov lej ua cov lus (xws li kaum lossis nees nkaum). Ua kom zoo ib yam.
- Tsis txhob sau txhua kab hauv lub rooj.
- Los tsim ib daim ntawv, ib lub rooj xav tau tsawg kawg yog ob kab.
06 ntawm 08
Tsim Tsab Ntawv
Thaum cov ntaub ntawv tau muab nkag rau hauv lub rooj, nws tuaj yeem hloov dua siab tshiab rau ib daim ntawv teev . Ua li no:
- Xaiv ib lub xov tooj ntawm tes nyob hauv lub rooj.
- Xaiv > Tsim Sau los ntawm cov ntawv qhia zaub mov qhib lub Thoob Tawm Sib Sau .
- Lub thawv ntawv qhia tias ntau lub hlwb yuav tsum muaj nyob hauv daim ntawv. Yog tias lub rooj tsim tau zoo, Excel yuav tau xaiv qhov muaj tseeb.
- Yog tias qhov kev xaiv xaiv ntau yog lawm, nyem qhov nias.
07 ntawm 08
Yog tias Qhov Teev Tseg Yog Tsis Muaj
Yog hais tias, los ntawm qee lub sij hawm, qhov khwv tau teev nyob rau hauv Sau Tsim List dialog tsis muaj tseeb koj yuav tsum tau kho kom haum rau ntau yam ntawm cov hlwb siv nyob rau hauv daim ntawv.
Ua li no:
- Nias rau ntawm khawm xa tuaj rau hauv Sau Tsim List dialog xa rov tuaj rau ntawm daim ntawv.
- Tus Sau Kev Sau Sib Tham Cov lus sib tham rau ib lub thawv me me thiab tam sim no ntau ntawm cov hlwb yuav pom nyob rau hauv daim ntawv khomxaws uas muaj puag ncig ntawm cov kab ntsig.
- Luag xaiv nrog tus nas mus xaiv qhov tseeb ntau ntawm cov hlwb.
- Nias ntawm khawm xa rov qab rau hauv qhov tsim kom muaj npe me me xa rov qab mus rau qhov qub-qhov loj me.
- Nyem OK ua kom tiav cov npe.
08 ntawm 08
Daim ntawv
Thaum tsim,
- daim ntawv yuav muaj ib sab tsaus nti ncig nws.
- Yuav muaj down-pointing ntawm ib sab ntawm txhua lub npe uas qhib lub npe cia rau thaum lub sij hawm tau nyem.
- Cov ntawv teev cia cov ntawv teev muaj cov kev xaiv rau kev sau cov npe los ntawm cov npe ntawm cov npe thiab tshawb nrhiav cov npe ntawm cov ntaub ntawv.
- Tshais dawb paug uas muaj lub cim asterisk ntxiv rau hauv qab ntawm daim ntawv teev npe. Cov ntaub ntawv ntxiv yuav muab ntxiv rau cov npe uas siv cov kab tshiab no.