Introduction to Excel Charts for Data Visualisation

Build charts and dashboards to visualise your data efficiently

As the amount of data we use grows, gone are the days when you would stare at tables of endless data. Instead, we now use visualisations and charts to tell the story within the data.

On this four-week course from The Excel Club, you will learn to work with Excel charts and visualisations, when to use each one and how to make it look great.

Explore the basics of Excel charts

You’ll start this course by looking at the fundamentals of charting in Excel, from inserting charts to working with the different elements of charts such as axes, labels, and gridlines.

Once you have the basics, you’ll begin to explore the most common excel charts, including line charts, bar and column charts, and histograms. With each type of chart, you’ll delve into when you might use them and how best to optimise them for data visualisation.

Discover less common charts for data visualisation

With so many different charts to choose from, most people will stick with the more well-known ones, but there are so many options that can portray your data more effectively.

Week three of the course will take you through the charts that you don’t see as often. Whether it’s bubble charts, waterfall charts, or treemaps, you’ll cover how to create each type of chart as well as the limitations they may have in trying to showcase your message.

Learn how to visualise data without charts

The final week will guide you through visualisations that aren’t charts. You’ll discover how to work with boxplots, sparklines, and slicers and timelines, each with their own pros and cons.

To wrap up this course, you’ll learn how to create a basic Excel dashboard in 20 minutes, from design and development to organising the data efficiently.

This course has been designed for anyone looking to learn the basics of Excel charting and visualisation. These skills will help in any industry and role that works with data, helping you to present it effectively.

To take part in this course you will need a version of Excel. You can sign up for a 30 day trial directly with Microsoft get Excel 365

This course has been designed for anyone looking to learn the basics of Excel charting and visualisation. These skills will help in any industry and role that works with data, helping you to present it effectively.

• Design easy to read charts and data visualization
• Identify good and bad charts and data visualization
• Explain the principles of good data visualization
• Create common and less common Excel Charts
• Demonstrate and apply Excel chart formatting options
• Develop an Excel dashboard using visualizations
• Present data with visually effective charts