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