Go back to Courses

Creating Vibrant Dashboards

  • On-Demand
Author: Ken Puls
This is the video portion of the "Creating Vibrant Dashboards" seminar with Ken Puls. In this course, we’ll look at different ways to present our information and tell a story using effective data visualization tools in Excel.
Course

Creating Vibrant Dashboards

$249 Renews at $29 per year
(All prices in USD)
This Course contains:
8 hours 30 minutes of training content
11 Content Modules
Downloadable files and Handouts
Certificate of completion
DURATION:
8 hours 30 minutes
TOOLS:
Excel
SKILLS:
Data Visualization

What you'll learn?

Building basic charts (line and bar)
Modifying chart elements
Creating combination charts
Building interactive charts
Advanced chart types
Conditional formatting tools and tricks
Custom number formatting techniques
Putting them all together in a dashboard

Course Overview

Course Description

How many times, after presenting the statements you’ve worked so hard on, do your audiences’ eyes glaze over? It’s awful, but it highlights something really important: often the way we present our work isn’t ideal.

This seminar will focus on strategies and tools that can be used to summarize key business metrics for presentation. We’ll look at different ways to present our information, telling a story using effective data visualization tools in Excel. We’ll examine charts, graphs, conditional formatting and other techniques, pulling the results into a dynamic and engaging dashboard. Together we’ll build a one-stop report that gives us an overview of the key metrics we want to see for a hypothetical business need.

A Note on Access

Your registration in the seminar comes with a free 3-month trial subscription to this video course. After the free trial period, you can choose to continue your access for $29 USD/year.

Who this course is for?

  • Accountants and other professionals who need to be able to share information visually and engage their audience.
  • Registrants should have fundamental knowledge of Excel.

Course Formats

On-Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and Q&A tests to validate your knowledge.

Course Content

Platform Introduction
3 Lessons
Course Introduction
Course Examples
Who’s Ken
Data Visualization Introduction
3 Lessons
Data Visualization Overview
Dashboarding
A Word on Colour
Conditional Formatting
5 Lessons
Conditional Formatting Overview
Colour Scales
Data Bars
Icon Sets
Highlighting Cells
Cell Based Visualizations
3 Lessons
Sparklines
Formula Based Charting
Custom Number Formats
Introduction to Effective Charting
2 Lessons
Chart Types
Five Rules of Effective Charting
Building Charts
7 Lessons
Pie Charts
Bar Charts
Column Charts
Line Charts
Combination Charts
Bullet Charts
Waterfall Charts
Adding Interactivity
2 Lessons
Method Overview
Interactive Pictures
Infographics
1 Lesson
Infographics
Sample Dashboards
5 Lessons
Pulling it all Together
Golf Restaurant Dashboard
Payroll Dashboard
Inventory Dashboard
Charity Resource Dashboard
Help Resources
4 Lessons
Free Help Forums
M is for (Data) Monkey
Power Query Academy
Free Newsletters

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQ

How do I access the course materials? Are they downloadable?
The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.
Where are the course videos hosted?
All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.
How do I receive my Certificate of Completion?
After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

Reviews

Creating Vibrant Dashboards

0
(0 Review)
5
4
3
2
1

Reviews

There are no reviews yet.

Only verified customers who have purchased this product may leave a review.