Ib daim ntawv Excel tuaj yeem tsim ua ntau txoj hauv kev los ua ntau txoj haujlwm sib txawv. Cov ntaub ntawv tuaj yeem teeb tsa thiab nthuav tawm kom haum rau cov kev xav tau tshwj xeeb, thiab cov tib neeg lub hlwb tuaj yeem ua haujlwm los ua cov lej tshwj xeeb raws li cov ntaub ntawv nkag mus. Cov kev suav ntawd tuaj yeem tso rau hauv cov duab sawv cev ntawm cov ntaub ntawv, xws li kab kos thiab kab kos. Kab lus no muab piv txwv txog yuav ua li cas txhawm rau teeb tsa Excel daim ntawv nthuav dav los teeb tsa, suav thiab txheeb xyuas cov nuj nqis.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Nkag mus rau Cov Ntawv rau Kev Siv Tus Nqi ติดตาม Spreadsheet
Kauj Ruam 1. Sau cov ntawv
Ntaus hnub tim rau hauv cell A2, "Khoom noj khoom haus" hauv cell B3, "Gas" hauv cell B4, "Rent" hauv cell B5, "Utilities" hauv cell A6 thiab "Electric" hauv cell C6. Tom qab ntawv ntaus "Dej/Dej Dej" hauv cell C7, "Xov tooj" hauv cell C8, thiab "Cable/Internet" hauv cell C9.
Ntaus "Auto Loan Payments" hauv cell B10, "Cell Phone" hauv cell B11 thiab "Entertainment" hauv cell A12. Ntaus "Meals Out" hauv cell B12, "Movies" hauv cell B13, "Amount" hauv cell E2 thiab "Total" hauv cell E2. Cov ntawv rau tus nqi taug qab daim ntawv nthuav qhia tau nkag mus
Txoj Kev 2 ntawm 3: Txheeb Tus Nqi Txheeb Xyuas Cov Ntawv Spreadsheet
Kauj Ruam 1. Format cov xov tooj thiab cov ntawv
Xaiv cov cell A2 txog E2. Nyem Merge and Center khawm ntawm Alignment toolbar. Nyem qhov Fill Bucket hauv Font formatting toolbar thiab xaiv "White, background 1, Darker 35%."
- Xaiv cov cell A3 txog A5. Nias thiab tuav tus yuam sij tswj hwm ntawm lub computer keyboard thiab xaiv cov cell A6 txog B9, A10, A11, A12, B12, A13 thiab B13. Nyem qhov Fill Bucket hauv Font formatting toolbar thiab xaiv "White, background 1, Darker 50%."
- Xaiv cov cell B3 txog D3. Nias thiab tuav tus yuam sij tswj hwm ntawm lub computer keyboard thiab xaiv cov cell B4 txog D4, thiab B5 txog D5. Mus txuas ntxiv tuav lub khawm tswj thiab xaiv cov cell B10 txog D10, thiab B11 txog D11.
- Nyem qhov Fill Bucket hauv Font formatting toolbar thiab xaiv "White, background 1, Darker 50%." Nyem rau Merge thiab Center khawm, thiab txoj cai ncaj ncees khawm hauv Alignment menu ntawm lub cuab yeej.
- Xaiv cov cell C6 txog D6. Nias thiab tuav tus yuam sij tswj hwm thiab xaiv cov cell C6 txog D6, C7 txog D7, C8 txog D8, thiab C9 txog D9. Nyem rau Fill Bucket thiab xaiv "White Background 1." Nrog cov cell tseem raug xaiv, nyem rau Merge thiab Center khawm, thiab khawm raug cai nyob hauv Alignment menu ntawm toolbar. Cov duab ntxoov ntxoo thiab sib koom ua ke tau tsim tawm.
Kauj Ruam 2. Program "Cell" ntawm tes kom ntxiv tag nrho rau txhua qeb
Nyem hauv cell E13 thiab nyem rau khawm AutoSum hauv cov ntawv kho kom raug nyob rau sab xis ntawm tus txheej txheem cuab yeej. Xaiv cov cell E3 txog E13 thiab xaiv Cov Nyiaj Txiaj Ntsig ($) hauv Cov Ntawv Teev Npe Tus lej ntawm tus txheej txheem txheej txheem. Cov lej nkag mus rau hauv cov teb rau txhua pawg yuav raug nthuav tawm raws li tus nqi txiaj ntsig, thiab tag nrho yuav tshwm nyob rau hauv qab ntawm lub rooj. Daim ntawv taug qab cov nuj nqis tau raug teeb tsa.
Txoj Kev 3 ntawm 3: Tsim daim Excel Pie Chart los tso saib cov nuj nqis
Kauj Ruam 1. Tsim daim ntawv qhia ncuav qab zib
Nyem rau Insert tab ntawm tus txheej txheem txheej txheem toolbar thiab nyem lub pob Pie. Ib daim ntawv dawb paug yuav tshwm nyob rau hauv daim ntawv thov qhov rai. Nyem thiab rub daim ntawv dawb mus rau sab xis kom tag nrho cov lus pom tau. Nyem rau Xaiv Cov Ntaub Ntawv khawm hauv Cov Ntawv Qhia Tsim ntawm Chart Tools toolbar. Lub thawv Xaiv Cov Ntaub Ntawv sib tham yuav tshwm sim. Nyem rau Kho kom raug khawm hauv kab ntawv Kab rov tav Kab nyob sab xis ntawm lub npov sib tham.
