Excel 2013 Pivot Tables: Including the “Data Model” Front Cover

Excel 2013 Pivot Tables: Including the “Data Model”

Description

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 Select 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 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!
To access the link, solve the captcha.