Mmene Mungakoperekere Palegalamu ya Pivot Table mu Excel Worksheet
Ma tebulo a pivot ndiwamphamvu kwambiri mu Excel. Amaika mphamvu zowonongeka ndi zowonongeka m'manja mwanu. Mumagwiritsa ntchito matebulo ophatikizira kuti mutengepo mauthenga kuchokera ku matebulo akuluakulu opanda deta popanda kugwiritsa ntchito njira.
Nkhaniyi ikuphatikizapo malangizo okopera zitsanzo zomwe zafotokozedwa m'munsimu mu Excel sheet . Deta ikuyenda pang'onopang'ono Phunziro la Pivot Phunziro la Pivot .
Mmene Mungakopere Mabuku Ophunzitsira
Musanayambe maphunziro, tsatirani ndondomekoyi kuti mufanizire deta yanuyi mu fayilo yanu ya Excel:
- Onetsani deta mu tebulo ili m'munsiyi. Onetsetsani kuti muzisankha kuchokera ku mutu wakuti "Kugula kwa Cookie M'dera" mpaka nambala "$ 69,496" pansi pa tebulo.
- Sankhani Edit > Koperani kuchokera ku menyu mumsakatuli wanu.
- Dinani pa selo A1 mu pepala losawerengeka la Excel kuti mupange selo yogwira ntchito .
- Dinani pa tsamba la Pakiti.
- Dinani pamsana wotsika pafupi ndi Koperani zojambulajambula paboni kuti mutsegule menyu otsika pansi.
- Sankhani Padera kuchokera pa menyu kuti mutsegule Chofunika Chachidwi.
- Sankhani Pasitala ndi Malembo kuchokera pazinthu zomwe zili mubox.
Chidutswa chilichonse cha deta chimadulidwa mu selo losiyana pa tsamba. Deta iyenera kudzaza ma A1 mpaka D12.
Deta Pang'onopang'ono Pivot Table Tutoria l
Zokokie Zogulitsa M'dera | |||
SalesRep | Chigawo | # Malamulo | Maulosi Onse |
Bill | Kumadzulo | 217 | $ 41,107 |
Frank | Kumadzulo | 268 | $ 72,707 |
Harry | Kumpoto | 224 | $ 41,676 |
Janet | Kumpoto | 286 | $ 87,858 |
Joe | South | 226 | $ 45,606 |
Marita | East | 228 | $ 49,017 |
Mariya | Kumadzulo | 234 | $ 57,967 |
Ralph | East | 267 | $ 70,702 |
Sam | East | 279 | $ 77,738 |
Tom | South | 261 | $ 69,496 |
Tsopano mwakonzeka kugwira ntchito kudzera mu Pivot Table Tutorial .