Data Analysis With Excel

This course will enable you to

• Create tables, filter, sort and extract data for efficient data analysis
• Set up a PivotTable and apply summaries and calculations
• Create and modify a PivotChart and use the GETPIVOTDATA function
• Analyse data across multiple tables or data sets from different data sources using Data Analysis Expressions (DAX) formulas

About the course

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.