Data Visualisation: Charting, Dashboards, and Pivot Tables

Course Cover
compare button icon

Course Features

icon

Duration

12 weeks

icon

Delivery Method

Online

icon

Available on

Lifetime Access

icon

Accessibility

Mobile, Desktop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Effort

2 hours per week

icon

Teaching Type

Self Paced

Course Description

Excel is a powerful tool for creating dashboards and charts, but many people don't get beyond the basics.

This ExpertTrack is offered by The Excel Club and will teach you how to use different Excel charts and dashboards to analyze and present data efficiently.

This course will begin by introducing Excel to charting basics and showing you how to insert charts. Then, you'll dive deep into creating the most common charts like line charts, pies charts and columns. Finally, you'll finish the course by learning how to create less-used charts.

More organisations are looking for people who can create meaningful dashboards to help them grow in this data-driven age.

After you have mastered the basics, you can create non-standard visual charts and data visualizations. This includes the creation and design of dashboards that present your data in an organized and automated manner.

This ExpertTrack's final course will cover advanced functions and formulas that can be used to interact with your data, including pivot tables and charts.

This course will prepare you to create a dashboard from scratch.

Over 150000 Excel students from 186 countries have been taught by The Excel Club over the past 10 years. This club is uniquely placed to help you improve your Excel skills, allowing you to become an expert in charts and data visualisation.

Course Overview

projects-img

Alumni Network

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

This is an introductory course in charting and data visualisation, so you must be able to find your way around Excel and do basic calculations to get the most out of this ExpertTrack

To benefit from this ExpertTrack, you need to have a basic knowledge of Microsoft Excel and a working copy or subscription to the software

What You Will Learn

Advanced Excel formulas for charting

Advanced charting techniques

Dashboard design and creation

Data visualisation

Excel charts

Non-standard data visualisation

Pivot tables

Target Students

It will be especially useful if you handle data on a regular basis and would like to be able to analyse and present it more effectively

This ExpertTrack is designed for anyone looking to take their Excel skills to the next level

Course Instructors

Author Image

Paula Guilfoyle

Instructor

Paula Guilfoyle is a CPA accountant with a passion for Excel. Teaching Excel for over ten years now, Paula also blogs and makes Youtube videos on all things Excel and Power BI.
Course Cover