Raws li nyob rau hauv "Eksele" ua rooj puas yam

Ntsiab lus ntxhuav yog kev sib tham sib zaub ntawm cov ntaub ntawv uas tso cai rau cov neeg siv rau kev tsom xam cov pab pawg thiab nqi loj dua cov ntaub ntawv nyob rau hauv ib tug meej, tabular daim ntawv rau ib qho yooj yim qhia thiab tsom xam. Ib tug kom zoo dua ntawm no muaj nuj nqi nyob rau hauv Excel yog hais tias nws tso cai rau koj mus kho kom raug, nkaum thiab qhia ntau pawg nyob rau hauv ib cov ntaub ntawv los muab lwm saib ntawm cov ntaub ntawv. Nyob rau hauv no tsab xov xwm koj yuav tau nyeem cov lus qhia txog yuav ua li cas "Eksele" ua ib lub rooj.

Kauj ruam 1 of 3: Configuring los ntawm kos

Pib Microsoft Excel.

Nyem rau cov zaub mov yam khoom "Cov ntaub ntawv" thiab mam li xaiv lub txoj kev lub rooj (ceeb toom: nyob rau hauv versions ntawm Excel 2007/2010, ua "Insert"> txoj kev rooj).

Qhia kom meej rau nrhiav cov ntaub ntawv uas koj npaj siab yuav mus generalize. Yog hais tias cov ntaub ntawv no yog nyob rau hauv Excel daim ntawv uas yog tam sim no qhib, lub software txiav nhro cov ntau yam ntawm lub hlwb. Nyem "Tom ntej".

Nco ntsoov tias cov kev xaiv "Tshiab daim ntawv teev" yog xaiv tom qab txhaj rau cov "Tom ntej" los ntawm lub yav dhau los kauj ruam. Thaum koj twb ua li ntawd, nias "Finish".

Kauj ruam 2 ntawm 3: Yuav ua li cas mus ua tau ib lub rooj nyob rau hauv "Eksele"

Yog hais tias tsim nyog, kho qhov ntau nyob rau hauv cov ntawv nyeem lub thawv. Tej cwj pwm no yog nyob rau hauv lub tshuab raj yam khoom "Xaiv lub rooj." Yog hais tias lub qhov chaw ntawm cov ntaub ntawv rau lub rooj yog ib tug sab nraud, tsim nyob rau hauv ib tug nyias muaj nyias ib qhov kev pab cuam (piv txwv li, Access), nias qhov "Siv sab nraud cov ntaub ntawv qhov chaw." Tom qab ntawd, nrhiav cov zaub mov yam khoom "Xaiv Kev twb kev txuas" thiab ces nias rau ntawm lub dialog box hu ua "uas twb muaj lawm Connections".

Ua cov kev xaiv ntawm qhov chaw rau tsim lub PivotTable. Yog lub neej ntawd, Excel hom tsim nws raws li ib tug tshiab page yuav muab ntxiv rau hauv phau ntawv. Tham txog yuav ua li cas "Eksele" ua lub rooj thiaj li hais tias nws nyob rau hauv ib tug muab daim ntawv, koj yuav tsum mus nias rau qhov kev xaiv "uas twb muaj lawm List" khawm, thiab ces qhia kom meej rau qhov chaw nyob ntawm cov thawj cell nyob rau hauv lub thawv ntawv "Qhov chaw nyob".

Nyem "OK". Ces, ntxiv ib tug tshiab dawb paug daim phiaj rau lub PivotTable, thiab ces yuav tau mus tso saib neeg ua hauj lwm pane "Field Sau PivotTable." Qhov no vaj huam sib luag yog muab faib ua ob qhov chaw.

Qhib cov zaub mov yam khoom 'Xaiv teb ntxiv rau ntawm daim ntawv qhia "thiab sau nyob rau hauv tag nrho cov npe ntawm cov teb nyob rau hauv lub qhov chaw cov ntaub ntawv.

filling

Raws li nyob rau hauv "Eksele" ua ib lub rooj? Ntxiv mus nqa tawm cov lus qhia, koj yuav tsum tau ib lub thawv nyob rau hauv qhov kev tshuaj ntsuam, muab faib ua plaub chaw ua hauj lwm, uas yuav tsum qhia kom meej rau lub lim, kem ntawv, cov kab thiab qhov tseem ceeb.

Muab teb nyob rau hauv lub ua hauj lwm "PivotTable Teb List" nyob rau hauv nws ntau qhov chaw. Luag lub teb lub npe ntawm cov zaub mov yam khoom 'Xaiv teb ntxiv rau ntawm daim ntawv qhia "nyob rau hauv txhua lub ntawm plaub lub aav.

Ua kev kho me ntsis raws li tsim nyog kom txog thaum koj pom koj tus zoo tagnrho tau.

Kauj ruam 3 of 3: To taub cov thawj cov ntsiab lus, los yog yuav ua li cas yuav ua rau ib lub rooj nyob rau hauv lub "Eksele" yooj yim

Ua ntej ntawm tag nrho cov sim kom to taub lus txhais tseem ceeb. Muaj ntau ntau cov lus uas tej zaum yuav, thaum xub thawj siab ib muag, zoo li obscure.

Yuav ua li cas yog ib tug lim? Qhov no cheeb tsam muaj teb mus nrhiav cov ntaub ntawv teev nyob rau hauv lub xaus ntawm lub rooj, ntawm filtering lawv los ntawm kev kos npe rau. Lawv pab raws li cov cim rau daim ntawv. Piv txwv li, yog tias koj teem lub "Xyoo" raws li ib lim, koj muaj peev xwm tso saib lub txoj kev cov ntaub ntawv nyob rau hauv lub rooj rau tej lub sij hawm ntawm lub sij hawm los yog rau tag nrho cov xyoo.

txhua kos npe - hauv cheeb tsam no muaj ib tug teb defining qhov chaw ntawm cov ntaub ntawv teev nyob rau hauv lub xaus rooj txhua.

Kos npe kab - hais tias cheeb tsam muaj xws li ib daim teb defining qhov chaw ntawm cov ntaub ntawv muaj nyob rau hauv txoj kab.

Liaj teb muaj qhov tseem ceeb uas hais kom meej seb cov ntaub ntawv uas muaj tuaj nyob rau hauv lub hlwb ntawm lub PivotTable. Nyob rau hauv lwm yam lus, nws yog ib cov ntaub ntawv uas yog sau ua ke nyob rau hauv rau kem tom kawg (tso ua ke los ntawm default).

Teb los ntawm qhov cov ntaub ntawv uas koj muab ib daim ntawv rau (los yog lim) yog tso tawm nyob rau hauv lub PivotTable tsab ntawv ceeb toom.

Nkag siab txog cov saum toj no qhov tseem ceeb, raws li zoo li ib co lwm cov chaw yuav tso cai rau koj kom to taub yuav ua li cas "Eksele" ua ib lub rooj. Nco ntsoov hais tias sib txawv versions ntawm qhov kev pab cuam, ib co ntawv qhia zaub mov khoom tej zaum yuav txawv.