Excel is an amazing tool for charting and dashboard creation, yet many never get beyond the basics of standard charting.

On this ExpertTrack from The Excel Club, you’ll gain the skills and tools to utilise different Excel charts and dashboards to analyse and present data effectively.

Discover the fundamentals of Excel charting

You will start this course by looking at the basics of charting in Excel, exploring ways to insert charts and formatting options. After this, you will take a deep dive into creating the most commonly used charts such as line charts, pies charts, and column charts before finishing the basics by looking at less common charts.

Create dynamic and automated dashboards in Excel

In this age of data, more and more organisations are seeking those with the skills to develop meaningful dashboards that help drive the business forward.

Once you’ve mastered the basics, you will learn how to create dynamic, non-standard, visually effective charts and data visualisations. This will include the design and creation of dashboards to present your data in an organised and automated format.

Use pivot tables to visualise data effectively

On the final course of this ExpertTrack, you’ll cover advanced use functions and formulas to drive interaction with your data, including pivot tables and pivot charts.

By the end of this course, you will be comfortable taking on a dashboard project from scratch; setting up the data, formatting the charts, and feeding everything into an effective dashboard.

Learn with the experts from The Excel Club

Having taught Excel to over 150,000 students across 186 different countries over the past decade, The Excel Club is uniquely positioned to develop your Excel skills, building your knowledge from beginner to advanced when it comes to charts and data visualisation.