Learn how to connect your enterprise databases, analyse data, create advanced reports and prepare dashboards using Microsoft Excel Power Pivot.
Overview
Learn how to connect your enterprise databases, analyse data, create advanced reports and prepare dashboards using Microsoft Excel Power Pivot.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Introduction to Power Pivot
- Setting up Power Pivot
- Loading, linking ad updating data
- Power Pivot formulas and Data Analysis Expressions (DAX)
- Power Pivot reports
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step by step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Create a Power Pivot report
- Create Power Pivot formulas and Data Analysis Expressions (DAX)
- Learn how to connect your enterprise databases, analyse data, create advanced reports and prepare dashboards using Excel Power Pivot.
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.