• Packt logo
  • FutureLearn logo

Advanced Data Visualisation and Analysis in Excel

Explore advanced Excel topics as you develop the skills and knowledge to conduct data analysis and create stand-out visuals.

323 enrolled on this course

A man holds his glasses in front of a computer screen with a spreadsheet on it.

Advanced Data Visualisation and Analysis in Excel

323 enrolled on this course

  • 3 weeks

  • 3 hours per week

  • Digital certificate when eligible

  • Introductory level

Find out more about how to join this course

  • Duration

    3 weeks
  • Weekly study

    3 hours
  • 100% online

    How it works
  • Unlimited subscription

    $244.99 for a whole yearLearn more

Gain advanced Excel skills

This three-week course will help you develop advanced Microsoft Excel skills to improve your workflow in your job role or increase productivity in your personal life.

You’ll further your knowledge of Excel as you delve into advanced functions, Excel tables, and data analysis before completing a series of activities to cement your knowledge.

By the end of the course, you’ll know how to unlock Microsoft Excel’s full potential to use for complex data and to create stunning visuals.

Understand Excel lookup functions

You’ll start by exploring advanced functions such as date and time, finance, lookup, and logical functions.

With this knowledge, you’ll be able to retrieve information, perform data analysis, and carry out complex calculations with ease.

Explore Excel tables

As you delve into the uses of Excel tables, you’ll learn advanced skills such as connecting to other workbooks and datasets outside of Excel to ensure your data only needs to update in one place.

Next, you’ll learn how to work with tables and table references. This will help you gain crucial skills in using pivot tables to help you query large amounts of data in a user-friendly way.

Learn Excel data analysis

You’ll develop essential data analyst skills as you explore the difference between What-If Analysis, Goal Seek, and Scenario Manager to help you find the information you need from data in Excel.

Finally, you’ll learn how to create stand-out visualisations using sparklines and data bars as well as advanced charts such as Surface, Radar, Bubble, and Stock Charts.

By the end of the course, you’ll have developed the skills to use the advanced functions in Excel for your personal and professional needs.

Download video: standard or HD

Skip to 0 minutes and 1 second SPEAKER: Become an Excel expert in just three weeks. This course on advanced data visualisation is your ticket to building expertise in Excel. Deborah Ashby from Simon Sez IT is an expert of note. And in this course, she shares her knowledge to help you get all the Excel skills you want. You learn how to investigate the different functions in Excel and their uses, apply different methods of data analysis, design representations and visualisations of data using tables, graphs, and charts, and describe the features and limitations of the Excel web app. Does that sound good? Well, it gets better. You can even learn from wherever and whenever you want.

Skip to 0 minutes and 46 seconds Step into your future with Advanced Data Visualisation and Analysis in Excel from Packt and FutureLearn.

What topics will you cover?

Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly improves your productivity drastically. This course helped you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities.

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

  • Investigate the different functions in Excel and their uses.
  • Apply different methods of data analysis.
  • Design representations and visualisations of data using tables, graphs, and charts.
  • Describe the features and limitations of the Excel web app.

Who is the course for?

This course is designed for those interested in learning advanced Excel functions.

It will be most beneficial if you have some prior knowledge of basic Excel functions, which you can gain on the A Beginner’s Guide to Data Handling and Analysis in Excel course.

Who developed the course?

Packt logo

Packt

Founded in 2004 in Birmingham, UK, Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.

FutureLearn logo

FutureLearn

FutureLearn is a leading social learning platform and has been providing high quality online courses for learners around the world over the last ten years.

Ways to learn

Buy this course

Subscribe & save

Limited access

Choose the best way to learn for you!

$54/one-off payment

$244.99 for a whole year

Automatically renews

Free

Fulfill your current learning needDevelop skills to further your careerSample the course materials
Access to this courseticktick

Access expires 25 Feb 2025

Access to 1,000+ coursescrosstickcross
Learn at your own paceticktickcross
Discuss your learning in commentstickticktick
Certificate when you're eligiblePrinted and digitalDigital onlycross
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

$54/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

Limited access

Free

Sample the course materials

  • Access expires 25 Feb 2025

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

Sale price available until 3 March 2025 at 23:59 (UTC). T&Cs apply.

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

Sale price available until 3 March 2025 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

Do you know someone who'd love this course? Tell them about it...