Data Analysis With Excel
As a finance professional you use Excel to analyse data, but how often do you overlook Excel's useful features? This course explores some basic and more advanced features of Excel's PivotTable tool, covering Power Pivot and DAX (Data Analysis Expressions) formulas.
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.
Look inside
Contents
How it works
Author
Alan Murray
Alan has over 20 years’ experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.
