Excel Dashboard Course

Are You Ready to Take Your Career to the Next Level?

Excel Dashboards are the new buzzword employers are looking for.

If you want a career that involves creating reports in Excel, then you need to know Dashboards to keep your skills up to date.

In this dashboard course I’ll teach you how to create reports like the one below that will wow your prospective employer with impressive interactive and easy to read dashboards even if you don’t have an artistic bone in your body.


Excel Dashboard Example

There are 3 dashboards you can download and keep, and I set you a homework project where you create your own dashboard so that you’ll have the confidence to apply for that role you’ve been dreaming of.

So, what is an Excel Dashboard?

An Excel Dashboard is simply a report like the one above that:

  • Usually fits on one page
  • Displays key trends, comparisons and data graphically or in small tables
  • Provides the reader with conclusions to their objective
  • Is often interactive allowing the user to filter data and switch views themselves
  • Employs best practices that enable the report to be updated quickly and easily (often at the click of just one button)

Dashboards can be complex or simple, fancy or plain. They can contain financial or non-financial data, or both. They can work with any data in any organisation.

This comprehensive Excel Dashboard Course will teach you the simple techniques you can apply in Excel to make killer dashboards that will set your skill level apart from the crowd.


What You Get in the Course

  • Nearly 4 hours of video tutorials specifically on Dashboards plus another 3 hours of related Excel training that will fill in any gaps in your Excel knowledge on topics like PivotTables, Lookup Functions, Macros and more.

  • The pace is pretty fast because I hate courses that waffle on. I like to get straight to the point so you’re up to speed fast, and I’ve designed it so that if you need to re-watch anything you can rewind and replay the videos as many times as you like, or just refer to the instructions in the workbooks.

  • You can download the actual Excel files used in the filming.
    • These files contain step by step instructions so you can either use them on their own instead of the videos (these are great if you like to skim read like I do),
    • use them to practice what you learn and build your confidence,
    • or keep them forever as a reference tool that you can go back to later on to refresh your memory (let’s be honest, we never remember everything the first time we see it).

  • 3 x sample Excel dashboard reports that you can steal ideas from and reverse engineer.

  • Homework Challenge. Practice what you learn so that you don’t forget it. Plus you’ll be creating a work of your own that you can use for job interviews to showcase your skills. You can even send it to me and I’ll review it and give you feedback (optional).

  • An index of the course topics and terminology that are covered so you can easily find a tutorial you want to watch again.

  • 6 weeks of support from me. Each session has a comments section where you can post a question and I’ll post you an answer. These Q&A’s will be available for everyone in the class to learn from too (you can even post the answer to your classmate’s questions if you know it), making it a truly interactive class.

  • The training is delivered online and tutorials are available to watch 24/7 at your own pace. Pause, rewind, replay as many times as you like.

  • 12 months access to the video tutorials and file downloads. There’s even a download option where you can download all videos in the course and keep them on your own PC forever.

  • Check out the syllabus

Watch a Sample Tutorial from the Course

Behind The Scenes Video of the Course

Who Is It For?

The course is for you if you:

  • Are about to change career or apply for a new job;
  • Already prepare reports of any kind that require updating with new data on a regular basis (weekly, monthly….) and, or;
  • Work with charts and, or;
  • Work with large volumes of data and, or;
  • Import data into Excel from another source e.g. another database, Access, Web, Text files etc. and, or;
  • Often don’t know the best chart to use to display your data.
Note: This course is not for complete beginners but if you’ve put together any type of report in Excel before then you will definitely benefit from the time saving tips and data visualisation techniques I share with you.

What It Will Do For You

In the course I teach you how to build Excel Dashboard reports from the ground up.

