Office Series 2018 - Microsoft Excel - Introduction to PowerPivot - 30 May 2018 (On Demand)

Description

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 a free add-in with Excel 2010 and is built in to Excel 2013 and 2016. We will be demonstrating using Excel 2016 but the content will be relevant to users of earlier versions.

LEARNING OUTCOMES

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

  • What is PowerPivot?
  • Activating the PowerPivot add-in
  • PowerPivot Tab
  • The PowerPivot Managed Window
  • Add Data to the data model from various sources 
  • Add Data by Using a Custom Query
  • Add Data by Using Copy and Paste
  • Create Relationships between Tables
  • Create a PivotTable from PowerPivot Data
  • Add Slicers to PivotTables

DATE OF ORIGINAL BROADCAST

30 May 2018

SUITED TO

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.

PRESENTER

Michael Blignaut, Senior IT Trainer, Auldhouse

1.25 CPD Hours

  • On Demand Event
    Complete online in your own time (Self-paced)
    • $180.00 excl. GST

Coming Soon

All Coming Soon >>

One-connection-one-fee

Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.

Recordings

All registrants that do not log into the live webinar are automatically sent a recording either later the same day or early the next business day.

If you did log in and wish to view again simply drop us a line at NZ‑learning@wolterskluwer.com and we’ll be happy to send it to you via email.

Sole practitioners

A discount on webinars is available for sole practitioners. Please contact us at NZ‑learning@wolterskluwer.com to confirm eligibility.