About the Course
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 how to create impressive, interactive, and easy to read Dashboards
This course will get your skills up to date by teaching you how to create Dashboards that will wow your boss (or your prospective employer) even if you don’t have an artistic bone in your body.
Topics CoveredSo, 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 organization.
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.
Who should attendThe course is for you if you:
Want 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.
Pre-requisitesThis 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 visualization techniques I share with you.
What you need to bringOffline - Your Laptop
Online - Your Laptop / High speed Broadband Internet
Key TakeawaysIn 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.
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.