This recorded webinar will connect PowerPivot to an external data source, devise formula and build reports.
Overview
This recorded webinar will connect PowerPivot to an external data source, devise formula and build reports.
Using a practical exercise for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Connecting PowerPivot to an external data source e.g. Microsoft Access
- Summarising and aggregating data with DAX functions – RELATED, CALCULATE, DIVIDE, SUMX
- Utilising disconnected tables to generate a slicer to give results based on commission
- Introducing Time Intelligence functions to sort data by month to add value to 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
- Understand data modelling basics for building PowerPivot data models
- Connecting PowerPivot to external data sources
- Summarising and aggregating data with DAX functions
- Utilising disconnected tables for sophisticated analysis
- Introduce Time Intelligence functions
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.