Microsoft Excel yog ntau dua li daim ntawv thov daim ntawv yooj yim; nws kuj tseem tso cai rau cov neeg siv los tsim cov lus teb nyuaj thiab teeb tsa cov ntaub ntawv tau zoo los ntawm kev siv cov pivot cov lus, kev ua haujlwm thiab cov duab. Ib daim duab, tseem hu ua daim duab hauv Excel, tso cai rau cov neeg siv sib txuas lus tsis yog cov ntaub ntawv nkaus xwb, tab sis kuj tseem muaj lub ntsiab lus tob thiab cuam tshuam uas cov ntaub ntawv tuaj yeem hais qhia. Cov duab cov ntaub ntawv yooj yim dua rau cov neeg ua haujlwm sab nrauv ntawm lub tuam txhab nyiaj txiag kom nkag siab. Nov yog yuav ua li cas ntxiv cov npe rau kab lus hauv Excel txhawm rau nthuav qhia qhov tseeb tshaj plaws thiab ua tiav qhov kev piav qhia ntawm qhov xwm txheej.
Cov kauj ruam
Kauj Ruam 1. Nyem rau kab ntawv uas xav tau lub npe kab ntawv txhawm rau xaiv nws
Ib daim duab uas tau xaiv tam sim no yuav muaj cov duab ntxoov ntxoo.
Kauj Ruam 2. Tshaj tawm ntau qhov ntxiv rau lub cuab yeej tseem ceeb thaum xaiv kab ntawv:
Tsim, Layout thiab Format. Cov kev xaiv no nyob hauv qab lub npe tshiab hu ua "Chart Tools."
Kauj Ruam 3. Xaiv Layout tab hauv lub toolbar tseem ceeb
Cov Ntawv Cim ntawm ntu no tuav cov lus txib ua haujlwm nrog cov npe thiab cov ntawv cim.
Kauj Ruam 4. Xaiv "Daim Ntawv Teev Npe
- "Cov npe nruab nrab nyob nruab nrab" yuav tso cov khoom tiled uas muaj cov npe dav dav ntawm kab ntawv uas yuav tsis hloov pauv nws.
- "Saum toj daim duab" yuav hloov kho daim duab thiab ua kom muaj chaw nyob rau ib lub ntsiab lus tseem ceeb saum toj ntawm daim duab.
Kauj Ruam 5. Tsiv koj tus nas thiab nyem sab hauv lub npe kab ntawv hloov pauv lub npe ntawm kab ntawv mus rau qee yam piav qhia ntxiv
Kauj Ruam 6. Nyem "Daim duab qhia chaw" ntawm qhov toolbar dua thiab xaiv "Ntau lub npe xaiv" hauv qab ntawm cov ntawv qhia zaub mov nco-down
- Ntawm no koj tuaj yeem ntxiv lwm cov ntsiab lus xws li ciam teb, sau xim lossis 3-D hom rau koj lub npe.
- Koj kuj tseem tuaj yeem ntxiv cov cai ntxiv rau kev ua kom haum ntawm koj lub npe kom ua raws txoj kab ntsug, kab lus kev coj thiab lub kaum kev cai.
Kauj Ruam 7. Hloov cov font thiab tus lej sib nrug ntawm koj cov duab kab los ntawm txoj cai-nyem rau ntawm lub npe
- Koj tuaj yeem hloov qhov font style, qhov loj thiab xim ntawm koj lub npe.
- Koj tseem tuaj yeem ntxiv ntau yam cuam tshuam xws li tawm tsam-hla, cov ntawv me me, cov ntawv me me thiab cov ntawv me.
Kauj Ruam 8. Nyem Axis Titles ntxiv cov ntsiab lus no rau koj daim ntawv hauv Excel
- Thawj Txoj Kev Xaiv Kab Rov Tav Xaiv qhov chaw uas cov npe hauv qab kab rov tav.
- Thawj Vertical Axis Title ntawv qhia zaub mov suav nrog ntau txoj hauv kev rau kev tso saib ntawm lub npe kab ntsug.
Lub tswv yim
- Koj tuaj yeem nkag mus rau ntau qhov kev xaiv tib yam rau kev ua haujlwm nrog koj daim ntawv teev npe los ntawm txoj cai-nyem rau ntawm lub npe.
- Koj tuaj yeem txuas cov kab ntawv lossis cov npe hauv koj daim duab rau txhua lub xov tooj ntawm koj daim ntawv nthuav dav. Nyem lub npe koj xav txuas thiab, thaum nws raug xaiv, nyem rau hauv Formula bar. Ntaus qhov sib npaug (=) kos npe. Tam sim no xaiv lub xov tooj uas koj xav txuas lub npe rau los ntawm txhaj nws. Nias "Nkag mus." Nov yog txoj hauv kev zoo kom paub tseeb tias koj lub npe hloov tshiab yog tias cov ntaub ntawv hauv cov xovtooj ntawm tes hloov pauv.
