Introducing power pivot

Summary

In this course we’ll introduce the Excel Data Model, commonly known as Power Pivot. You’ll learn how to load tables of data, link them to create a data model, and create insightful Pivot Tables and Pivot Charts. You’ll apply key concepts through case-study style learning, with concise lessons and applied assessments.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This is an intermediate course suited to people with a general knowledge of Excel but not necessarily any knowledge of Power Pivot. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to learn to use Power Pivot.

Course Overview

This Kubicle course contains 15 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Installing Power Pivot
  • Loading Data to the Excel Data Model
  • Data View and Diagram View
  • Relationships
  • Calculated Columns
  • Remove blank cells with Macros
  • Measures
  • Creating a PivotTable from Power Pivot Data
  • Creating a PivotChart from Power Pivot Data
  • Adding Slicers to PivotTables and PivotCharts
  • Updating the Data Model

Key Outcomes

Once you’ve completed this course, you’ll understand how the Excel Data Model works. You’ll be able to create a data model by importing several tables, and you’ll be able to generate insights from the data model in just a few clicks. You’ll be able to analyze large amounts of data much quicker than you would with other Excel features.