Excel 2013 Pivot Tables
Including the "Data Model"
A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge.
With pivot tables you can:
* See the data in dozens of different ways with a simple mouse drag
* Perform fast calculations with no need for formulas
* Focus on another part of the data each time and get a clear picture
* Show more trends and patterns
* Create dozens of reports and charts to analyze your data
While reading the book and using the practice files, you will know to:
Create a Pivot Table
oSelect data from the current file
oSelec data from another Excel file
oChange the data source
oCreate a pivot table based on a dynamic data table
Perform Calculations:
oUse sum, average, minimum, maximum and count
oShow Percentage of a column total, row total and Grand total
oDisplay the running total
oGroup numeric and date data
oUse calculated field and calculated item
Change The Report Structure
oSwitching columns and rows
oAdding columns or rows
oAdding a page break between items
Format your Pivot Tables
oAdd totals and Subtotals
oSort
oFilter
You will also know to
•Add slicers and to manipulate then
•Add a timelines and to manipulate it
•Add charts to your pivot tables
•Use the new and innovative feature: "The Data Model"
And, of course, You will learn some cool tips and tricks!
