Business Analysis with Excel Part 3: PowerPivot, DAX and Excel

Description

Data is the future and learning how to analyse and make sense of large volumes of data is an essential skill for you professional development and future-proofing your skillset. 

Topics covered include:

• The PowerPivot interface
• PowerPivot v normal pivot
• Importing data into PowerPivot
• Create calculated columns using excel functions
• Create a relationship
• Using related tables in a Pivot
• Visualisations to create better excel dashboards

This session is suitable for people with an intermediate Excel level and above.

In this session we will build on what we learned in;

Session 1: Make Better Decisions Using Excel Pivot Tables

Session 2: Connecting Excel to the World of Data

Presenters Bio:

Paul Panebianco is a Chartered Accountant and the Director of Excel Consulting Solutions.

Having worked as a business analyst in the financial industry, Paul has an excellent understanding of the work carried out by accountants and finance professionals and knows exactly how to use Microsoft Excel for maximum impact in these areas.

You will be provided with: 

• PowerPoint presentation slide deck 
• Supporting documentation 
• Webinar Recording to view multiple times for up to 6 months 
• An opportunity to ask questions to the presenter

Taking your data analysis skills to next level!

  • Webinar Recording
    • PD hours: 1
    Stream this recording multiple times at your convenience.
    • $180.00 incl. 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

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! You can watch it as many times as you like for up to 6 months. You will also receive Supporting Documentation.