Data Visualization in Excel: Charting, Dashboards, and Pivot Tables

The amount of data we use is increasing. Gone are the days of staring at endless tables of data. We now use charts and visualisations to tell the story in the data.

This four-week course by The Excel Club will teach you how to use Excel charts and visualisations. It also teaches you when and how to make them look great.

This course will begin by introducing Excel to charting basics, including inserting charts and working with different elements such as gridlines, labels, and axes.

After you have mastered the basics, you can start to explore common excel charts such as line charts, bar, column, and histograms. You'll learn about the different types of charts and how to best optimise them for data visualization.

There are many charts available, so most people will stick to the well-known, but there are many other options that can better represent your data.

Week three will cover the charts you may not see as often. You'll learn how to create bubble charts, waterfall charts or treemaps and what limitations each one may have when trying to convey your message.

You'll be guided through visualizations that aren’t charts in the final week. Learn how to use sparklines, boxplots, slicers, and timelines. Each has its pros and cons.

This course will end with you learning how to create an Excel dashboard. It takes less than 20 minutes to complete, including design, development, and organising data effectively.

You can see some of the steps in this course before you sign up.

Excel dashboards can be created to effectively present data

Dashboards can be used by all levels of an organisation to deliver value, track progress, KPIs and uncover insights. Organizations work with more data each day, so Excel skills are highly sought after.

This six-week course by The Excel Club will teach you how to create dashboards from scratch. After that, you'll be able to put this knowledge into action and create three interactive Excel Dashboards.

Start designing your dashboard

This course will walk you through Excel dashboard design from start to finish.

We'll start by talking about the three types and then move on to the basics of creating them. Learn the best tips and tricks for creating dashboards, as well as the mistakes you should avoid in order to make your dashboards function effectively.

How to automate your interactive dashboard

This course will guide you through the steps of creating dashboards.

Once you have mastered the steps, you will be able to automate charts using named ranges. You'll also learn how to link the data, use the offset function and then link charts to names. The INDEX function will be used on subsets.

To easily modify your charts, use VLookup or form controls

This course will show you how to modify charts with different tools before you start creating your dashboards. This course will cover how to set up data validation, change the charts using VLookup, and how to add form controls to modify charts.

The final week of the course will see you create three dashboards with your own data and goals.

Pivot tables make it easy to summarise and quickly analyse large amounts of data. This data can be used to create interactive and informative dashboards by using Excel visualisations and pivot tables.

This three-week course by The Excel Club will teach you the basics of pivot tables. You'll also learn how to use them to create dashboards that can track trends and reveal valuable insights.

This course will teach you the basics of pivot tables and show you how to insert them. You can use pivot tables in many ways. This course will help you to learn how to add filters, work with dates and calculate using pivot tables.

You'll be looking at examples of data that you can use to analyse the data. This will cement your knowledge of pivot tables.

After you master the basics, you will learn advanced formatting techniques for pivot tables and some tricks that you can apply to them.

You'll continue to build on your charting skills in the previous courses. In this course, you will explore pivot charts and how they can be used to visually display data from pivot tables.

Pivot table dashboards can be a great way of presenting and providing unique perspectives on large amounts of data.

This course will walk you through all the steps required to create a pivot dashboard in just 20 minutes. This course will cover everything, from setting up pivot tables and creating charts to formatting your dashboard and using slicers and timelines.

You can see some of the steps in this course before you sign up.