Interactive Visual Dashboard Reporting And Analysis With Microsoft Excel

Data Visualisation is increasingly becoming an essential need in enhancing business decisions. This course brings users to the forefront on the technology of data visual display to enhance reporting, analysis and performance management.

With visual analytics, users can spot business issues and problems needing attention at a glance and take action on a timely manner. Microsoft Excel is an ideal tool in putting all these data together, making meaning out of it and displaying the analysis easily in an interactive dashboard form.

Using case studies as a framework, this course will enable users to create appropriate, informative, easy to understand and interactive visual dashboards.

• Step 1: Understanding the concepts of creating dashboards and visual displays
• Step 2: Identifying the essential techniques and methods of visual reporting
• Step 3: Integrating all the critical components in data analysis by using the relevant functions and formulas
• Step 4: Applying the creative combinations of dashboard charting techniques and design in analysis of data.

Who Should Attend

This course is relevant to data analysts, managers in Sales, Human Resources, Finance who need to analyse, design and present meaningful dashboards. Participants are required to have the knowledge of Excel Functions prior to attending this course.

In this training you will learn:

• What is Visual Reporting
• Identifying the Right Charts in Visual Reporting
• Form Controls
• Conditional Formatting
• Applying Functions in Visual Reporting
• Evaluating Case Studies