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
⦾ Select data from the current file
⦾ Selec data from another Excel file
⦾ Change the data source
⦾ Create a pivot table based on a dynamic data table

Perform Calculations:
⦾ Use sum, average, minimum, maximum and count
⦾ Show Percentage of a column total, row total and Grand total
⦾ Display the running total
⦾ Group numeric and date data
⦾ Use calculated field and calculated item

Change The Report Structure
⦾ Switching columns and rows
⦾ Adding columns or rows
⦾ Adding a page break between items

Format your Pivot Tables
⦾ Add totals and Subtotals
⦾ Sort o Filter

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!

The book includes excercises. you can download the files here