Interactive Visual Dashboard Reporting and Analysis with Microsoft Excel

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.

1. Lesson 1: What is Visual Reporting 2. Lesson 2: Identifying the Right Charts in Visual Reporting 3. Lesson 3: Form Controls 4. Lesson 4: Conditional Formatting 5. Lesson 5: Applying Functions in Visual Reporting 6. Lesson 6: Evaluating Case Studies