Excel 2013 Basics On PivotTables

What is an Excel PivotTable (Pivot Table) and how do you create and work with one, and even with it's brother PivotChart (Pivot Chart)? A PivotTable is an interactive worksheet table, used to quickly analyze and summarize large amounts of data. In a PivotTable you can specify which part of the source data you’d like to interact with by choosing Fields or Items: Fields are categories, and Items are subcategories. And there are four types of Fields: Filter, Row (Labels), Column (Labels) and Values – all the fields but values usually contain Text and values contain numerical values. You can drop these fields in “Drop Zones” and rearrange them too!

Want to see it in action with an example of how to setup an execute an Excel PivotTable and PivotChart? Click on the link before to go to our Excel 2013 Training Video page to purchase!  More specifically, watch videos 91-95.

30th Jul 2016 Kirt Kershaw

Recent Posts