0

Visual Communication Using Excel Dashboards

Visual Communication Using Excel Dashboards
Visual Communication Using Excel Dashboards

When

4/6/23 1:00 pm EDT
Our Customer Assurance Pledge
Visual Communication Using Excel Dashboards

If this webinar fails to meet your needs, we will refund 100% of your tuition – no hassles, no questions asked.

Live Webinar Only

$209.00
Per Attendee

Quantity

Recording Only

$219.00
Per Attendee

Quantity

Live Webinar + Recording

$279.00
Per Attendee

Quantity

     Sign up for Business Watch Network's Training Pass to get access to our entire training library!

Event Description

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.

  • "Mike Thomas (your Webinar facilitator) very clearly presented the creative ways in which data can be presented and managed."
    -- Desyra Highsmith, Director of Talent Management, William Paterson University.

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.

Customer Reviews Back To Top

 
 

Speaker Back To Top

Mike ThomasMike 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.

Topics Back To Top

Key Objectives

  1. Understanding dashboards by using Excel to gather and summarize the right data
  2. Reviewing how to maintain self-updating links to databases, spreadsheets, text files, and other data sources
  3. How to create dynamic and interactive graphs

What Comes with Your Purchase? Back To Top

Your Learning Includes

  • Downloadable sample workbooks and templates
  • Best practice for setting up data sources
  • Using Pivot Tables to summarize data
  • Visual communication using charts
  • Creating a rolling 30-day summary
  • Using formulas to create KPI summaries
  • Creating interactive filters with Slicers
  • Automating the dashboard with a simple macro
  • Using protection to prevent accidental changes

Bring Your Team – Group Package Pricing Back To Top

5 or More Attendees? Please view our group pricing registration page

View Group Package Pricing

 

 

Have more than 30 attendees? Issues during checkout? Or want to register your team directly with the help of a BusinessWatch Network Customer Representative? Please Reach Out To: support@bizwatchnetwork.com

Companies Who Trust Us Back To Top

Trusted Customer Logo

KEYWORDS armory , assist , automate , business , cells , commonly , communication , computer , create , creative , critical , dashboard , data , excel , learn , management , presented , tool , training
Back To Top