This course is an introduction to the more advanced features of spreadsheets and their use. By the end of this course, delegates should be comfortable with automating worksheet functionality, as well as using a variety of different analysis tools, data presentation and working effectively with multiple workbooks.
This course is designed to introduce existing users of Microsoft Excel to the Principles of Data Visualisation using Microsoft Excel Charts.
By the end of this course, delegates should be comfortable with applying Data Visualisation principles to create pleasing and informative Dashboards using Chart Options and Chart Design in Excel. You will gain an understanding of how to choose the best chart for your dataset and how your dashboard can tell a story to your audience. As a Consolidation Task at the end of the day, you will learn how to present your charts in an Excel Dashboard and export into PowerPoint based on the knowledge you have gained during the course.
Classroom / Virtual based;
Trainer led.Interactive with opportunity for questions and discussion.
People who have a good knowledge and understanding of MS Excel and who wish to learn some of the Visualisation features.
A working knowledge of Excel
No prior knowledge of creating charts is required
An understanding of the need to process your information visually
An understanding of the use of large datasets
On completion of the course candidates will receive: