Online ExpertTrack in Business & Management

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

From Excel charts to effective dashboards, develop the skills to aid business decisions, track KPIs, and reveal data insights.

Created by

The Excel ClubThe Excel Club

Learn more

Master Excel charting and dashboard creation

Excel is an amazing tool for charting and dashboard creation, yet many never get beyond the basics of standard charting.

On this ExpertTrack from The Excel Club, you’ll gain the skills and tools to utilise different Excel charts and dashboards to analyse and present data effectively.

Discover the fundamentals of Excel charting

You will start this course by looking at the basics of charting in Excel, exploring ways to insert charts and formatting options. After this, you will take a deep dive into creating the most commonly used charts such as line charts, pies charts, and column charts before finishing the basics by looking at less common charts.

Create dynamic and automated dashboards in Excel

In this age of data, more and more organisations are seeking those with the skills to develop meaningful dashboards that help drive the business forward.

Once you’ve mastered the basics, you will learn how to create dynamic, non-standard, visually effective charts and data visualisations. This will include the design and creation of dashboards to present your data in an organised and automated format.

Use pivot tables to visualise data effectively

On the final course of this ExpertTrack, you’ll cover advanced use functions and formulas to drive interaction with your data, including pivot tables and pivot charts.

By the end of this course, you will be comfortable taking on a dashboard project from scratch; setting up the data, formatting the charts, and feeding everything into an effective dashboard.

Learn with the experts from The Excel Club

Having taught Excel to over 150,000 students across 186 different countries over the past decade, The Excel Club is uniquely positioned to develop your Excel skills, building your knowledge from beginner to advanced when it comes to charts and data visualisation.

Key skills you will learn

  • Excel charts
  • Data visualisation
  • Non-standard data visualisation
  • Advanced charting techniques
  • Dashboard design and creation
  • Advanced Excel formulas for charting
  • Pivot tables

Experience required

To benefit from this ExpertTrack, you need to have a basic knowledge of Microsoft Excel and a working copy or subscription to the software. 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.

Getting started

This ExpertTrack is designed for anyone looking to take their Excel skills to the next level. 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.

ExpertTrack course overview

  • Course 1

    Learn the basics of charting in Excel, from creating and formatting charts, to the pros and cons of each different type of chart.

    1 test

    4 weeks

    2 hours per week

    • Week 1

      Our first Excel charts
      • Kickstarting this course
      • Inserting and working with charts
      • What is data visualization?
      • Chart templates and line charts
      • Weekly wrap up
    • Week 2

      Common Excel charts
      • Welcome back
      • Some common Excel charts
      • More common charts in Excel
      • Weekly wrap up
    • Week 3

      Less common charts in Excel
      • Welcome to week 3
      • More Excel charts
      • Oh My! Even more charts
      • Weekly wrap up
    • Week 4

      Visualizations are not always charts
      • Welcome to week 4
      • Charts and visualizations
      • Weekly wrap up
  • Course 2

    Enhance your Excel charting skills and discover the tools and skills to create advanced and automated dashboards.

    1 test

    6 weeks

    2 hours per week

    • Week 1

      Getting started with dashboards
      • Kickstarting this course
      • Your first custom visual
      • Designing dashboards
      • Weekly wrap up
    • Week 2

      Down and dirty with custom visuals
      • Getting started with week 2
      • Basic to advanced Waterfall charts
      • Dashboards in Excel
      • Excel Gauge Charts
      • Weekly wrap up
    • Week 3

      Lets start to get more dynamic
      • Getting started with week 3
      • Actual V's Budget
      • It's dynamic!
      • Good and bad dashboards
      • Keeping it dynamic and interactive
      • Weekly wrap up
    • Week 4

      What's in a name?
      • Getting started with week 4
      • Automating charts with named ranges
      • INDEX function in action
      • Weekly wrap up
    • Week 5

      Changing charts
      • Getting started with week 5
      • Dropdowns, loookups and named ranges
      • Form Controls
      • Cards
      • Weekly wrap up
    • Week 6

      Putting it all together
      • Getting started with week 6
      • Your first dashboard
      • The second dashboard
      • The third dashboard
      • Weekly wrap up
  • Course 3

    Build and improve your data analysis skills by learning how to utilise pivot tables, charts, and dashboards in Excel.

    1 test

    2 weeks

    2 hours per week

    • Week 1

      The Basics of Pivot Tables
      • Kickstarting this course
      • An Introduction to Pivot Tables
      • More on Pivot tables and Pivot Charts
      • Weekly wrap up
    • Week 2

      Pivot Table Dashboards
      • Getting started with week 2
      • Pivot Dashboard in 20 minutes
      • GETPIVOTDATA
      • Weekly wrap up

