Power Pivot for Microsoft Excel Course

This course is designed to be hands-on. You will learn skills that you can apply to your own work. Bring your own projects, files and questions to the training, or use our free support anytime after training.

We specialise in on-site and online customised training, which means we can schedule the course at a date that suits you and tailor the content to address your requirements.

Unleash Excel Business Intelligence! This course includes:

  • Power Pivot workbooks
  • Excel Data Model
  • Create table relationships
  • Import & query data
  • Power PivotTable and Charts

Power Pivot for Microsoft Excel Course Content

Course Duration

One day or two half-days

\

Course Objectives

After completing this course you will be able to describe the main ways to import and query data using Power Pivots workbooks in Excel, to generate PivotTable and PivotChart reports and to create relationships between Power Pivot tables.

Course Prerequisites

Previous knowledge of Excel PivotTable features is useful but not essential. Basic understanding of relational data is useful but not essential.

Who is this Course for

Professionals who want to use Power Pivot full capabilities in Excel 2010 and who recognise the need for Business Intelligence.

Introduction

 

  • Why use PowerPivots
  • PowerPivot Workbooks
  • The PowerPivot tab
  • Data sources
  • Relationships
Importing Data

 

  • Using the Table Import Wizard
  • Import and Filter from Databases
  • Run SQL Query
  • Get Data from Files
  • Copy and Paste Data
  • Create Linked Tables
PowerPivot Tables

 

  • Formatting Numbers
  • Handling Technical and Useless Columns
  • Understanding Calculated Columns
  • Using Lookup Tables
  • Understanding Measures
  • Handling Many Tables
  • Refreshing Data
Creating Relationships

 

  • Understanding relationships
  • Review existing relationships
  • Create new relationships
Building DAX Formulas

 

  • Formula basics
  • DAX Data Types
  • DAX Operators
  • Calculated Columns Examples
  • DAX Measure Examples
  • RELATED, CALCULATE functions
PivotTables & PivotChart Reporting

 

  • Difference between Excel PivotTable and PowerPivot PivotTables
  • Updating the table
  • Changing the table structure
  • Formatting the PivotTable
  • Creating a PivotChart
  • PivotChart Layouts
  • Changing the Chart type
  • Formatting the Chart
Slicers

 

  • Adding slicers to PivotTables and Charts
  • Resizing Slicers
  • Slicer options

Get a quote

Data Protection:
Business Brains needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.

13 + 14 =

i

Tailored to your needs

w

Free Support



Results for your business