Data Analysis With Excel

As a finance professional you will use Excel to analyse data, but how often do you overlook Excel's useful features? You may be familiar with creating tables, and filtering and sorting data, but there may be ways to do so more effectively, or tools that can facilitate getting insight from your data.

This course looks at both basic and advanced features of Excel's PivotTable tool, which can be used to rearrange and summarise huge data sets without the need for complex formulas. As well as how to use slicers, timelines and PivotCharts, you will also explore Power Pivot, one of Excel's most popular Power Tools. Equipped with its own language, DAX (Data Analysis Expressions), Power Pivot enables you to analyse data across multiple tables or data sets from different sources.