Discover a wider array of Excel functions to analyse data. This course will give you an overview of basic and advanced features of Excel's PivotTable tool which can rearrange and summarise huge data sets without using complex formulas. You will also explore PowerPivot, one of Excel's most popular Power Tools, which enables data analysis across multiple tables or data sets, from different data sources.
CPD: 1 hours
Paula Guilfoyle is a member of the Institute of Certified Public Accountants in Ireland. She practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals. Paula has given many talks and presentations in the areas of Excel, spreadsheet use, PowerBI and business intelligence, and has published many articles on the same subjects.
This course is free