CPD 1.5 hours On Demand Course Online

Excel tips and tricks for business - Session 4 - Using Power Pivot

Learn how to use Power Pivot in Excel. This course is the fourth part of our six-course series on Excel tips and tricks for business.

$109.09

non-member : $130.91

Description

Excel tips and tricks for business - Using Power Pivot forms the fourth part of our six-course series that covers the essentials of using Excel in a business context.

If you use PivotTables, you need to learn how to use Power Pivot. Enhance your data analysis capabilities by running your PivotTables over multiple linked datasets.

  • What is Power Pivot, and how does it differ from PivotTables
  • How to get Power Pivot
  • Introduction to the Data Model – the back-end of Excel
  • Importing data into the Data Model
  • Connecting tables to do analysis over multiple dimensions
  • Using disconnected tables to run scenarios

In the 'Excel tips and tricks for business' series we look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent, robust, flexible and transparent.

You can find more information about the other five sessions in the 'Agenda' tab.

Agenda

Presenter