Anan akwai jagorar mataki-mataki don ƙirƙirar tebur pivot a cikin Excel.
Za mu fara da amsa tambaya mafi sauƙi:Menene Pivot Tables a cikin Excel?"- sannan za mu nuna yadda ake ƙirƙirar tebur mai sauƙi a cikin Excel.
Masu zuwa za su nuna maka yadda ake ƙirƙirar ƙarin ci gaba XNUMXD Excel PivotTable. A ƙarshe, za mu nuna muku yadda ake warware PivotTables ta filayen bayanai ta yadda zaku iya fitar da bayanan da kuke buƙata cikin sauƙi. Kowane sashe na koyawa an kwatanta shi da misalan allunan pivot.
Saboda yanayin da aka yi amfani da shi don ƙirƙirar PivotTables a cikin Excel 2003 ya ɗan bambanta da sigogin baya, mun ƙirƙiri nau'ikan Sashe na 2 da 4 na wannan koyawa. Zaɓi wanda ya dace da sigar Excel ɗin ku.
Ana ba da shawarar farawa da kashi na 1 na koyawa kuma kuyi nazarin Koyawan PivotTable na Excel bi da bi.
- Sashe na 1: Menene PivotTable a Excel?
- Sashe na 2. Yadda ake ƙirƙirar tebur mai sauƙi a cikin Excel?
- Sashe na 3: Ƙungiya a cikin tebur mai pivot.
- Sashe na 4: Babban Tebur Pivot a cikin Excel.
- Sashe na 5: Rarraba a teburin pivot.
Ana iya samun ƙarin horo mai zurfi akan aiki tare da PivotTables akan gidan yanar gizon Microsoft Office.