Excel tsis hnyav rau ntawm cov duab, tab sis tseem muaj ntau txoj hauv kev los tsim lub sijhawm. Yog tias koj muaj Excel 2013 lossis tom qab, koj tuaj yeem tsim nws los ntawm lub rooj pivot. Cov ntawv ua ntej yuav tsum tso siab rau SmartArt, tus qauv, lossis yooj yim npaj cov ntawv xov tooj ntawm tes.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Siv SmartArt (Excel 2007 lossis Tom Qab)
Kauj Ruam 1. Tsim ib daim ntawv tshiab
SmartArt tsim cov qauv duab tshiab rau koj ntxiv cov ntaub ntawv. Nws tsis hloov pauv koj cov ntaub ntawv uas twb muaj lawm, yog li tsim daim ntawv tshiab dawb paug rau koj lub sijhawm.
Kauj Ruam 2. Qhib SmartArt ntawv qhia zaub mov
Nyob ntawm koj li Excel version, ib qho nyem rau SmartArt tab hauv kab ntawv qhia zaub mov, lossis nyem rau Insert tab, tom qab ntawd khawm SmartArt. Qhov kev xaiv no muaj nyob hauv Excel 2007 lossis tom qab.
Kauj Ruam 3. Xaiv lub ncua sij hawm los ntawm Txheej Txheem submenu
Nyem txheej txheem hauv SmartArt ribbon ntawv qhia zaub mov, hauv Insert Smart Art Graphic group. Hauv cov ntawv qhia zaub mov nco-down uas tshwm, xaiv Lub Sijhawm Pib (xub xub tig sab xis).
Koj tuaj yeem hloov kho lwm yam Txheej Txheem duab los siv ua ncua sijhawm. Txhawm rau pom lub npe ntawm txhua daim duab, txav koj tus cursor hla lub cim thiab tos kom txog thaum cov ntawv hover tshwm
Kauj Ruam 4. Ntxiv cov xwm txheej
Los ntawm lub neej ntawd koj tsuas yog pib nrog qee qhov xwm txheej. Txhawm rau ntxiv, xaiv ncua sijhawm. Cov Ntawv Pane yuav tsum tshwm rau sab laug ntawm daim duab. Nyem rau + khawm nyob rau sab saud ntawm kab ntawv txhawm rau ntxiv qhov xwm txheej ncua sijhawm tshiab.
Txhawm rau ncua sijhawm ncua sijhawm yam tsis ntxiv cov xwm txheej tshiab, nyem lub ncua sij hawm los qhia lub npov qhia. Luag sab xis lossis sab laug ntawm lub npov sab nrauv
Kauj Ruam 5. Kho koj lub sijhawm
Ntaus rau hauv Text Box lub thawv txhawm rau ntxiv cov nkag. Koj tseem tuaj yeem luam-muab cov ntaub ntawv tso rau hauv ncua sijhawm thiab muaj Excel kwv yees ntawm yuav ua li cas npaj nws. Feem ntau, koj yuav xaus nrog txhua kab ntawv ntawm cov ntaub ntawv raws li cov sijhawm nkag nkag.
Txoj Kev 2 ntawm 3: Siv Pivot Table Analysis (Excel 2013 lossis Tom Qab)
Kauj Ruam 1. Qhib daim ntawv nthuav qhia uas muaj lub rooj pivot
Txhawm rau kom tsim lub sijhawm ncua sijhawm, koj cov ntaub ntawv yuav tsum tau teeb tsa rau hauv lub rooj pivot. Koj kuj xav tau lub rooj pivot txheeb xyuas cov ntawv qhia zaub mov, uas tau qhia hauv Excel 2013.
Kauj Ruam 2. Nyem qhov twg sab hauv lub rooj pivot
Qhov no yuav qhib "PIVOT TABLE TOOLS" nyob rau sab saud.
Kauj Ruam 3. Nyem “Txheeb Xyuas”
Qhov no yuav qhib ib txoj hlua nrog cov kev xaiv los tswj cov ntaub ntawv hauv lub rooj.
Kauj Ruam 4. Nyem “Insert Timeline”
Lub thawv sib tham yuav tshwm tuaj qhia cov teb uas sib haum rau hnub tim. Nco ntsoov tias cov hnub nkag los ua cov ntawv yuav tsis raug lees paub.
Kauj Ruam 5. Xaiv daim ntawv thov siv thiab nyem OK
Lub npov tshiab uas tso cai rau koj taug kev los ntawm koj lub sijhawm yuav tshwm sim.
Kauj Ruam 6. Xaiv seb cov ntaub ntawv yuav raug lim li cas
Nyob ntawm cov ntaub ntawv muaj koj tuaj yeem xaiv yuav ua li cas cov ntaub ntawv yuav raug lim. (Ib lub hlis twg, xyoo lossis ib lub hlis twg).
Kauj Ruam 7. Txheeb xyuas cov ntaub ntawv txhua hli
Thaum koj nyem rau ntawm ib hlis hauv Lub Sijhawm Tswj Lub thawv, cov lus pivot yuav qhia cov ntaub ntawv uas cuam tshuam txog lub hlis tshwj xeeb ntawd ib leeg.
Kauj Ruam 8. Qhib qhov koj xaiv
Koj tuaj yeem nthuav koj qhov kev xaiv los ntawm txhaj thiab rub ob sab ntawm tus swb.
Txoj Kev 3 ntawm 3: Siv Daim Ntawv Qhia Yooj Yim (Txhua Yam)
Kauj Ruam 1. Xav txog kev rub tus qauv
Thaum tsis tsim nyog, tus qauv yuav txuag koj qee yam haujlwm los ntawm teeb tsa lub sijhawm ncua sijhawm rau koj. Koj tuaj yeem tshawb xyuas seb koj twb muaj lub sijhawm ua piv txwv los ntawm kev xaiv cov ntawv hauv Cov Ntaub Ntawv → Tshiab lossis Cov Ntaub Ntawv → Tshiab los ntawm Cov lus txib Template. Txwv tsis pub, tshawb online rau cov neeg siv tsim cov qauv sijhawm. Yog tias koj tsis xav siv tus qauv, txuas ntxiv mus rau theem tom ntej.
Yog tias koj lub sijhawm ncua sijhawm taug qab qhov kev nce qib ntawm ntau txoj haujlwm sib tw, txiav txim siab nrhiav "Gantt daim ntawv" tus qauv hloov chaw
Kauj Ruam 2. Pib koj tus kheej lub sijhawm los ntawm cov cell zoo tib yam
Koj tuaj yeem teeb tsa lub sijhawm ncua sijhawm nrog daim ntawv teev npe dawb ib yam. Ntaus cov hnub tim ntawm koj lub sijhawm nyob rau hauv ib kab, sib nrug lawv tawm nrog cov cell dawb paug nyob rau hauv kev faib ua feem rau lub sijhawm nruab nrab ntawm lawv.
Kauj Ruam 3. Sau koj daim ntawv teev sijhawm
Hauv xov tooj ntawm tes ncaj qha saum toj lossis hauv qab txhua hnub, sau cov lus piav qhia ntawm qhov xwm txheej uas tau tshwm sim rau hnub ntawd. Tsis txhob txhawj yog tias nws zoo li ntxhib.
Hloov cov lus piav qhia saum toj no thiab hauv qab hnub tim yuav ua rau lub sijhawm nyeem tau zoo tshaj plaws
Kauj Ruam 4. Qhib cov lus piav qhia
Xaiv kab uas muaj koj cov lus piav qhia. Nyem rau Tsev tab hauv kab ntawv qhia zaub mov, tom qab ntawd nyem rau khawm Orientation hauv qab Pab Pawg Sib Koom. (Hauv qee qhov kev hloov pauv, khawm Orientation zoo li cov tsiaj ntawv abc.) Nyem rau lub pob no thiab xaiv ib qho ntawm cov ntawv xaiv kaum. Cov ntawv hloov yuav tsum ua kom koj cov lus piav qhia haum rau ncua sijhawm.