Nzira Yokukopa Pivot Table Data muIntcel Worksheet
Tafura dzepivot inhengo ine simba muExpcel. Vanoisa kushanduka uye simba rekuongorora mumaoko ako. Iwe unoshandisa matafura epivot kuti ubvise ruzivo kubva kumatafura makuru e data usingashandisi mapepa.
Ichi chinyorwa chinosanganisira mirayiridzo yekutevedzera shanduro ye data inoratidzwa pasi apa muExpcel worksheet . Nhamba iyi inofambidzana neNhanho Nhanho Excel Pivot Table Tutorial .
Nzira Yokukopa Tutorial Text
Iwe usati watanga tutori, tevera matanho aya kuti uenzanise shanduro yedhadha yako mune yako Excel file:
- Simbisai data iri patafura iri pasi apa. Iva nechokwadi chekusarudza kubva pachiratidzo che "Cookie Sales by Region" kusvika ku "$ 69,496" pasi petafura.
- Sarudza Hindura > Kopi kubva mumenyu mune web browser yako.
- Dzvanya pane sero A1 mune pepa rekushanda re Excel risina kutaurwa kuitira kuti riite sero rinoshanda .
- Dzvanya paIndaneti tab.
- Dzvanya pamusorosoro pasi pedyo neKutapira bhidhiyobhodhi pabhoni kuitira kuti uzarure mhando inodonha.
- Sarudza Pasha yakakosha kubva pane menyu kuti uzarure Bhuku Rinokosha rebhokisi .
- Sarudza Nyora uye Nyaya kubva pane zvaunogona kuita mubhokisi rebhokisi.
Chikamu chimwe nechimwe che data chinopinda mune imwe sero iri mubasa rekushanda. Dheedhi inofanira kuzadza rutsanga rweA1 kusvika D12.
Dhiyabhorosi Nhanho Nechiito Excel Pivot Table Tutoria l
| Cookie Sales by Region | |||
| Mutengesi | Nharaunda | # Orders | Total Sales |
| Bill | Madokero | 217 | $ 41,107 |
| Frank | Madokero | 268 | $ 72,707 |
| Harry | Mawodzanyemba | 224 | $ 41,676 |
| Janet | Mawodzanyemba | 286 | $ 87,858 |
| Joe | Chamhembe | 226 | $ 45,606 |
| Marita | Mabvazuva | 228 | $ 49,017 |
| Maria | Madokero | 234 | $ 57,967 |
| Ralph | Mabvazuva | 267 | $ 70,702 |
| Sam | Mabvazuva | 279 | $ 77,738 |
| Tom | Chamhembe | 261 | $ 69,496 |
Iye zvino wava kugadzirira kushanda kuburikidza nePivot Table Tutorial .