Yadda za a Kwafi Rubutun Bayanan Labarai a cikin Ɗaukar Hanya na Excel
Tables na Pivot sune fasali a Excel. Suna sanya sassauci da ikon yin nazari a hannunka. Kuna amfani da matakan da ke da mahimmanci don cire bayanai daga manyan bayanai ba tare da yin amfani da su ba.
Wannan labarin ya haɗa da umarnin don kwashe samfurin samfurin da aka nuna a ƙasa a cikin takardar aikin Excel. Bayanai yana biye da Mataki na Mataki na Tasirin Pivot Table Tutorial .
Yadda za a Kwafi Takaddun rubutu
Kafin ka fara da koyawa, bi wadannan matakai don kwafe samfurin samfurin a cikin fayil na Excel naka:
- Ƙara bayanin bayanai a cikin tebur a kasa. Tabbatar zaɓin daga lakabi "Kasuwancen Kuki ta Yanki" zuwa lambar "$ 69,496" a kasa na tebur.
- Zaɓi Shirya > Kwafi daga menu a cikin shafukan yanar gizonku.
- Danna kan salula A1 a cikin takardun aikin Excel wanda ba a ɗawainiya don sa shi tantanin halitta mai aiki .
- Danna kan shafin shafin.
- Danna maɓallin ƙusa kusa da Rubutun allon littafi a kan rubutun don buɗe menu mai saukewa.
- Zaɓi Manna Musamman daga menu don buɗe akwatin maganganu na Manya .
- Zaɓi Manna da Rubutu daga zaɓuɓɓuka a cikin akwatin maganganu.
Kowace bayanan da aka ba da shi a cikin ɗakin da aka raba a cikin takardun aiki. Bayanai ya kamata cika filin A1 zuwa D12.
Data don Mataki ta Mataki na Excel Pivot Table Tutoria l
Kasuwanci Kasuwanci ta Yanki | |||
SalesRep | Yanki | # Dokokin | Total tallace-tallace |
Bill | Yamma | 217 | $ 41,107 |
Frank | Yamma | 268 | $ 72,707 |
Harry | Arewa | 224 | $ 41,676 |
Janet | Arewa | 286 | $ 87,858 |
Joe | Kudu | 226 | $ 45,606 |
Martha | Gabas | 228 | $ 49,017 |
Maryamu | Yamma | 234 | $ 57,967 |
Ralph | Gabas | 267 | $ 70,702 |
Sam | Gabas | 279 | $ 77,738 |
Tom | Kudu | 261 | $ 69,496 |
Yanzu kuna shirye don yin aiki ta hanyar Pivot Table Tutorial .