Excel 2013 Pivot Tables

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!