Video description
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.
Table of contents
- Course Introduction
- Deciding On Dashboards
- Preparing The Data
-
Building Dashboards
- Building Dashboards
- Dashboard Design Rules
- Managing Branding With Custom Themes
- Creating The Navigation Bar - Part 1
- Creating The Navigation Bar - Part 2
- Creating The Navigation Bar - Part 3
- What Is In A Word?
- Building Out Worksheets And Navigation
- Summarizing Data Using Groups
- Configuring Show Values As For Pivot Tables
- Assigning Categories Using Nested If
- Identifying Top Ten Values
- Finding The Last Value In A Series
-
Getting Visual
- Getting Visual
- Customizing Display With Text-Based Elements
- Alerting With Conditional Formatting
- Chart And Sparkline Review
- Creating Sparklines For Dashboards
- Creating Charts For Dashboards
- Using A Waffle Chart To Show Progress
- Using The Excel Camera
- Creating A Distribution Histogram
- Hitting The Mark With Bullet Graphs
-
Adding Interactivity
- Adding Interactivity
- Displaying The Developer Tab
- Understanding Interactive Dashboard Controls
- Adding Actions To Buttons
- Creating Custom Content With Combo Boxes
- Simplifying With Check Boxes
- Facilitating Filtering With Slicers And Timelines
- Finalizing By Color-Coding, Hiding And Protecting Worksheets
- Generating Dashboards As Output
- Conclusion
Product information
- Title: Microsoft Excel - Creating Dynamic Dashboards
- Author(s):
- Release date: November 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771373227
You might also like
video
Microsoft Excel: A Beginners' Guide to Pivot Tables in Excel
We need to analyze data these days since we live in a very data-driven world. Therefore, …
video
Microsoft Excel Beginners 2019
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who …
video
Microsoft Excel - Pivot Tables In-Depth
In this Microsoft Excel – Pivot Tables training course, expert author Erin Olsen teaches you everything …
book
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel …