Qhov no wikiHow qhia koj yuav ua li cas ntxiv cov teb ua kab rau PivotTable siv Microsoft Excel cov cuab yeej PivotTable ua. Ib qho ntxiv, tsab xov xwm no tseem yuav tham txog yuav ua li cas ntxiv suav teb rau PivotTable.
Kauj ruam
Txoj Kev 1 ntawm 2: Siv Cov PivotTable Cov Cuab Yeej
Kauj Ruam 1. Nyem rau PivotTable
Qhov Field List window yuav tshwm rau ntawm qhov screen.
Koj tseem tuaj yeem nyem qhov Txheeb Xyuas qhov kev xaiv hauv PivotTable Cov cuab yeej ntu ntawm cov ntawv qhia zaub mov, thiab tom qab ntawd xaiv Daim Ntawv Teev Npe
Kauj Ruam 2. Kos rau lub npov ntawm daim teb uas koj xav ntxiv
Los ntawm lub neej ntawd, cov teb nrog cov ntaub ntawv tsis yog tus lej raug ntxiv ua kab, thiab cov teb nrog cov lej lej tau ntxiv ua kab.
Koj tseem tuaj yeem rub daim teb xav tau mus rau Kab lossis Nqe seem yog tias cov ntaub ntawv tsis nkag mus rau ntu uas xav tau
Kauj Ruam 3. Hloov thaj chaw thaj chaw yog tias xav tau los ntawm txoj cai-txhaj rau kab lus nug thiab xaiv txav mus. … Tom qab ntawd, xaiv lub hom phiaj kom txav mus.
Tshem tawm thaj chaw los ntawm PivotTable los ntawm txoj nyem rau ntawm daim teb thiab xaiv Tshem Tawm
Txoj Kev 2 ntawm 2: Ntxiv Kev Tshawb Fawb Kev Tshawb Fawb
Kauj Ruam 1. Qhib daim ntawv Excel uas koj xav kho
Ob npaug nias rau daim ntawv Excel uas muaj PivotTable.
Yog tias koj tsis tau tsim PivotTable tsis tau, tsim daim ntawv Excel tshiab, tom qab ntawv tsim PivotTable tshiab ua ntej txuas ntxiv
Kauj Ruam 2. Xaiv PivotTable uas koj xav kho
Kauj Ruam 3. Hauv nruab nrab ntawm cov kab ntsuab ntsuab nyob rau sab saud ntawm lub qhov rais Excel, nyem rau Tshawb Xyuas tab
Qhov Ntsuas toolbar yuav tshwm hauv qab cov qhab ntsuab.
Yog tias koj siv Mac, nyem lub tab PivotTable Ntsuas.
Kauj Ruam 4. Nyem rau Fields, Yam khoom, & Sets xaiv nyob rau hauv seem Calculation ntawm Analyze toolbar
Qhov kev xaiv no yog nyob rau sab xis ntawm lub toolbar.
Kauj Ruam 5. Ntawm Fields, Item, & Sets menu, xaiv qhov Calculated Field… option
Koj yuav pom lub qhov rai nrog kab lus xaiv.
Kauj Ruam 6. Nkag mus rau kab ntawv lub npe koj xav tau hauv Lub Npe Lub Npe lub thawv
Lub npe no yuav tshwm nyob rau sab saum toj ntawm kab ntawv.
Kauj Ruam 7. Nkag mus rau tus lej rau kab lus hauv kab ntawv Formula
- Nco ntsoov koj nkag mus rau tus lej tom qab kos npe "=".
- Koj tuaj yeem xaiv kab ntawv uas twb muaj lawm thiab nyem Insert Field txhawm rau ntxig qhov tseem ceeb hauv kab ntawv ntawd rau hauv cov qauv. Piv txwv li, koj tuaj yeem nkag mus 3* hauv daim teb, xaiv kab ntawv thib ob, thiab nyem Insert Field txhawm rau sib npaug tus nqi hauv kab thib ob los ntawm peb. Cov txiaj ntsig ntawm cov kev suav no yuav tshwm nyob rau hauv kab ntawv tshiab.
