Data Analysis & Dashboard Reporting

Microsoft Excel is one of the most powerful and popular data analysis desktop application in the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you will gain the widely sought after skills necessary to effectively analyse large sets of data.

Once the data has been analysed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.

The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools. 

Including:

• VLOOKUP() Function for Looking up Information
• INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
• TEXT() Function for Formatting
• CHOOSE() for Ultimate Flexibility in Presenting Data
• Advanced Filtering
• Summarising Data with PivotTables and Pivot Charts
• Interactive Features to Create User Friendly Reports
• and more...

Course Objectives:

• Understand and identify the principles of data analysis
• Effectively summarise and present data clearly
• Use effective design principles when creating and presenting data
• Take full advantage of the built-in tools Microsoft Excel offers in order to analyse and build dashboard reports
• Build interactive dashboard reports
• Analyse Excel data using Excels TEXT based Functions