Jayne Wilkins & Associates Training Courses In Kent In London

01303 268357

jayne@jaynewilkins.co.uk

Microsoft Excel Courses - PowerPivot

Microsoft Excel Courses

Microsoft Excel PowerPivot

PowerPivot for Excel 2013 is a powerful add-in that gives you the ability to work with large and multiple areas for analysing and summarsing data.

This Microsoft® PowerPivot Introductory course shows you how to use PowerPivot to import data from a variety of sources and create powerful Pivot Tables.

To get the most out of this course you should be an experienced Excel user and have ideally attended the Excel advanced course.

From: £POA
Level: PowerPivot
Duration: 2 Days

Introducing PowerPivot

  • Installing the PowerPivot Add-in
  • Looking at the Data Model window

Importing Data

  • Importing data from multiple sources
  • Creating relationships between tables

Creating PivotTables

  • Creating a PivotTable with PowerPivot
  • Using the Field List
  • PowerPivot and Excel PivotTables compared

Creating a Date Table

  • Grouping Dates in PivotTables
  • Using Year and Month Columns
  • How to use Date filters

Filtering Data with Slicers

  • Using slicers to filter data
  • Using slicers across multiple PivotTables

PivotCharts and Dashboards

  • Using Charts and slicers to create interactive dashboards

Introducing PowerView

  • A brief overview of PowerView

What is DAX?

  • Introducing DAX
  • Using Dax in PowerPivot Tables
  • Creating Calculated Columns and Fields
  • Using DAX to create calculated columns and fields
  • Using popular DAX functions

Advanced DAX Functions

  • Using Advanced DAX Functions including: SumX and ALL Functions

Time Intelligence Functions

  • FInding Year to date, month to date and other popular groupings

Using PowerPivot Sets

  • Using a PowerPivot set to get the required data from a PowerPivot PivotTable