Measure Your KPI's, Stay On Track
No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, flexibility, and the fact that most people have it installed on their computer.
This training focuses on what you need to know to create an interactive professional-looking dashboard using Excel. You'll learn how to make maintenance-free dashboards when new data becomes available, and create the Pivot Tables needed to drive this dashboard. You will also learn how to create great looking visuals to assist top management in decision making. Join this 90-minute training to discover how you can add interactivity using slicers, automate elements of the dashboard with a macro and protect the cells containing critical formulas.
Mike Thomas has over 25 years experience designing and delivering face-to-face and virtual training courses. He has authored nearly 200 written and video-based Excel tutorials. He also develops Microsoft Office solutions to automate key business tasks and processes.
Your Learning Includes