Introduction to Excel Charts for Data Visualisation
Offered By: Excel Club via FutureLearn
Course Description
Overview
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
Syllabus
- Our first Excel charts
- Kickstarting this course
- Inserting and working with charts
- What is data visualization?
- Chart templates and line charts
- Weekly wrap up
- Common Excel charts
- Welcome back
- Some common Excel charts
- More common charts in Excel
- Weekly wrap up
- Less common charts in Excel
- Welcome to week 3
- More Excel charts
- Oh My! Even more charts
- Weekly wrap up
- Visualizations are not always charts
- Welcome to week 4
- Charts and visualizations
- Weekly wrap up
Taught by
Paula Guilfoyle
Related Courses
Introduction to Excel Charts for Data VisualisationFutureLearn Learn Data Visualization with Python
Codecademy Intro to Data Visualization with Python
Codecademy Visualize Data with Excel
Codecademy Data Visualization with R
IBM via Cognitive Class