Welcome to our Excel guide on how to construct interactive charts and dashboards.Usually, students of Excel thinks that only the formulas and syntaxes are the most important aspects of learning Excel.
But, tell you what, presenting those data are equally important.
The users of your crunched numbers will most likely don’t have time to dig deep into your excel file.
They want it simple, they want it fast.
And you can accomplish what they want through the use of charts. Good charts are pleasing to the eyes and are easy to understand.
Before you start the course, please note that we are using Excel 2013. Some tactics might still work for earlier versions, but, you can get the most of this course if you are using Excel 2013.
You will be given different scenarios and your target chart for each scenario. You will have to follow the steps in order to achieve your target chart.
Please download our Excel Chart Guide A and B. These contains the raw data and the solutions to our exercises.