Yuav ua li cas thiaj nrhiav tau tus nqi loj tshaj plaws hauv Excel Database los yog Sau

01 ntawm 04

Excel SUBTOTAL Feature Overview

Nrhiav cov Largest Values ​​nrog Excel 2007 tus Subtotal Feature

Excel tus Subtotal feature ua haujlwm los ntawm inserting lub SUBTOTAL muaj nuj nqi rau hauv ib lub database los yog ib daim ntawv teev cov ntaub ntawv muaj feem xyuam. Siv cov Subtotal feature ua kev tshawb nrhiav thiab muab cov ntaub ntawv tawm los ntawm ib lub rooj loj ntawm cov ntaub ntawv ceev thiab yooj yim.

Txawm tias nws yog hu ua "Subtotal feature", koj tsis tas rau kev nrhiav cov nyiaj los sis tag nrho rau cov kab ntawv xaiv ntawm cov ntaub ntawv. Ntxiv nrog rau qhov tag nrho, koj tuaj yeem kuj pom tias qhov tseem ceeb tshaj plaws rau txhua qhov kev teev npe ntawm tus database.

Cov kauj ruam no yog ib kauj ruam zuj zus xws li ua piv txwv txog kev muag khoom siab tshaj plaws rau txhua thaj tsam muag.

Cov kauj ruam hauv phau ntawv no yog:

1. Nkag mus rau Cov Ntawv Qhia Tawm
2. Txheeb Cov Qauv Cov Ntaub Ntawv
3. Nrhiav Tshaj Lawm Tshaj Lij

02 ntawm 04

Nkag mus rau Cov Ntaub Ntawv Xov Xwm Ntawm Tag Nrho

Lus Cim: Rau kev pabcuam ntawm cov lus qhia no saib daim duab saum toj no.

Thawj kauj ruam uas siv cov Subtotal feature hauv Excel yog nkag mus rau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .

Thaum ua li ntawd, khaws cov lus hauv qab no:

• Nws yog ib qho tseem ceeb kom nkag mus rau cov ntaub ntawv kom raug. Tsis raug teeb meem, vim yog cov ntaub ntawv nkag tsis raug, yog lub hauv paus ntawm ntau cov teeb meem ntsig txog kev tswj xyuas cov ntaub ntawv.
  
• Tsis txhob sau ntawv tsis muaj dab tsi los yog txhua kab ntawv thaum nkag mus rau hauv cov ntaub ntawv. Qhov no suav nrog TSIS tawm hauv kab sab nraud ntawm kem npe thiab thawj kab ntawm cov ntaub ntawv.

Rau Txoj Kev Nyeem

Sau cov ntaub ntawv rau hauv hlwb A1 rau D12 raws li pom hauv daim duab saum toj no. Rau cov neeg uas tsis xav zoo li typing, cov ntaub ntawv, cov lus qhia rau kev luam mus rau hauv Excel, muaj nyob rau ntawm qhov txuas no.

03 ntawm 04

Sorting Cov Ntaub Ntawv

Lus Cim: Rau kev pabcuam ntawm cov lus qhia no saib daim duab saum toj no. Nyem rau ntawm daim duab kom loj.

Ua ntej subtotals tau ua ntawv thov, koj cov ntaub ntawv yuav tsum tau muab tso ua ke los ntawm kem ntawm cov ntaub ntawv koj xav muab cov ntaub ntawv tawm los ntawm.

Qhov kev sib koom tes no yog siv Excel's Sort feature .

Nyob rau hauv qhov kev nyeem no, peb xav nrhiav ntau tshaj xaj ntawm ib thaj chaw muag khoom ces cov ntaub ntawv yuav tsum tau muab txheeb los ntawm Cheeb Tsam sab xa.

Txheeb Xyuas Cov Ntaub Ntawv Nrug ntawm Muag Khoom Thaj Tsam

1. Xaiv lub hlwb A2 rau D12 los qhia lawv. Nco ntsoov tsis pub muaj lub npe ntawm kab ntawv hauv koj xaiv.
   
2. Nias rau ntawm cov ntaub ntawv ntawm txoj hlua .
   
3. Ndliv lub Nres Khawm nyob nruab nrab ntawm cov ntaub ntawv xov ribbon qhib qhov khawm sib tham .
   
4. Xaiv Tsi ntawm Region los ntawm txoj kev nco npe nyob rau sab Kem sau npe hauv lub thawv ntawv.
   
5. Nco ntsoov tias Kuv cov ntaub ntawv muaj cov npe yog kos nyob rau saum toj kawg kiag sab xis ntawm lub thawv ntawv.
   
6. Nyem OK.
   
7. Cov ntaub ntawv nyob rau hauv hlwb A3 rau D12 yuav tsum tam sim no sorted alphabetically los ntawm thib ob kem Region . Cov ntaub ntawv rau peb muag reps ntawm cheeb tsam East yuav tsum raug sau ua ntej, tom qab North, ces South, thiab thaj tsam West thaj tsam.

04 ntawm 04

Nrhiav Tus Nqi Siv Lawm Siv Luam Tshaj

Lus Cim: Rau kev pabcuam ntawm cov lus qhia no saib daim duab saum toj no.

Hauv cov kauj ruam no, peb yuav siv cov Subtotal feature los nrhiav qhov siab tshaj tus nqi ntawm ib cheeb tsam. Yuav nrhiav tau tus nqi siab tshaj los yog ntau tshaj plaws, Cov Qib Tag Nrho cov lus siv ua MAX.

Rau no nyeem:

1. Luag xaiv cov ntaub ntawv nyob rau hauv hlwb A2 rau D12 ntsig txog lawv.
   
2. Nias rau ntawm cov ntaub ntawv ntawm txoj hlua.
   
3. Ndliv lub khawm Subtotal qhib lub thawv Sib Tham Xov Xwm.
   
4. Rau qhov kev xaiv thawj zaug hauv lub thawv ntawv sib tham Ntawm txhua qhov kev hloov hauv: xaiv Region los ntawm txoj kev nco.
   
5. Rau qhov kev xaiv thib ob hauv lub thawv ntawv sib tham Siv kev ua haujlwm: xaiv MAX los ntawm kev sau npe.
   
6. Rau qhov kev xaiv thib peb nyob rau hauv lub thawv kab ntawv Ntxiv rau cov xaib mus rau: kos tawm Cov Nyiaj Muag Khoom Tag nrho ntawm cov kev xaiv nyob rau hauv lub qhov rais.
   
7. Rau peb lub vev xaib hauv qab ntawm lub thawv sab nrauv, kos rau:
   
   Hloov subtotals tam sim no
   Lus xaus hauv qab no
   
8. Nyem OK.
   
9. Cov ntaub ntawv yuav tsum tam sim no xam cov khoom muag tshaj plaws rau txhua cheeb tsam (kab 6, 9, 12, thiab 16) thiab Grand Max (qhov siab muag tag nrho rau txhua thaj tsam) hauv kab 17. Nws yuav tsum yog cov duab ntawm saum toj ntawm no nyeem.