Thaum ua hauj lwm nrog cov ntxhuav, feem ntau muaj cov rooj sib hais thaum, dhau li ntawm tag nrho cov dav dav, nws yuav tsum tau ua kom tamper nrog cov nrab. Piv txwv, hauv txhua lub rooj ntawm kev muag khoom ntawm lub hlis, uas txhua tus kab ntawv qhia txog cov nyiaj tau los ntawm kev muag khoom ntawm ib hom khoom ib hnub twg, koj tuaj yeem ntxiv cov subtotals txhua hnub los ntawm kev muag khoom ntawm tag nrho cov khoom, thiab thaum kawg ntawm lub rooj qhia tus nqi ntawm tag nrho cov nyiaj tau los rau lub tuam txhab. Cia peb kawm seb yuav ua li cas thiaj ua tau rau hauv Microsoft Excel.
Cov kev siv rau kev siv cov haujlwm
Tab sis, hmoov tsis, tsis yog tag nrho cov ntxhuav thiab datasets yog tsim nyog rau kev ua ntawv thov cov kev ua hauj lwm subtotal rau lawv. Cov mob loj muaj xws li nram qab no:
- lub rooj yuav tsum muaj hom ntawm ib qho chaw hauv xov tooj ntawm tes;
- Cov npe ntawm rooj yuav tsum muaj ib kab thiab muab tso rau thawj kab ntawm daim ntawv;
- Lub rooj yuav tsum tsis txhob muaj cov kab nrog cov ntaub ntawv dawb.
Tsim cov sau tawm
Thiaj li tsim subtotals, mus rau "Cov Ntaub Ntawv" tab hauv Excel. Xaiv lub xov tooj ntawm tes ntawm lub rooj. Tom qab ntawd, nias rau khawm "Subtotal", uas yog nyob rau ntawm txoj hlua hauv qhov block of tools "Structure".
Tom ntej no, lub qhov rais qhib hauv qhov koj xav kom teeb tsa qhov sib rho ntawm subtotals. Hauv qhov ua piv txwv, peb yuav tsum saib tag nrho cov nyiaj tau los rau txhua yam khoom rau txhua hnub. Hnub nqi yog nyob rau hauv kem ntawm tib lub npe. Yog li ntawd, nyob hauv thaj chaw "Nrog rau txhua qhov kev hloov hauv" xaiv cov kem "Hnub".
Nyob rau ntawm thaj chaw "Kev Khiav Hauj Lwm" xaiv qhov nqi "Tus nqi", vim peb xav kom haum raws nraim cov nyiaj hauv ib hnub. Ntxiv nrog rau tus nqi, ntau lwm cov haujlwm, muaj xws li:
- kom muaj nuj nqis;
- siab tshaj plaws;
- yam tsawg kawg nkaus;
- txoj hauj lwm.
Vim tias cov nyiaj tau los muaj nyob hauv kab ntawv "Cov nyiaj tau los, RUB.", Ces nyob hauv qhov "Add sumals by" field, peb xaiv los ntawm daim ntawv teev cov kab hauv cov lus no.
Tsis tas li ntawd, koj yuav tsum tau teem ib lub zuam, yog tias nws tsis teem, tom ntej ntawm "Hloov qhov tam sim no" parameter. Qhov no yuav cia, thaum rov qab xam cov lus, yog tias koj tsis ua tus txheej txheem rau kev luj xyuas nrog rau thawj thawj zaug, tsis txhob sib npaug ntawm cov ntaub ntawv ntawm tib lub sij hawm ntau zaus.
Yog tias koj zom lub thawv "Kawg ntawm nplooj ntawv", tom qab ntawd thaum luam ntawv, txhua lub rooj ntawm lub rooj sib tham nrog cov nrab ntawv yuav muab luam tawm ntawm ib phab sab nraud.
Yog tias koj kos lub thawv nyob rau ntawm qhov "Cov lej hauv cov ntaub ntawv" tus nqi, subtotals yuav muab tso rau hauv ib lub nris ntawm cov kab, cov nyiaj hauv lawv yog xam. Yog tias koj tsis pom lub thawv no, ces cov ntsiab lus yuav tshwm sim saum cov kab. Tab sis nws yog tus neeg siv nws tus kheej uas txiav txim siab tias nws nyiam npaum li cas. Rau feem ntau cov neeg, nws yog qhov yooj yim dua kom tso tag nrho cov kab hauv cov kab.
Tom qab tag nrho cov chaw sau npe tiav, nyem rau ntawm "OK" khawm.
Raws li koj tau pom, subtotals tshwm nyob hauv peb cov lus. Tsis tas li ntawd, txhua pawg ntawm cov kab, koom siab los ntawm ib qho kev tshwm sim, tuaj yeem raug txo los ntawm kev tsuas sau rau daim ntawv sau npe tawm, mus rau sab laug ntawm lub rooj, yam tsis zoo ntawm pawg.
Yog li, nws yog ib qho ua tau mus rau tag nrho cov kab nyob hauv ib lub rooj, ces tsuas yog cov nrab thiab cov pejxeem pom.
Nws kuj tseem yuav tsum tau sau tseg tias thaum hloov cov ntaub ntawv hauv cov kab ntawm rooj, lub npe yuav raug rov txiav dua.
Lub mis "INTERIM RESULTS"
Tsis tas li ntawd, nws yog ib qho ua tau kom tso subtotals tsis yog los ntawm khawm ntawm daim kab xev, tab sis yog los ntawm kev ua kom zoo dua ntawm kev muaj peev xwm hu xov tooj tshwj xeeb ntawm Txoj Haujlwm Ntxig Ntxig. Ua li no, ua ntej nias ntawm lub xovtooj ntawm qhov chaw uas lub npe yuav muab tso tawm, nias qhov khawm teev tseg, uas nyob rau sab laug ntawm lub mis bar.
Qhov kev ua lag luam wizard opens. Cov npe ntawm cov haujlwm yog nrhiav cov khoom "INTERIM RESTRTS." Xaiv nws, thiab nyem rau ntawm "OK" khawm.
Lub qhov rais qhib nyob rau hauv uas koj yuav tsum nkag rau cov lus sib cav. Hauv kab "Number of Function" koj yuav tsum nkag mus rau tus naj npawb ntawm kaum ib cov kab txawv ntawm kev ua cov ntaub ntawv, xws li:
- arithmetic nruab nrab;
- cov naj npawb ntawm cov hlwb;
- cov naj npawb ntawm cov hlwb puv nkaus;
- tus nqi siab tshaj plaws hauv cov ntaub ntawv xaiv tau;
- tus nqi qis kawg;
- cov ntaub ntawv cim hauv hlwb;
- qauv sib txawv ntawm cov qauv;
- qauv sib txawv ntawm tag nrho cov pejxeem;
- tus nqi;
- variance hauv cov qauv;
- dispersion nyob rau hauv cov pej xeem.
Yog li, peb nkag mus rau hauv thaj chaw tus naj npawb ntawm qhov kev txiav txim uas peb xav thov rau hauv ib rooj plaub.
Hauv kem "Txuas 1" koj yuav tsum qhia kom meej txog qhov txuas mus rau qhov array ntawm cov hlwb uas koj xav teem caij nruab nrab. Mus txog plaub cais cov xwm txheej raug tso cai. Thaum ntxiv kev sib txuas mus rau ib qho ntawm cov hlwb, lub qhov rais tam sim ntawd yuav tshwm sim kom koj tuaj yeem sib ntxiv rau ntau yam.
Vim nws tsis yooj yim rau kev nkag mus rau ntau yam ntawm manually hauv txhua zaus, koj tuaj yeem nyem rau ntawm lub pob nyob ntawm sab xis ntawm daim ntawv xa tawm.
Hauv qhov no, qhov kev sib cav sib cav yuav raug txo kom tsawg. Tam sim no koj tuaj yeem xaiv qhov kev ntshaw cov ntaub ntawv nrog tus cursor. Tom qab nws tau cia li nkag mus rau hauv daim ntawv, nias rau lub khawm nyob ntawm sab xis.
Qhov kev ua lag luam muaj nuj nqi qhib dua ntxiv. Yog tias koj xav tau ntxiv ib los yog ntau cov ntaub ntawv arrays, ces ntxiv tib algorithm uas tau piav saum toj no. Hauv cov lus sib txeeb, nyem rau ntawm "OK" khawm.
Tom qab ntawd, cov ntsiab lus ntawm cov ntaub ntawv xaiv ntau yuav raug tsim nyob rau hauv lub xov tooj ntawm tes uas lub mis nyob hauv.
Qhov kev ua ntawm qhov kev ua no yog raws li hauv qab no: "INTERMEDIATE.RATINGS (function_number; array_address chaw nyob) Hauv peb cov ntaub ntawv, qhov formula yuav zoo li qhov no:" INTERMEDIATE.REDUCTION (9; C2: C6) "Qhov kev ua no, siv qhov kev ua no, thiab tsis txhob hu rau Master of Functions xwb, koj yuav tsum nco ntsoov, muab qhov "=" kos npe rau ntawm daim qauv ntawm lub mis ntawm tes.
Raws li koj tau pom, nws muaj ob txoj hauv kev tsim cov subtotals: los ntawm khawm ntawm daim kab xev, thiab los ntawm ib qho tshwj xeeb formula. Tsis tas li ntawd, tus neeg siv yuav tsum txiav txim siab saib tus nqi yuav tshwm li cas: nqe, tsawg, qhov nruab nrab, qhov siab tshaj, thiab lwm yam.
