Webinars > All COMPUTERS / SOFTWARE Categories > Office Software Webinars

Skillpath Seminars
SkillPath Seminars presents

Virtual Classroom (Live) Creating Visual Dashboards in Microsoft® Excel® Webinar

In this LIVE, virtual course you will learn how to create impressive visual dashboards using tables, charts, gauges, numbers and other interactive elements.

Course Description/Agenda


No matter what business you’re in, data-driven dashboards are crucial for drilling down into the insights that matter most to your organization. Microsoft® Excel® dashboards provide a simple solution for providing access to current, high-level data in one central location and for tracking key performance indicators in real time.

Sign up for this LIVE, virtual course and you’ll learn how to create impressive visual dashboards using tables, charts, gauges, numbers and other interactive elements. You’ll discover how to insert slicers to filter data…how to add graphic enhancements like pictograms and word art…and how to share your interactive dashboards with others.

WHAT YOU WILL LEARN

  • Provide high-level data to users in one central location
  • Track key performance indicators in real time
  • Design a dashboard from scratch
  • Enhance a dashboard with graphic elements
  • Use macros to make a dashboard interactive

WORKSHOP AGENDA

Program time: 3 hours

Session 1: Communicating Data Through Dashboards

  • Explain how Excel dashboards are used to visually analyze key metrics
  • Describe how Excel dashboards differ from standard worksheets
  • Know how to determine what information needs to be communicated
  • Plan a dashboard layout that visually displays large volumes of data

Session 2: Designing a Dashboard From Scratch

  • Understand how to structure your raw data using tables
  • Explain how to create a data staging area
  • Describe how to add slicers to filter data in the dashboard
  • Use form controls add interactivity

Session 3: Enhancing Your Dashboard

  • Add pictograms, word art and other graphic elements to a dashboard
  • Understand how to make a dashboard interactive using macros
  • Arrange the dashboard and make final adjustments so it’s fully functional
  • Share your interactive data with others

 

More Webinar Information

SkillPath Seminars
Skillpath Seminars

Course Summary

In this LIVE, virtual course you will learn how to create impressive visual dashboards using tables, charts, gauges, numbers and other interactive elements.

Delivery Method

Virtual Classroom (Live) Virtual Classroom (Live)

Who Should Attend

Excel users

 
Search similar training
Email this page
Print this document
 

Webinar Details

6/14/2021 - 6/14/2021
Tuition: $149

6/14/2021 - 6/14/2021
Tuition: $149

6/29/2021 - 6/29/2021
Tuition: $149

6/29/2021 - 6/29/2021
Tuition: $149

7/15/2021 - 7/15/2021
Tuition: $149

7/15/2021 - 7/15/2021
Tuition: $149

7/28/2021 - 7/28/2021
Tuition: $149

7/28/2021 - 7/28/2021
Tuition: $149

8/18/2021 - 8/18/2021
Tuition: $149

8/18/2021 - 8/18/2021
Tuition: $149

8/26/2021 - 8/26/2021
Tuition: $149

8/26/2021 - 8/26/2021
Tuition: $149

see all dates

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Select a date from the list at the bottom of the page for specific information about that class.

Other Information
Virtual Classroom (Live)

All Date/Location Information

6/14/2021-6/14/2021 at 9:00:00 AM CT
6/14/2021-6/14/2021 at 1:00:00 PM CT
6/29/2021-6/29/2021 at 9:00:00 AM CT
6/29/2021-6/29/2021 at 1:00:00 PM CT
7/15/2021-7/15/2021 at 9:00:00 AM CT
7/15/2021-7/15/2021 at 1:00:00 PM CT
7/28/2021-7/28/2021 at 9:00:00 AM CT
7/28/2021-7/28/2021 at 1:00:00 PM CT
8/18/2021-8/18/2021 at 9:00:00 AM CT
8/18/2021-8/18/2021 at 1:00:00 PM CT
8/26/2021-8/26/2021 at 9:00:00 AM CT
8/26/2021-8/26/2021 at 1:00:00 PM CT