Microsoft Excel 2019 Power Pivot and Power View Training Course Outline

Audience:  This course is designed for experienced users of Excel Pivot Tables wishing to further their knowledge in Excel Power Pivot. Microsoft Power Pivot is a Microsoft Excel 2019 Add-in used for creating Business Intelligence (BI) reports based on large data sets inside the familiar environment of Excel Pivot Tables. Microsoft Power View creates visual reports from Excel data models. Both Power Pivot and Power View are only available in the Professional Plus editions of Microsoft Office.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel 2019 Power Pivot training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Navigate the Power Pivot window
  • Specify source data for Power Pivot
  • Preparing data for analysis
  • Format data
  • Create Power Pivot Relationships
  • Enter Power Pivot Calculations using DAX
  • Create Key Performance Indicators (KPI’s)
  • Visualise data using Power View
  • Create Power View Charts and Maps

Course Outline

Module 1: Introduction to Power Pivot

  • Opening the Power Pivot window
  • Navigating the Power Pivot window
  • Exploring Power Pivot tabs and field list

Module 2: Source data for Power Pivot

  • Data sources and types supported by Power Pivot workbooks
  • Importing data
  • Adding tables to a Power Pivot model
  • Linking to Excel Tables

Module 3: Preparing data for analysis

  • Working with Tables and Columns
  • Filtering and Sorting Data
  • Creating Table Relationships
  • Creating calculations

Module 4: Formatting Data

  • Creating and deleting a table
  • Renaming a Table or Column
  • Setting the Data Type of a Column
  • Hiding and Freezing Column
  • Sorting and filtering table data

Module 5: Power Pivot Relationships

  • Understanding Relationships
  • Creating Relationship between Tables
  • Viewing and Editing Relationships
  • Deleting Relationships

Module 6: DAX Mathematical functions

  • INT function
  • MOD function
  • ROUND function
  • ROUNDUP function
  • ROUNDDOWN function

Module 7: DAX Time Intelligence functions

  • Creating comparisons across comparable time periods.
  • CLOSINGBALANCEMONTH function
  • CLOSINGBALANCEQUARTER function
  • CLOSINGBALANCEYEAR function
  • DATEADD function
  • DATESBETWEEN function
  • DATESINPERIOD function
  • DATESMTD function
  • DATESQTD function
  • DATESYTD function
  • ENDOFMONTH function
  • ENDOFQUARTER function
  • ENDOFYEAR function
  • FIRSTDATE function
  • FIRSTNONBLANK function
  • LASTDATE function
  • LASTNONBLANK function
  • NEXTDAY function
  • NEXTMONTH function
  • NEXTQUARTER function
  • NEXTYEAR function
  • OPENINGBALANCEMONTH function
  • OPENINGBALANCEQUARTER function
  • OPENINGBALANCEYEAR function
  • PARALLELPERIOD function
  • PREVIOUSDAY function
  • PREVIOUSMONTH function
  • PREVIOUSQUARTER function
  • PREVIOUSYEAR function
  • SAMEPERIODLASTYEAR function
  • STARTOFMONTH function
  • STARTOFQUARTER function
  • STARTOFYEAR function
  • TOTALMTD function
  • TOTALQTD function
  • TOTALYTD function
, Microsoft Excel 2019 Power Pivot and Power View Training Course Outline
, Microsoft Excel 2019 Power Pivot and Power View Training Course Outline