Online Instructor led Course
The 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.
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 visualization techniques I share with you.
Offline - Your Laptop
Online - Your Laptop / High speed Broadband Internet
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.
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.
Not decided yet
Microsoft Excel 2003 to 2013
Students Interested 0