Microsoft Office Excel PowerPivot 2016

Candidates will learn how Microsoft Office Excel PowerPivot 2016 enables data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a “pivot table”) showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. A deep dive into the functions in this application in Excel.

Essentials and Intermediate training

1. Make Your Data Work for You

  • Maximize the power of Pivot Table
  • Ask the questions
  • Get the answers


2. A Quick Tour

  • Determine what you need to know
  • The source is important
  • Ready, Set, Go
  • The Pivot Table layout
  • What goes where
  • Result of our Pivot Table
  • Viewing our Data differently


3. Manipulating the Pivot Table

  • Rearrange the layout
  • What we get
  • Add a new field
  • Remove a field
  • Rename a field
  • Format Numbers
  • Change the Sort Order & Top 10 Autoshow
  • Refresh data


4. Digging Deeper

  • Create a Quarterly Group
  • Group data manually
  • Display subtotals
  • Hide / Display Grand Total
  • Format a Pivot Table report
  • Using a Slicer
  • Format a Slicer


5. Beyond the Basics

  • Creating a Second Data Field
  • Use count to Summarize Data
  • Display Numerical Data as a Percentage of the Total
  • Create a Custom Calculation
  • More functions in Custom Calculation


6. More Pivot Table Calculations

  • Using Formulas
  • Create a Calculated Field
  • Create a Calculated Item
  • Use Pivot Table Data outside the Report
  • Use Get Pivot Data Function
  • Turn off Get Pivot Data Function


7. Optional Topics

  • Create a Pivot Chart Report
  • Publish Pivot Table Reports to the Web
  • Use Multiple Ranges as Source Data

Course Days: 1 Day