Interested in attending? Have a suggestion about running this course near you?
Register your interest now


Powerful data analysis and data modeling in Excel

If you are a fan of PivotTables you will love PowerPivot!

PowerPivot enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.

Join us in this webinar and learn what PowerPivot is, how to activate and how to conduct powerful business intelligence (BI) in an environment that is familiar.

NB: PowerPivot is built in to Excel since Office 2013. We will be demonstrating using Excel 365 ProPlus but the content will be relevant to users of earlier versions.


At the end of this webinar you will be familiar with:

  • What is PowerPivot?
  • Activating the PowerPivot
  • The PowerPivot tab
  • The PowerPivot managed window
  • Adding data to the data model from various sources
  • Add data by using copy and paste
  • Create relationships between tables
  • Create a PivotTable from PowerPivot data
  • Add slicers to PivotTables


20 June 2019


This webinar is designed for Financial Controllers, Business Analysts, Business professionals, Administration support, Business owners and anyone who requires to do data analysis and data modeling in Excel.

Attendees must be familiar with Excel and PivotTables.


Michael Blignaut, Senior IT Trainer, Auldhouse

1.25 CPD Hours

Coming Soon

All Coming Soon >>


Our webinars operate on a 'one-connection-one-fee' basis, so you can have your whole team participate together in a boardroom setting for one cost effective price, using one registered log-in connection. The registered attendee will receive a CPD certificate.


Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! Recordings are provided for webinars with a duration of 3 hours and less.