By applying the simple rules I share with you, you will have the skills to be able to create reports that save loads of time (allowing you to go home early :) ) and you’ll quickly become known as a Dashboard Superhero with reports that are:

  • Quick and easy to update, in fact they can update themselves (imagine being able to confidently say that in an interview) by pulling in data direct from your external database, Microsoft Access, the web etc. at the click of a button if you set them up right (I show you how),

  • Fully interactive so the reader can change the view themselves; they can filter by product, time period or any parameter you choose, they can show and hide data using check boxes, drop down lists, and option buttons to name a few.

  • Your reports will be easy to read and interpret; plus I share with you a heat map of your page that shows you where your most important data should go and where will get the least attention.

  • Exactly what the reader wants; I teach you the 5 key questions to ask and to who in the planning stage of your report so you get it right first time.

  • Choose the right chart for your data; I teach you over 20 charts and show you which type of chart will best display your data.

    Just take a look at the two charts below. Both plot the same data but one is much easier to make comparisons in the data than the other. You be the judge.

    excel pie chart


  • Professional presentation. I teach you simple visualisation techniques so your reports will look like you’ve had a graphic designer involved even if you are completely lacking in artistic talent (like me).
  • In 6 weeks time I’ll send you a ‘Certificate of Completion’ saying you’ve completed the course which you can add to your resume/CV arsenal

It’s Tried and Tested

Before launching this course I had some of my trusted advisors test the course for me. They come from varied industries and ability levels.

One of them didn’t know what a Dashboard was before taking the course and another is an Excel trainer.

They’ve given me feedback on some improvements which I’ve implemented, but overall their feedback was resoundingly positive.

I am forever grateful for their time and kind comments. Thank you, you know who you are.

Here are just a few of their comments:

“The design is excellent, easy to follow, examples clear. “

“I like the materials available for download, so your users can work on their own. “

“The pace of the course is perfect. “

“Your use of terminology makes learning a new language painless.”

“I especially liked Section 3 on design principles. I have always believed in data quality but data organization and presentation is so very important to communicating ideas and information. “

“I found them (the tutorials) very complete and packed with good tips and tools for presenting data.”


Feedback From Past Students

“I’m enjoying the course and learning a lot. I appreciate your straight-forward style and getting right to the point.

The way you made charts dynamic by making them dependent upon the true or false contents of one cell blew me away. That is so simple yet is something that I would never have stumbled upon by myself.”

Greg


“I enjoyed watching the videos and got a lot out of it.

I would recommed it to all Excel lovers who like to enhance their Excel skills by transforming data into visual interactive summaries.

There is a bunch of detailed videos from compiling your data to the end result and the videos on different types of charts are great.

Formulas, form controls, interactivity, automation, the course has it all to make you a true Excel dashboard hero.

I would highly recommend it to anyone planning on taking Excel to a higher level.

Mohammed Mustafa


“Each Video combined with the Excel Files are helpful to learn quickly and faster. And these videos have great tips on how to use little macros which can become so powerful while making dashboards.

Lots of functions like VLOOKUP, HLOOKUP, CHOOSE, INDIRECCT with check boxes, and listboxes etc. are a powerfull combination to represent the data more effectively without showing the original data.

And your support is also big factor to learn it quickly.

Neil Johnson


Choose Your Membership Level

Excel Dashboard Course 
$147
 
Excel Dashboard Course + Downloads 
$247
 
Excel Dashboard Course + Premium 
$217
 
Excel Dashboard Course + Downloads + Premium 
$297
 
Dashboard Videos 4 hrs
Download Dashboard Videos*
3 Sample Dashboard Files
6 Weeks Dashboard Support
Homework Project
Dashboard Course Index
Unlimited 24/7 access
Pause, rewind, replay
Download Files Used in Filming
Excel Course 10h 27min
Word Course 4h 46min
Outlook Course 6h 28min
102 Excel Tips & Tricks Videos
95 Word Tips & Tricks Videos
98 Outlook Tips & Tricks Videos
Access to new Microsoft Office Training
30 Day Money Back Guarantee
*Videos will be available for download after 30 days. Note: prices are +GST for Australian customers.

Love It or Get It Free Guarantee

Look. Who are we kidding? This course is being taught online …so it’s not like you have to send anything back if you’re not happy.

So here’s the deal.

Enrol now and take the course. I mean REALLY take the course. Download the workbooks, watch all the videos, ask me questions. Get as much out of it as you can.

Once you’re done, ask yourself, “was this worth it?”

If your answer isn’t a resounding YES, then let me know within 30 days and I’ll refund you, no questions. So you literally have nothing to lose.

Registration Closed

I’m sorry, you missed the last class. If you’d like to be notified when classes will begin again later in 2012 fill out your name and email below, and I’ll let you know when it’s available.

Got A Question?

Have you got a question about the course? Contact me here and I’ll get back to you asap.