Data and analytics
Data analysis for accountants: getting started
CPD Courses, 1 July 2019
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 your data, but what more could you be doing to get more 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 efficiently, negating the need for complex formulas. You will also explore PowerPivot, one of Excel's most popular Power Tools. Equipped with its own language, Power Pivot enables you to analyse data across multiple tables or data sets, from different data sources.