Cov kab kos tau siv los muab cov duab sawv cev ntawm lub tswv yim lossis cov ntsiab lus. Pivot kab kos tsim hauv Microsoft Excel tuaj yeem muaj txiaj ntsig ntau dua li cov kab kos zoo ib yam, vim tias lawv tau yooj yim dua los coj los qhia cov ntaub ntawv sib txawv thiab cov ntsiab lus. Kev kawm los tsim daim duab pivot tuaj yeem ua rau tsis meej pem thiab muaj qee qhov kev txiav txim siab uas koj yuav tsum tau ua ua ntej koj pib. Nov yog yuav ua li cas los tsim daim ntawv qhia los ntawm lub rooj pivot, ib qib zuj zus, yog li koj tuaj yeem siv cov cuab yeej muaj txiaj ntsig no.
Cov kauj ruam
Kauj Ruam 1. Tua tawm Microsoft Excel daim ntawv thov
Kauj Ruam 2. Xauj mus, thiab qhib, cov ntawv uas muaj cov lus pivot thiab cov ntaub ntawv los ntawm qhov uas koj xav tsim daim duab
Kauj Ruam 3. Txiav txim siab ntawm nqe lus koj xav kom koj daim duab pivot los sawv cev
- Qhov kev txiav txim siab no yuav txiav txim siab li cas koj tsim koj daim duab pivot.
- Cov qauv ntawm daim duab thiab kab uas tau siv yuav nyob ntawm qhov kev txiav txim siab no. Piv txwv li, kab ntawv kab ntawv muaj txiaj ntsig zoo rau kev sawv cev rau cov ntaub ntawv hauv cov xwm txheej sib txawv, xws li kev muag khoom ib cheeb tsam, thaum daim ntawv ncuav qab zib tuaj yeem siv los tso saib feem pua lossis ib feem ntawm tag nrho.
Kauj Ruam 4. Nrhiav thiab tso tawm Pivot Chart wizard
- Hauv Excel 2003, qhov no yuav nyob hauv qab "Cov ntaub ntawv" ntawv qhia zaub mov.
- Hauv Excel 2007 thiab 2010, koj yuav pom qhov no ntawm "Insert" tab.
Kauj Ruam 5. Teev qhov ntau rau koj daim duab pivot
Nws yuav tsum yog tib yam siv rau cov lus pivot cuam tshuam.
Kauj Ruam 6. Luag ib kab ntawv kab lus sawv cev rau "x" axis ntawm daim duab thiab tso rau hauv "Axis Field" ntu ntawm Pivot Table Field List
Kauj Ruam 7. Xaiv kab ntawv kab ntawv uas muaj cov ntaub ntawv uas koj xav kom pom los ntawm "x" axis teb thiab rub nws mus rau ntu "Qhov tseem ceeb" ntawm Pivot Table Field List
Piv txwv li, yog tias koj cov ntaub ntawv keeb kwm yog daim ntawv nthuav tawm ntawm kev muag khoom los ntawm cov khoom lag luam thiab lub npe cov neeg siv khoom, koj tuaj yeem xaiv kom poob ib tus neeg siv lub npe lossis cov npe khoom lag luam daim ntawv lo rau hauv ntu "Axis Field". Koj yuav rub cov kab ntawv lo rau cov nyiaj muag khoom mus rau ntu "Tus Qauv"
Kauj Ruam 8. Hloov hom kab ntawv los ntawm txoj cai-nyem rau ntawm daim duab keeb kwm yav dhau los thiab xaiv "Hloov Cov Qauv Cim" los ntawm cov ntawv qhia zaub mov
Sim ob peb hom kab ntawv sib txawv kom txog thaum koj pom hom uas zoo tshaj plaws piv rau lub ntsiab lus koj xav ua
Kauj Ruam 9. Ntxiv cov ntawv lo, cov npe axis thiab lwm yam ntaub ntawv rau hauv koj daim ntawv los ntawm txoj cai-txhaj qhov feem cuam tshuam ntawm daim duab thiab xaiv cov kev xaiv los ntawm cov ntawv qhia zaub mov
Kauj Ruam 10. Tsiv koj daim duab pivot nyob txhua qhov chaw hauv phau ntawv ua haujlwm uas koj nyiam
Nws tuaj yeem muab tso rau hauv ib ces kaum ntawm cov ntaub ntawv cov ntaub ntawv, ntawm tib lub tab zoo li lub rooj pivot lossis ntawm nws tus kheej tab
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Koj daim ntawv pivot yuav raug tsim los ntawm cov ntaub ntawv muab rau koj lub rooj pivot, tsis yog lub rooj pivot nws tus kheej. Nco ntsoov tias kev hloov pauv rau cov ntaub ntawv yuav tsum tshwm sim ntawm qib cov ntaub ntawv.
- Tsawg cluttered koj daim duab pivot yog, qhov ua tau zoo nws yuav yog hauv kev sib txuas lus koj cov ntsiab lus. Xav txog kev tsim ob peb daim duab sib txawv, txhua qhov nthuav tawm nws tus kheej lub tswv yim yog tias koj daim duab pivot xav tau nthuav qhia ntau lub ntsiab lus sib txawv.
