Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off

One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.

Excel is one of the most in-demand tools in business — and this course gives you everything you need to use it with confidence, from your very first spreadsheet to professional dashboards and data visualisations. Across six structured modules, you'll build skills step by step. You'll start by navigating the Excel interface and creating your own spreadsheets, then move through professional formatting, essential calculations, and data management. You'll learn to sort and filter data, work with Excel tables, and use Microsoft Copilot to generate data insights. The course closes with conditional formatting, chart creation — including column, bar, pie, line, map, and treemap charts — and building visual dashboards that communicate your data clearly. AI is integrated throughout the course in a dedicated "AI Corner" in select modules, giving you practical guidance on using tools like Microsoft Copilot to write formulas faster, solve problems, and uncover insights more efficiently. Each module follows a consistent structure: a fireside discussion video to introduce key concepts, hands-on practice videos, quick quizzes, a practice challenge, and a graded assessment. Quick reference guides and AI challenge activities support every module. Who this is for: Complete beginners, business professionals, and students who want to build practical Excel skills from the ground up, with no prior spreadsheet experience needed. Join over 1 million professionals who have advanced their careers with our highly-rated courses. Whether you're aiming to boost your employability, enhance your current role, or elevate your Excel skills, this industry-endorsed program provides the knowledge and tools to help you excel in a competitive job market. Enrol now and start your journey to Excel mastery with the power of AI.

Syllabus

Taking Charge of Excel

In this module we will create our own spreadsheet from scratch, developing confidence working in the Excel space and discovering important efficiency tools like the fill handle and the quick access toolbar.

Formatting a Spreadsheet

This module is all about making your spreadsheets look professional and easy to read as we apply a range of formats: from colours and fonts, to borders, alignment options and number formats. We look at using themes to assist with branding and consistency and explore some of the many copy paste options available.

Calculations

This module covers the key principles in creating and copying calculations in Excel. As well as simple calculations with operators we introduce the functions: SUM, AVERAGE, MAX & MIN, look at relative and absolute cell referencing and discover how AI tools can help us generate calculations.

Managing Data

This module is all about data. Organising it, automating the management of it, sorting and filtering and generating insights from it, with a little help from Copilot.

Sharing & Printing

This module explores options for setting up Excel sheets to sit nicely on the page when printed or converted to PDF and explores other options for sharing our Excel files and saving to cloud storage.

Visualising Data

This module covers presenting data visually to help unlock insights and support data driven decision making. We look at conditional formatting, creating effective charts and how to construct a dashboard.