Course Icon Excel Training

Excel Introduction to PowerPivot

Designed for Excel versions 2016,2013,2010

0800 1337 401

Course Objectives

This course is designed for people who need to create Pivot tables based on data sets that have millions of rows and need to use multiple data sources to form the data. PowerPivot allows you to analyse and add data to the model extremely fast and efficient.

Who Should Attend

This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data.

Experience Required

The course is suitable for any Excel user that has good knowledge of Nested functions and a good understanding of Pivot Tables.

Course Syllabus

GETTING STARTED WITH POWERPIVOT

  • Introduction to PowerPivot
  • Exploring the PowerPivot Tab
  • Exploring the PowerPivot window
  • Introduction to the PowerPivot Data Model

CONNECTING TO VARIOUS DATA SOURCES

  • Creating a data model
  • Data Sources supported in PowerPivot
  • Import data from existing files such as Excel and Excel
  • Import data using Excel Linked Tables
  • Import data using Text (txt) files such as Notepad
  • Import data using Comma Separated Values (csv)
  • Import data using the Paste option

MANIPULATING THE DATA IN THE DATA MODEL

  • Add a new column
  • Rename the field
  • Resize the field
  • Assign or change the Data Type
  • Moving columns
  • Deleting columns
  • Sorting Data
  • Filtering Data
  • Paste data into the model using Paste Append and Paste Replace

MANAGING RELATIONSHIPS IN POWERPIVOT

  • Understanding the process of relating tables
  • Create and edit links
  • View relationship links between the tables
  • Create Hierarchies

CREATING A PIVOT TABLE FROM THE POWERPIVOT DATA MODEL

  • Create a Pivot table
  • Assign fields to the Pivot Table
  • Rearrange the fields
  • Introduction to slicers to filter the table
  • Creating Pivot Charts

OVERVIEW OF DAX FORMULAS FOR POWERPIVOT

  • Calculated Columns in the Data Model
  • Creating Measures (Calculated fields) in the Pivot table
  • Overview of creating KPI’s
See all of the available Seven Institute Excel Courses