Tsela ea ho Kopitsa Letlapa la Pivot ea Ditaba ka har'a Excel Worksheet
Mathala a pivot ke karolo e matla ho Excel. Ba beha matla a ho feto-fetoha le matla a ho hlahloba matsohong a hau. U sebelisa litafole tsa pivot ho ntša boitsebiso ho tsoa litafole tse kholo tsa data ntle le ho sebelisa mekhoa.
Sehlooho sena se kenyeletsa litaelo tsa ho etsisa lintlha tse bontšitsoeng mona ka tlase ho Excel sheet sheet . Boitsebiso bo tsamaea le Tutori le Mehato ea Excel Pivot Table .
Ho Kopitsa Tutorial Text
Pele u qala thupelo, lateloa mehato ena ho kopitsa tlhahiso ea data ho hau ea hau ea Excel:
- Totobatsa litlaleho tafoleng e ka tlase. Etsa bonnete ba hore u tla khetha sehloohong se reng "Li-Cookie Sales by Region" ho palo "$ 69,496" tlase tafoleng.
- Khetha Edit > Kopitsa ho tswa ho menu ho sebadi sa hau sa marang-rang.
- Tobetsa seleng ea A1 ka har'a leqephe la Excel le sa sebetsoeng ho etsa hore e be sele e sebetsang .
- Tlanya tabeng ea lapeng .
- Tobetsa motsu o ka tlase ho Phunya lebokose la libopeho leboteng ho bula menu e theoha.
- Khetha Pale e khethehileng ho tswa ho menyetla ea ho bula lebokose la lihlooho tse khethehileng.
- Khetha Setho le Mongolo ho tloha ho dikgetho tse lebokoseng la lebokose.
Letoto le leng le le leng la data le kenngoa ka seleng e arohaneng mosebetsing. Dintlha e tlameha ho tlatsa tekanyo ea A1 ho ea ho D12.
Dintlha bakeng sa Mehato le Mehato Excel Pivot Table Tutoria l
| Cookie Sales ka Sebaka | |||
| SalesRep | Sebaka | # Litaelo | Kakaretso ea Lichelete |
| Bill | Bophirimela | 217 | $ 41,107 |
| Frank | Bophirimela | 268 | $ 72,707 |
| Harry | Leboea | 224 | $ 41,676 |
| Janet | Leboea | 286 | $ 87,858 |
| Joe | Boroa | 226 | $ 45,606 |
| Martha | Bochabela | 228 | $ 49,017 |
| Maria | Bophirimela | 234 | $ 57,967 |
| Ralph | Bochabela | 267 | $ 70,702 |
| Sam | Bochabela | 279 | $ 77,738 |
| Tom | Boroa | 261 | $ 69,496 |
Hona joale u se u loketse ho sebelisa Tutorial ea Pivot Table .