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!
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.
Das ist alles enthalten
11 Videos12 Lektüren7 Aufgaben
Infos zu Modulinhalt anzeigen
11 Videos•Insgesamt 50 Minuten
Welcome to Excel for Business with AI•2 Minuten
Getting the most out of your course•1 Minute
Introduction: Taking Charge of Excel•1 Minute
Discussion Video •3 Minuten
Practise Video: Taking Charge of Excel•7 Minuten
Practise Video: Navigating and Selecting Data•6 Minuten
Practise Video: Creating a Spreadsheet•6 Minuten
Practise Video: Entering and Editing Data•6 Minuten
Practise Video: Using the Fill Handle•6 Minuten
Practise Video: Managing Rows and Columns •6 Minuten
Practise Challenge Video•5 Minuten
12 Lektüren•Insgesamt 120 Minuten
Course Overview & Learning Journey •10 Minuten
Skills Checklist •10 Minuten
Taking Charge Workbook•10 Minuten
Navigating and Selecting Workbook•10 Minuten
Entering and Editing Data Workbook•10 Minuten
Using the Fill Handle Workbook•10 Minuten
Columns and Rows Workbook•10 Minuten
Columns and Rows Workbook Solution •10 Minuten
Practise Challenge Workbook•10 Minuten
Practise Challenge Workbook Solution •10 Minuten
Assessment Workbook•10 Minuten
Quick Reference Guide•10 Minuten
7 Aufgaben•Insgesamt 84 Minuten
Taking Charge of Excel•9 Minuten
Navigating and Selecting •9 Minuten
Creating a Spreadsheet•9 Minuten
Entering and Editing Data•9 Minuten
Using the Fill Handle•9 Minuten
Managing Rows and Columns•9 Minuten
Taking Charge of Excel Assessment•30 Minuten
Formatting a Spreadsheet
Modul 2•4 Stunden abzuschließen
Moduldetails
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.
Das ist alles enthalten
9 Videos11 Lektüren7 Aufgaben
Infos zu Modulinhalt anzeigen
9 Videos•Insgesamt 44 Minuten
Introduction Video Formatting a Spreadsheet•1 Minute
Discussion Video•3 Minuten
Practise Video: Fonts and Colours•5 Minuten
Practise Video: Borders and Styles•7 Minuten
Practise Video Alignment Tools•5 Minuten
Practise Video Number Formats•6 Minuten
Practise Video Copy & Paste•7 Minuten
Practise Video Themes & Images•5 Minuten
Practise Challenge Video•6 Minuten
11 Lektüren•Insgesamt 110 Minuten
Formatting a Spreadsheet Skills Checklist •10 Minuten
Fonts and Colours Workbook•10 Minuten
Borders and Styles Workbook•10 Minuten
Alignment Tools Workbook•10 Minuten
Number Formats Workbook•10 Minuten
Cut, Copy & Paste Workbook•10 Minuten
Themes and Images Workbook•10 Minuten
Practise Challenge Workbook•10 Minuten
Practise Challenge Workbook Solution•10 Minuten
Assessment Workbook•10 Minuten
Quick Reference Guide•10 Minuten
7 Aufgaben•Insgesamt 84 Minuten
Fonts and Colours Practice•9 Minuten
Borders and Styles •9 Minuten
Alignment Tools•9 Minuten
Number Formats•9 Minuten
Cut, Copy and Paste•9 Minuten
Themes & Images •9 Minuten
Formatting a Spreadsheet•30 Minuten
Calculations
Modul 3•5 Stunden abzuschließen
Moduldetails
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.
AI Challenge: Use AI to help with Excel calculations•10 Minuten
7 Aufgaben•Insgesamt 81 Minuten
Simple Calculations Quiz•6 Minuten
Practise Quiz Absolute Cell References•9 Minuten
SUM and Autosum •9 Minuten
AVERAGE, MAX and MIN •9 Minuten
Calculations across Sheets •9 Minuten
Getting Help from AI •9 Minuten
Calculations Assessment •30 Minuten
Managing Data
Modul 4•5 Stunden abzuschließen
Moduldetails
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.
Das ist alles enthalten
9 Videos14 Lektüren7 Aufgaben
Infos zu Modulinhalt anzeigen
9 Videos•Insgesamt 50 Minuten
Managing Data Introduction Video•1 Minute
Discussion Video•3 Minuten
Practise Video: Working with Sheets •7 Minuten
Practise Video: Creating a Table •6 Minuten
Practise Video: Working with Tables •6 Minuten
Practise Video Sorting Data •4 Minuten
Practise Video: Filters & Slicers •7 Minuten
Practise Video: Data Insights with Copilot •6 Minuten
Practise Challenge Video: Managing Data•8 Minuten
14 Lektüren•Insgesamt 140 Minuten
Skills Checklist•10 Minuten
Working with Sheets Workbook•10 Minuten
Creating a Table Workbook•10 Minuten
Working with Tables Workbook•10 Minuten
Sorting Data Workbook•10 Minuten
Filters & Slicers Workbook•10 Minuten
Data Insights with Copilot Workbook•10 Minuten
Data Insights with Copilot Workbook Solution •10 Minuten
Practise Challenge Workbook•10 Minuten
Practise Challenge Workbook Solution•10 Minuten
Assessment Workbook•10 Minuten
Quick Reference Guide•10 Minuten
AI as your thinking Partner•10 Minuten
AI Challenge: Use CoPilot to help generate insights•10 Minuten
7 Aufgaben•Insgesamt 84 Minuten
Practise Quiz: Working with Sheets •9 Minuten
Practise Quiz: Creating a Table •9 Minuten
Practise Quiz Working with Tables •9 Minuten
Practise Quiz Sorting Data •9 Minuten
Practise Quiz Filters & Slicers •9 Minuten
Data Insights with Copilot •9 Minuten
Managing Data Assessment•30 Minuten
Sharing & Printing
Modul 5•4 Stunden abzuschließen
Moduldetails
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.
Das ist alles enthalten
9 Videos11 Lektüren7 Aufgaben
Infos zu Modulinhalt anzeigen
9 Videos•Insgesamt 50 Minuten
Sharing & Printing Introduction Video•1 Minute
Discussion Video•3 Minuten
Practise Video: Print Preview •5 Minuten
Practise Video: Page Layout Options •6 Minuten
Practise Video: Headers and Footers •5 Minuten
Practise Video: Print Titles & Print Areas •5 Minuten
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.
Das ist alles enthalten
10 Videos13 Lektüren8 Aufgaben
Infos zu Modulinhalt anzeigen
10 Videos•Insgesamt 61 Minuten
Visualising Data Introduction Video•1 Minute
Discussion Video•4 Minuten
Practice Video: Quick Conditional Formats•7 Minuten
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
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.
Who is this course for?
This course is ideal for:
- Business professionals aiming to improve their Excel skills
- Students gearing up for careers in business or data analysis
- Individuals wanting to boost their productivity with spreadsheets
- Professionals looking to integrate AI tools into their Excel workflow
- Complete beginners with no previous Excel experience
What Skills Will I Learn?
By the end of this course, you'll be able to:
- Create professional-looking spreadsheets from scratch
- Perform calculations and analyze data efficiently
- Build visually appealing charts and dashboards
- Leverage AI tools to enhance your Excel workflow
- Print and share your Excel documents professionally
- Apply best practices for data management and visualization
What version of Excel do you teach?
In this course, we are using Microsoft Excel $$$$ (Office 365) on a Windows PC with all options set to default. The Office 365 version of Excel is the latest version at the time of writing and developing this course. If you have a different version of Excel or you are using a Mac, some tools and buttons will look different, they may be located in a different spot, or some might be missing altogether. If there are any major differences, we usually point them out during the practice videos. If you cannot find a tool that we mention, you can always ask in the forums or search the Internet. Most of the functionality we demonstrate is also available in other spreadsheet programs, although the interface will look different. Most other spreadsheet software can import and export files in the Microsoft Excel format. If you are not sure which version of Excel you are using, check the Microsoft support pages for help.
If you cannot use Excel 2016 on a PC, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require Excel. Where possible, we have designed assessment tasks so that users of older versions of Excel (such as 2013) can still solve them.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.