Introduction to Excel Charts for Data Visualisation

4 weeks
2 hours per week
Accreditation available
Digital certificate when eligible
Open level

Find out more about how to join this course

This course has been certified by the CPD Certification Service as conforming to continuing professional development principles. Find out more.

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.

Unable to play video. Please enable JavaScript or consider upgrading your browser.

Skip to 0 minutes and 4 seconds Do you want to improve your excel reports and dashboards? In this growing world of data, excel charting, visualizations and dashboard design skills are in a high demand. This expert track has been created to help you skill up and become more efficient and effective when designing and creating excel reports and dashboards. In this expert track, you will learn the techniques used in excel to create and build effective, interactive dashboards to tell the story of your data. My name is Paula And I will be your instructor throughout this expert track. I’m a CPA accountant And I have been teaching excel now for over 10 years and I’m proud to say I’ve taught over a 120,000 students across 186 different countries.

Skip to 0 minutes and 56 seconds By the end of this expert track, you’ll be able to create stunning, dynamic, interactive visualizations in excel. and put this together into a well-designed dashboard. The dashboards we will create in this course will allow users make quick decisions driven by data that is easy to read and easy to understand. You will learn how to create and to work with charts in excel including formatting basic charts and less common charts. You will know what charts to use and when. You’ll be shown the techniques used to create custom charts and you will be given the skills needed to create interactive dynamic dashboards.

Skip to 1 minute and 41 seconds Throughout this course we will also explore some design basics and we will look at good and bad charts along with good and bad dashboards. Using excel functions, formulas, pivot tables, and other features, this course has been designed to take you from a beginner at excel data visualization to a level where you’re comfortable creating and designing dashboards that are both informative and impressive. And we’ll do this over the expert track in 3 courses. Being skills that are in high demand right now, this expert track is in line with current industry needs. So if you’re looking to improve your reporting charts and to become more efficient in creating excel dashboads then this expert track has been designed for you.

Skip to 2 minutes and 30 seconds So, why don’t you sign up now? And I’ll see you in the first course soon. [END]

What topics will you cover?

Inserting charts in Excel
Formatting Excel Charts
Working with common Excel charts
Working with less common Excel charts
Charting Fundamentals

Who is this accredited by?

The CPD Certification Service:

The CPD Certification Service was established in 1996 and is the leading independent CPD accreditation institution operating across industry sectors to complement the CPD policies of professional and academic bodies.

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

Available now

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

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

Who is the course for?

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.

What software or tools do you need?

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

Who developed the course?

The Excel Club

The Excel Club is a global leader in Excel and Power BI training. With over 100K students from across 186 different countries, The Excel Club has grown from strength to strength.

The force behind The Excel Club is by Paula Guilfoyle. Paula is a Certified Public Accountant and Microsoft Excel MVP who has worked across a broad range of industries as an Accountant, Internal Auditor and Financial Controller.


Ways to learn	Buy this course	Subscribe & save	Limited access
Choose the best way to learn for you!	$134/one-off payment	$244.99 for a whole year Automatically renews	Free
	Fulfill your current learning need	Develop skills to further your career	Sample the course materials
Access to this course	tick	tick	Access expires 11 Nov 2024
Access to 1,000+ courses	cross	tick	cross
Learn at your own pace	tick	tick	cross
Discuss your learning in comments	tick	tick	tick
Certificate when you're eligible	Printed and digital	Digital only	cross
	Continue & Upgrade
		Cancel for free anytime

Ways to learn

Choose the best way to learn for you!

Subscribe & save

$244.99 for a whole year

Automatically renews

Develop skills to further your career

Access to this course
Access to 1,000+ courses
Learn at your own pace
Discuss your learning in comments
Digital certificate when you're eligible

Cancel for free anytime

Buy this course

$134/one-off payment

Fulfill your current learning need

Access to this course
Learn at your own pace
Discuss your learning in comments
Printed and digital certificate when you’re eligible

Continue & Upgrade

Limited access

Free

Sample the course materials

Access expires 11 Nov 2024

Find out more about certificates, Unlimited or buying a course (Upgrades)

Sale price available until 31 October 2024 at 23:59 (UTC). T&Cs apply.

Find out more about certificates, Unlimited or buying a course (Upgrades)

Sale price available until 31 October 2024 at 23:59 (UTC). T&Cs apply.

Learning on FutureLearn

Your learning, your rules

Courses are split into weeks, activities, and steps to help you keep track of your learning
Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

Experience the power of social learning, and get inspired by an international network of learners
Share ideas with your peers and course educators on every step of the course
Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

As you work through the course, use notifications and the Progress page to guide your learning
Whenever you’re ready, mark each step as complete, you’re in control
Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn