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 huwandu hwehutano hwekamuri imwe neimwe kana munda we data mune yako database. Iyi nhanho nhanho tutori inosanganisira muenzaniso wekuwana mavhareji ehutano kune imwe ruzha rwe data mune database. Matanho ari mumudzidzi uyu ndeaya:
- Pinda Tutorial Data
- Kuronga Dhina Sample
- Kuwana Average Value
01 ye 02
Pinda Subtotal Tutorial Data
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.
Nokuda kweikudzidzisa:
Isa data mumasero A1 kusvika kuD12 sezvinoonekwa mumufananidzo uri pamusoro. Kune avo vasinganzwi kufarira kuverenga, deta, mirayiridzo yekuikopa muExcel, inowanika pane iyi link.
02 of 02
Kuronga Dhiyabhorosi
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 mavhareji emitemo yega yega yega yekutengesa kuitira kuti data inofanira kusarudzwa neChirongo chinyorwa.
Kuronga Dhiyabhorosi Nekutengesa Mharaunda
- Dragodza masero A2 kusvika D12 kuti uonekwe . Iva nechokwadi kuti usasanganise zita iri mumutsara mumwe mukusarudza kwako.
- Dzvanya pane Data Data tab yebhoni .
- Dzvanya paIndaneti mamiriro acho ari pakati pebhoni re data kuti uzarure Hurongwa hwebhokisi yebhokisi .
- Sarudza Rongedza Nharaunda kubva pakaderera pasi pasi peColumn iri mubhokisi rebhokisi.
- Iva nechokwadi chokuti Data yangu ine musoro wepamusoro inotariswa kumusoro kwekona yekona yebhokisi rebhokisi.
- Dzvanya OK.
- 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.