Qhov wikiHow no qhia koj li cas los tsim kom pom kev sawv cev ntawm Microsoft Excel cov ntaub ntawv siv daim ntawv qhia ncuav qab zib.
Kauj ruam
Ntu 1 ntawm 2: Ntxiv Cov Ntaub Ntawv
Kauj Ruam 1. Qhib Microsoft Excel
Qhov kev zov me nyuam yog sawv cev los ntawm lub cim uas zoo li dawb "E" ntawm qhov ntsuab tom qab.
Yog tias koj xav tsim daim ntawv los ntawm cov ntaub ntawv uas twb muaj lawm, ob npaug nias rau daim ntawv Excel uas muaj cov ntaub ntawv xav tau los qhib nws thiab txav mus rau ntu tom ntej
Kauj Ruam 2. Nyem Blank workbook (PC) lossis Excel Workbook (Mac)
Nws yog nyob rau sab xis sab xis ntawm "Templates" qhov rai.
Kauj Ruam 3. Ntxiv lub npe rau daim duab
Txhawm rau ntxiv lub npe, nyem rau lub npov " B1"Thiab ntaus lub npe kab ntawv.
- Piv txwv li, yog tias koj xav tsim daim ntawv qhia txog koj cov peev nyiaj, ntaus piv txwv “2017 Pob Nyiaj” rau hauv “ B1 ”.
- Koj kuj tseem tuaj yeem sau daim ntawv piav qhia (piv txwv li "Kev faib nyiaj txiag") hauv " A1 ”.
Kauj Ruam 4. Ntxiv cov ntaub ntawv rau hauv kab ntawv
Nkag mus rau qhov xav tau daim ntawv qhia ntu ntu ntu hauv " A"Thiab tus nqi ntawm ntu hauv kab" B ”.
- Txog qhov piv txwv peev nyiaj saum toj no, koj tuaj yeem sau "Tus nqi tsheb" hauv kab " A2"Thiab muab" $ 1000 "hauv kab" B2 ”.
- Daim ntawv qhia ncuav qab zib daim ntawv yuav txiav txim siab feem pua.
Kauj Ruam 5. Ua kom tiav cov txheej txheem ntawm kev ntxiv cov ntaub ntawv
Tom qab ua tiav cov txheej txheem no, koj tau npaj los tsim daim ntawv qhia ncuav qab zib siv cov ntaub ntawv ntawd.
Ntu 2 ntawm 2: Tsim Kab Lus
Kauj Ruam 1. Xaiv tag nrho cov ntaub ntawv
Txhawm rau xaiv cov ntaub ntawv, nyem rau lub npov " A1", Tuav Shift, thiab nyem lub npov hauv qab uas muaj qhov tseem ceeb hauv kab" B" Tom qab ntawd, txhua daim duab qhia chaw yuav raug xaiv.
Yog tias daim duab siv ntau kab ntawv ntawm cov tsiaj ntawv, tus lej, thiab cov zoo li, tsuas yog nco ntsoov tias koj tsuas yog yuav tsum nyem rau kab ntawv nyob deb tshaj plaws ntawm sab laug sab saud ntawm cov pab pawg cov ntaub ntawv thiab nyem rau kab ntawv nyob deb mus rau sab xis hauv qab ntawm cov ntaub ntawv pawg thaum tuav cia Ua haujlwm
Kauj ruam 2. Nyem rau Insert tab
Cov ntawv no yog nyob rau sab saum toj ntawm Excel qhov rai, rau sab xis ntawm Tsev ”.
Kauj Ruam 3. Nyem rau "Pie Chart" icon (lub voj voog/daim duab ncuav qab zib)
Lub voj voos khawm no nyob hauv "Charts" pawg xaiv, nyob hauv qab txoj cai ntawm tab " Ntxig " Koj yuav pom ntau txoj hauv kev hauv cov ntawv qhia zaub mov nco-down:
- ” 2-D Peb "-Koj tuaj yeem tsim daim ntawv qhia ncuav qab zib yooj yim uas qhia txog xim raws cov ntaub ntawv.
- ” 3-D Peb "-Koj tuaj yeem siv daim duab peb sab duab uas qhia cov xim raws cov ntaub ntawv.
Kauj Ruam 4. Nyem rau qhov xaiv
Tom qab ntawd, daim ntawv qhia ncuav qab zib nrog cov ntaub ntawv xaiv yuav raug tsim. Koj tuaj yeem pom ntau lub tab xim nyob hauv qab ntawm lub ncuav qab zib. Cov xim sib haum rau cov xim ib feem ntawm daim duab.
Koj tuaj yeem saib ua ntej cov kev xaiv los ntawm hovering hla cov qauv sib txawv
Kauj Ruam 5. Hloov kho qhov pom ntawm daim duab
Txhawm rau hloov kho qhov pom, nyem rau tab " Tsim "Nyob rau sab saum toj ntawm" Excel "qhov rai, tom qab ntawd nyem qhov kev xaiv hauv" Chart Styles "pab pawg. Nrog rau cov kev xaiv no, koj tuaj yeem hloov qhov pom ntawm daim duab, suav nrog cov xim, faib cov ntawv, thiab qhov kev xaiv los qhia/zais feem pua.
Mus saib tabs " Tsim ", Daim ntawv yuav tsum raug xaiv lawm. Koj tuaj yeem xaiv nws los ntawm txhaj rau nws.
Lub tswv yim
- Koj tuaj yeem luam daim duab thiab muab tso rau lwm qhov Microsoft Office program (piv txwv li Lo Lus lossis PowerPoint).
- Yog tias koj xav tsim daim phiaj rau ntau cov ntaub ntawv teev tseg, rov ua cov txheej txheem no rau txhua txheej. Thaum daim duab raug teeb tsa, nyem thiab rub daim duab los ntawm nruab nrab ntawm daim ntawv Excel sab nraud kom nws tsis npog/cuam tshuam thawj daim duab.