Prove you're job ready

Highlight the new, job-relevant skills you’ve gained and supplement existing qualifications with a hard-earned, industry-specific digital certificate – plus one for every course within your ExpertTrack.

  • Learn the latest in your chosen industry or subject.
  • Complete each course and pass assessments.
  • Receive certificates validated by the educating organisation.
  • Impress employers with learning outcomes you can add to your CV.
  • Make your career dreams a reality.

Download a PDF

How ExpertTracks work

Join an ExpertTrack to master new skills in your chosen specialist area. Work through a series of topic-focused courses at your own pace, and pass the final assessment to earn a digital certificate award which proves your expertise.

Join a free 7-day trial

Decide if the ExpertTrack is right for you with free access to the full suite of courses and assessments for a week.

Keep learning for $39/month

Pay a monthly subscription fee of $39 for as long as it takes you to complete the ExpertTrack. You can learn at your own pace and cancel at any time.

Earn digital certificates

Receive a certificate for every completed course and pass the final assessment to earn a digital certificate.

Become an expert

Use your specialist training to progress further in your career or build expertise in areas you’re passionate about.

World-class learning with 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.

Meet your 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.

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps, but you can complete them as quickly or slowly as you like
  • 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

What are our learners saying?

Add a new skill or forge a new path

"I recommend Futurelearn to anyone looking to learn and upskill...If you are in the job market, you might want to add a new skill or forge a new path."

They bring the classroom right to you

"FutureLearn courses are always interesting and informative. They bring the classroom right to you and send you on a journey to explore new ideas and offer interesting topics."

Start learning today - free 7-day trial

After your free trial you can:

  • Pay $39 per month to keep learning online
  • Have complete control over your subscription; you can cancel any time
  • Work at your own pace and set your own deadlines at every stage
  • Only pay while you’re learning; the subscription will cancel automatically when you finish
  • Complete online assessments to test your knowledge and prove your skills
  • Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
  • Keep access to the content of courses you complete even after your subscription ends

FAQ

ExpertTracks are a series of online courses designed to help you master new skills in specialist areas. You pay a monthly subscription fee which includes access to all courses within the ExpertTrack, as well as assessments and the final digital certificate.

Each ExpertTrack comes with a 7-day free trial period. You may cancel your subscription at any time and your subscription will automatically cancel when you finish the courses and assessments in your chosen ExpertTrack.

Yes. All of our ExpertTracks come with a 7-day free trial. You may claim one free trial period per ExpertTrack.

You have seven days before you will be charged your first monthly subscription fee. When you join an ExpertTrack you automatically receive a 7-day free trial period. You can cancel at any time during the trial period and no payment will be taken from your account.

Please see our full refund policy here.

No, all of our ExpertTracks consist of fully online courses. This means you can take an ExpertTrack from anywhere in the world.

No. ExpertTracks are designed for you to master new skills in a specialist area. You will earn a digital certificate that proves your learning, but it does not carry accreditation.

If you’re looking for certified or accredited courses, many of our microcredentials offer university credit or professional certification.

Have more questions about ExpertTracks? Read the ExpertTracks FAQs, or contact us.