Learn how to connect your enterprise databases, analyse data, create advanced reports and prepare dashboards using Microsoft Excel Power Pivot.
- Introduction to Power Pivot
- Setting up Power Pivot
- Loading, linking ad updating data
- Power Pivot formulas and Data Analysis Expressions (DAX)
- Power Pivot reports
- Set up Power Pivot
- Loading, linking and updating data
- Create a Power Pivot report
- Create Power Pivot formulas and Data Analysis Expressions (DAX)
- Work through the detailed tasks accompanying the webinar to test your knowledge
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.