Overview

Excel for Business with AI: Essentials is a practical, beginner-friendly course designed to help you master Excel from the ground up — with a smart twist. You'll learn to build and format professional spreadsheets, perform essential calculations, manage and analyze data efficiently, and create eye-catching visual dashboards. Along the way, you'll also explore how AI tools can enhance your workflow, speed up your tasks, and uncover data insights. Whether you're new to Excel or looking to boost your skills, this course gives you the tools to work confidently and effectively in any business setting. 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. This course is perfect for: - Business professionals looking to enhance their Excel skills - Students preparing for careers in business or data analysis - Anyone wanting to improve their productivity with spreadsheets - Professionals seeking to leverage AI tools in their Excel workflow - Complete beginners with no prior Excel experience Why This Course? Excel is one of the most widely used and versatile business tools. In six action-packed modules, we cover the essential skills needed to create stunning, accurate, and automated spreadsheets in modern Excel. Each module begins with a fireside discussion introducing important concepts, followed by six practical, hands-on videos with quick quizzes to test your understanding. At the end of each module, you'll practice all the skills covered to cement your learning before completing the assessment task. Our course also includes a unique "AI Corner" in select weeks, providing helpful suggestions on improving your Excel productivity with artificial intelligence tools like Microsoft Copilot. 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.