In this Microsoft Excel - Creating Dynamic Dashboards training course, expert author Erin Olsen teaches you how to use Excel features and techniques to create dynamic dashboards in order to present complex data. This course is designed for users that already have a basic working knowledge of Excel.
You will start by learning how to prepare the data, then jump into building the dashboard. Throughout the course, you will be working to create a dashboard that provides a summary of a person's health information. Erin will teach you how to optimize Excel data for use in dashboards, create visual dashboard components, and add interactivity to customize them for each user. This video tutorial also covers how to create a distribution histogram, use a waffle chart to show progress, and add actions to buttons. Finally, you will learn how to generate dashboards as output, produce them as a PDF, and present them with PowerPoint or share via OneDrive.
Once you have completed this computer based training course, you will have gained the knowledge and skills necessary to create your own dynamic dashboards in Excel. Working files are included, allowing you to follow along with the author throughout the lessons.