Nzira Yokuwana Nayo Mazano Akanyanya Kukuru mune imwe Excel Database kana List

01 ye 04

Excel SUBTOTAL Feature Overview

Tsvaga Maitiro Akanakisa Ne Excel 2007's Subtotal Feature

Excel's Subtotal feature inoshanda kuburikidza nekuisa SUBTOTAL basa mune d database kana kuti mazita emamwe mashoko akaenzana. Kushandisa Subtotal chinhu kunoita kuti uwane uye kubvisa ruzivo rwakananga kubva kune tafura huru yedata nekukurumidza uye nyore.

Kunyangwe ichinzi "Subtotal feature", iwe hausi wekuwana huwandu kana huwandu hwemitsara yakasarudzwa yedata. Mukuwedzera kune yose, unogonawo kuwana hukuru hukuru pane imwe neimwe chikamu chedata rekodhi.

Iyi nhanho-ne-chidzidzo chekudzidzisa inosanganisira muenzaniso wekuwana iyo yakakwirira yekutengesa yega yega yega yekutengesa nzvimbo.

Matanho ari mumudzidzi uyu ndeaya:

1. Pinda Tutorial Data
2. Kuronga Dhina Sample
3. Kuwana Iko Mukurusa Kukuru

02 of 04

Pinda Subtotal Tutorial Data

Cherechedza: Kubatsirwa nemirayiridzo iyi ona mufananidzo uri pamusoro.

Nhanho yekutanga yekushandisa iyo Subtotal inowanikwa muExcel ndiyo kuisa dhidhiyo muhwhepa .

Paunenge uchidaro, chengetedza pfungwa dzinotevera mupfungwa:

• Zvakakosha kuisa data nenzira yakarurama. Zvikanganiso, zvichikonzerwa nekupinda kwakashata kwemadhina, ndizvo zvinokonzera matambudziko mazhinji ane chokuita nekugadzirisa deta.
  
• Siya mitsara isina kana mahwendefa kana uchinge waisa data. Izvi zvinosanganisira kusarega mutsara usina chinhu pakati pehurukuro yemusoro uye mutsara wekutanga wedata.

Pamusoro peTetorial

Isa data mumasero A1 kusvika kuD12 sezvinoonekwa mumufananidzo uri pamusoro. Kune avo vasinganzwi kufarira kuverenga, deta, mirayiridzo yekuikopa muExcel, inowanika pane iyi link.

03 of 04

Kuronga Dhiyabhorosi

Cherechedza: Kubatsirwa nemirayiridzo iyi ona mufananidzo uri pamusoro. Dzvanya pamufananidzo kuti uwedzere.

Pamberi pezvinyorwa zvese zvingashandiswa, deta yako inofanira kuumbwa ne column ye data iwe uchida kubvisa ruzivo kubva.

Iko kuunganidza kunoitwa kuburikidza neExcel's Sort feature .

Muchidzidzo ichi, tinoda kuwana nhamba yepamusoro yemirairo yega yega yekutengesa kuitira kuti data inofanira kusarudzwa neChirongo chinyorwa.

Kuronga Dhiyabhorosi Nekutengesa Mharaunda

1. Dragodza masero A2 kusvika D12 kuti uonekwe. Iva nechokwadi kuti usasanganise zita iri mumutsara mumwe mukusarudza kwako.
   
2. Dzvanya pane Data Data tab yebhoni .
   
3. Dzvanya paIndaneti mamiriro acho ari pakati pebhoni re data kuti uzarure Hurongwa hwebhokisi yebhokisi .
   
4. Sarudza Ronga Nharaunda kubva pakaderera pasi pasi peColumn iri mubhokisi rebhokisi.
   
5. Iva nechokwadi chokuti Data yangu ine musoro wepamusoro inotariswa kumusoro kwekona yekona yebhokisi rebhokisi.
   
6. Dzvanya OK.
   
7. Nhamba iri mumasero A3 kusvika kuD12 inofanira kunge yakarongwa maererano nerabhaibheri nechikamu chechipiri Chikamu . Nhoroondo yekutengesa mitatu inobva kuEast region inofanira kutanga yakanyorwa, inoteverwa neNorth, iyo yeSouth, uye inopedzisira kuWest region.

04 we 04

Kutsvaga Chirongwa Chikuru Kupfuura Zviduku

Cherechedza: Kubatsirwa nemirayiridzo iyi ona mufananidzo uri pamusoro.

Munhanho iyi, isu tichashandisa Subtotal feature kuwana nzvimbo yakakwirira yekutengesa chiyero nechikamu. Kuti uwane hukuru hwepamusoro kana hukuru hunokosha, iyo Subtotal feature inoshandisa MAX basa.

Nokuda kweikudzidzisa:

1. Dragsanisa data mumasero A2 kusvika D12 kuti uonekwe.
   
2. Dzvanya pane Data Data tab yebhoni.
   
3. Dzvanya paIndaneti yekutora kuti uzarure Subtotal dialog box.
   
4. Nokuda kwesarudzo yekutanga mubhokisi yebhokisi Pane imwe shanduko pane: Sarudza Chikamu kubva pakaderera pasi.
   
5. Nokusarudza kwechipiri mubhokisi rekushandisa Shandisa basa: sarudza MAX kubva pakaderera pasi.
   
6. Nokusarudzo yechitatu mubhokisi rebhokisi Uwedzera maverengera kune: chengetedza Maitengo Mazhinji chete kubva pane zvakasarudzwa zviri muhwindo.
   
7. Kune mabhokisi matatu ekuongorora pasi pebhokisi rebhokisi, chengeta:
   
   Dzorera zvinyorwa zvino
   Chidimbu pasi apa data
   
8. Dzvanya OK.
   
9. Dhafura yezvinyorwa inofanira kunge inosanganisira yepamusoro yekutengesa kwenyika imwe neimwe (mitsara 6, 9, 12, uye 16) uyewo Grand Max (iyo yakatengeswa yepamusoro yezvikamu zvose) mumuganhu 17. Inofanira kufanana nemufananidzo pa Pamusoro peyikudzidzisa.