Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. Dashboards can be created to summarize important information and are excellent for sharing a “snapshot” view among teams.
Master the Creation of Interactive Excel Dashboards and Learn to Build and Distribute Dashboard Reports From the Ground up.
Impressive Content that Will Provide Insight, Analysis and Alerts
- Advanced Features
- Design and Display Principles
- Interactive Controls
- Analyzing Data
- Automating your Dashboard
Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more. In order to learn Excel Dashboard students should have access to Excel 2007 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel as well. Pivot Table and Pivot Chart knowledge is helpful, but expertise is not necessary to take this course. Contents and Overview
This course includes 107 lectures and over 11 hours of content in order to give students a working knowledge of utilizing Excel Dashboard visuals to communicate their data. The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep information informative and relevant, analyzing and automating information for a fully functional and complete dashboard. It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks. Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets. Students will be able to choose the right chart for their data, write easy to interpret reports, know which areas of the dashboard will get the most attention, animate charts using VBA, create interactive reports (so users can change views and filter information), among a host of other abilities taught in this course.