Thaum ua haujlwm nrog cov ntaub ntawv sib txawv, nws yog feem ntau yuav tsum sib txuas cov ntaub ntawv rau hauv ib lub rooj rau kev txuas ntxiv lossis ntsuas. Txawm tias ib daim ntawv tseem tuaj yeem muaj cov ntaub ntawv tsis sib haum. Piv txwv li, cov lus qhia nrog cov ntau ntawm cov muag khoom rau ntau yam khoom lag luam, ntawm qhov koj xav qhia tag nrho kom muaj nuj nqis rau txhua cov khoom lag luam. Yuav kom daws tau cov teeb meem no, cov neeg tsim tsim ntawm Microsoft Excel suite tau muab cov cuab yeej tsim muaj yooj yim heev - pivot cov rooj.
Cov Lus Qhia
Kauj ruam 1
Qhib ib daim ntawv Excel nrog cov ntaub ntawv koj xav ua Tus PivotTable los ntawm. Nyem nas nyob rau ntawm ib qho ntawm lub rooj hlwb, ib qho yuavtsum tau kawm uantej yog tias qee tus nqi tau sau rau hauv lub xovtooj ntawm no. Qhov yooj yim tshaj plaws yog muab lub kem nrog cov npe tsim nyog, piv txwv li, "npe", "kom muaj nuj nqis", thiab lwm yam.
Kauj ruam 2
Hauv cov ntawv qhia zaub mov bar rau sab saum toj ntawm lub qhov rais, nrhiav cov khawm Data (rau Excel 2000, XP, 2003) lossis Insert tab (rau Excel 2007) thiab nyem nws. Ib daim ntawv yuav qhib hauv qhov uas qhib "Pivot Table" khawm. Lub "PivotTable Wizard" yuav qhib thiab coj koj los ntawm txhua qhov kev teeb tsa xav tau.
Kauj ruam 3
Xaiv cov ntaub ntawv los ntawm lub rooj pivot thiab cov hom ntaub ntawv. Lub qhov rai wizard tau muab faib ua ob ntu. Nyob rau hauv ib nrab sab saud, qhia qhov chaw koj xav tau cov ntaub ntawv los ntawm, piv txwv li, los ntawm cov ntaub ntawv Excel lossis ib qho chaw khaws ntaub ntawv. Hauv qab, "PivotTable" cov khoom raug kuaj los ntawm lub neej ntawd, yog li koj tsis tas yuav hloov dab tsi. Nyem Rau Tom ntej khawm thiab mus rau theem ob ntawm lub cuab kav.
Kauj ruam 4
Xaiv cov ntaub ntawv ntau yam rau kev coj ua nrog nas. Los ntawm lub neej ntawd, tag nrho cov lus los ntawm thawj daim ntawv Excel yog xaiv, ntawm qhov screen koj yuav pom qhov no ua lub teeb ntsais. Yog tias tsim nyog, koj tuaj yeem xaiv tsuas yog ib feem ntawm cov ntaub ntawv. Nyem rau "Tom ntej" khawm thaum koj ua tiav txoj kev xaiv cov ntaub ntawv.
Kauj ruam 5
Nyem rau "Finish" khawm ntawm qhov kawg screen ntawm lub rooj teeb. Koj tuaj yeem xaiv qhov chaw uas koj lub rooj pivot yuav nyob. Los ntawm lub neej ntawd, qhov no yog Ntawv Tshiab thiab yog qhov kev xaiv zoo tshaj plaws. Koj tseem tuaj yeem xaiv cov khoom "Daim Ntawv Muaj Lawm", tab sis qhov no nws yuav muaj teeb meem nrog kev sib txuas ua ke thiab ua kom pom.
Kauj Ruam 6
Customize koj piv rooj. Tom qab txhaj Finish, koj yuav pom cov lus teeb rooj thiab tswj teb. Txhua ntawm lawv tau kos npe kom nws yooj yim dua mus npaj cov ntaub ntawv thiab kho qhov kawg ntawm cov ntaub ntawv.
Kauj Ruam 7
Xaiv cov ntaub ntawv yuav tsum tau nyob rau hauv lub qhov rais ntawm sab laug thiab cab nws mus rau qhov chaw haum ntawm kab ntawv. Lub rooj yuav tam sim ntawd populated nrog qhov muaj nuj nqis los ntawm kab kev cai lossis kab. Txhua yam nws yog nyob ntawm lub hom phiaj ntawm kev tsim pivot lub rooj - nws yog qhov khoom siv tau hloov tau yooj yim. Yuav kom tau txais cov ntawv no lossis daim ntawv tshaj tawm no, koj yuav tsum xaiv cov ntaub ntawv ntawm kev txaus siab los ntawm cov npe hauv daim teb ntawm lub rooj kawg, tsis kos cov ntaub ntawv tsis tsim nyog thiab khij qhov tsim nyog.
