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

Discover the Power of Data Analytics in Excel

Welcome to your guide to mastering Excel for business intelligence. Whether you are stepping into data science or sharpening your commercial acumen, you will immerse yourself in practical, hands-on learning that transforms raw numbers into strategic growth engines.

Establish strong Excel foundations for analysis

Build confidence using Excel by exploring data types, formatting, formulas, and functions while learning how spreadsheets support effective analysis. Through practical exercises and structured datasets, you’ll develop the skills to work with data more accurately, efficiently, and confidently.

Transform raw datasets into actionable insights

Move beyond the basics as you prepare, clean, and analyse data using practical Excel techniques. From sorting and filtering datasets to working with pivot tables, charts, and SUMIF functions, you’ll uncover meaningful patterns and present insights clearly while handling common spreadsheet challenges with confidence.

Model scenarios and support data-driven decisions

Advance your Excel expertise with powerful decision-making and analytical tools. Using What-If Analysis features and the Analysis ToolPak, you’ll explore scenario modelling, statistical techniques, forecasting methods, and data-driven approaches that support confident business decision-making.

Syllabus

Week 1
Data Analytics in Excel Using Real-World Examples
- Course overview
  An introduction to the course objectives and a chance to think about how you will learn. There is also an opportunity to introduce yourself and meet fellow learners.
- Course Introduction
  Get started with Excel by exploring the interface, understanding data types, and building confidence with basic concepts. You’ll learn how to navigate spreadsheets and prepare for effective data analysis.
- Using Excel Spreadsheets for Data Analysis
  Develop essential Excel skills for data analysis by learning how to enter, format, and work with data. You’ll build confidence using formulas, functions, and references to analyse and manage datasets effectively.
Week 2
Data Cleaning, Analysis and Advanced Decision‑Making with Excel
- Cleaning and Managing Data
  Learn how to prepare high‑quality data for analysis in Excel. You’ll explore techniques to import, clean, and organise datasets, ensuring accuracy and consistency for reliable insights.
- Analyzing Data
  Learn how to analyse data in Excel using formulas, functions, pivot tables, and charts. You’ll turn raw data into meaningful insights, identify trends, and present information clearly and effectively.
- What-If Analysis and Analysis ToolPak
  Explore advanced Excel tools for deeper analysis and decision‑making. Learn to model scenarios, apply statistical techniques, and use What‑If Analysis and the Analysis ToolPak to solve real‑world problems.

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
Join - $109

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

Learn to view, enter, and format data types in Excel
Understand and apply Excel formulas and functions
Learn to sort data and apply filters, including advanced filtering techniques
Work with Excel charts, including clustered columns, line graphs, and waterfalls
Apply techniques to recognize and avoid formula errors
Create problem statements to tackle complicated “or” criteria

Who is the course for?

This course is ideal for a diverse audience of professionals, including business analysts, data enthusiasts, and individuals seeking to strengthen their data analytics skills. It’s a valuable resource for students pursuing careers in data science, business intelligence, or related fields. If you are eager to harness the power of Microsoft Excel for data manipulation and analysis, this course provides essential insights and techniques.

Who developed the course?

Packt

Practical Tech Learning, Built for Where the Industry Is Heading

For over 20 years, Packt has helped technologists at every stage turn complex topics into real, usable skills. We’re a global technology learning publisher with a library of more than 9,000 hands-on tutorials, and we’re adding to it constantly.

What's included?

This is a premium course. These courses are designed for professionals from specific industries looking to learn with a smaller group of like-minded individuals.

Unlimited access to this course
Includes any articles, videos, peer reviews and quizzes
Certificate of Achievement to prove your success when you're eligible
Download and print your Certificate of Achievement anytime

Join - $109

Still want to know more? Check out our FAQs

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