On Demand Webinar

Excel: Power Pivot - Taking Pivot Tables to the Next Level

Webinar Details$219

  • Webinar Length: 100 Minutes
  • Guest Speaker:  Mike Thomas
  • Industry:  Business Administration, Business Skills, Finance, Software, Taxation and Accounting
  • Purchase Webinar

Power Pivot, a free addin for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of limitations and frustrations that many advanced users find with Pivot Tables. For example, using Power Pivot you can…

Create Pivot Tables from multiple Excel-based lists without using VLOOKUP

Create Pivot Tables from large datasets without worrying about file size or performance

Combine together related data from multiple data sources (Excel, database, text file etc) into a single Pivot Table

Create powerful calculations on the data in your Pivot Tables

Topics covered:

Importing data into Power Pivot - the why and how

Using the Data Model to create and manage relationships

The benefits of using the Data Model

Creating a Pivot Table from related Excel tables

Creating a Pivot Table from related data sources (including external sources)

Creating powerful calculated fields in a Pivot Table

Who should attend:
This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot.  Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

Guest Speaker

Mike Thomas

Mike Thomas

Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support to users. He is a subject matter expert in a range of Microsoft technologies including Microsoft Office, Lync/Skype for Business and SharePoint. He has extensive experience of working with Cloud-based ... View Full Profile