Excel Data Analysis & Reporting – Part 2 is the advanced follow-up to Part 1. This session focuses on analysing and reporting data using Excel’s powerful tools. You’ll learn how to use lookup functions, Pivot Tables, and database features to create dynamic reports and dashboards.

For those who want to take their Excel reporting to the next level. Ideal for anyone who works with complex datasets or needs to build robust, refreshable reports.

Completion of Excel Data Analysis & Reporting – Part 1 or equivalent experience.

By the end of this course, you’ll be able to:

• Build dynamic reports and dashboards
• Use advanced lookup and filtering techniques
• Create custom reports using database functions

Module 5: Calculating Columns in Power Query

• Using powerful and intuitive tools within the power query editor to add calculated columns to our data each time it is refreshed.

Module 6: Power Pivot and the Data Model

• Introduction to the Power Pivot and Excel Data Model - Did you know that Excel can be a relational database? Using the Excel Data Model you can connect to multiple sources of data and transform the data to make analysing and reporting more comprehensive.

Module 7: Pivot Tables and Pivot Charts

• Learning a systemic, step-by-step process to build Pivot Tables that answer important questions you have about your data.
• Visualising Data with Pivot Tables and Pivot Charts – Pull together your newly cleansed data into a beautiful Excel Dashboard or report in no time using Pivot Charts.