
Excel in 2026 is a different tool from the one most of us learned. Dynamic arrays have changed how formulas are written, Power Query has taken over the grunt work of cleaning and combining data, and Copilot now sits inside the ribbon. The good news is that you can learn all of it without paying a cent.
In this article, we’ll explore 7 free Excel courses to master Excel in 2026, from beginner to advanced. For each course, you’ll find the length, the level, and what you’ll be able to do once you finish.
1. Excel Skills for Business: Essentials (Macquarie University, Coursera)
Level: Beginner
Length: About 7 weeks at roughly 4 hours a week
Cost: Free to audit; certificate is paid
Link: Excel Skills for Business: Essentials
If you want a university-style structure with deadlines and a clear start-to-finish path, begin here. It is aimed at people who have little or no Excel experience and want solid foundations rather than a bag of tricks. It offers video lectures, structured practice workbooks, and real-world business scenarios.
What You’ll Be Able to Do Afterward:
- Move around Excel confidently and build clean, well-formatted workbooks
- Use the logical and lookup functions (IF, AND, OR, VLOOKUP, XLOOKUP) that most office work depends on
- Clean messy data exports and set up multi-level sorting and filtering
- Design summaries with basic PivotTables
2. Free Online Excel Training: Basic to Advanced (Sumit Bansal, TrumpExcel)
Level: Beginner to intermediate
Length: 26 video lessons, 12+ hours
Cost: Free, no sign-up required
Link: FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)
Sumit Bansal, a long-time Microsoft Excel MVP, organizes this course into modules: Excel basics, essentials such as tables and Flash Fill, formulas, data analysis, charting, PivotTables, and a short introduction to macros. Most lessons come with a downloadable practice workbook, so you can follow along.
One advantage is that you can access the lessons without registering or paying. You can also skip introductory sections if you’re already comfortable with the basics.
What You’ll Be Able to Do Afterward:
- Navigate workbooks and worksheets
- Create formulas and use cell references
- Work with logical, lookup, statistical, text, and date functions
- Apply data validation, conditional formatting, sorting, and filtering
- Build standard and advanced charts, and summarize large datasets with PivotTables and slicers
- Record basic macros and protect workbooks
You’ll be able to create and manage everyday spreadsheets, calculate results using formulas, and prepare basic reports without relying on manual calculations.
3. Learn Excel Formulas and Functions (freeCodeCamp)
Level: Beginner to intermediate
Length: About 2 hours
Cost: Free on YouTube
Link: Excel Formulas & Functions – Full Course
Published in September 2026, this is the quickest way to bring your formula skills up to date. It is taught by Sergio, the creator of Formula Wars, in a code-style, practice-first format with quizzes and hands-on problems.
What You’ll Be Able to Do Afterward:
- Troubleshoot common formula errors
- Write conditional logic with IF, AND, OR, and IFS
- Summarize data with conditional aggregation
- Look things up with XLOOKUP, INDEX, and XMATCH
- Clean up messy text and dates
- Use FILTER, SORT, and UNIQUE for a first taste of dynamic arrays
4. Excel Basics for Data Analysis (IBM, Coursera)
Level: Beginner
Length: Roughly 10 to 12 hours (about 1 week at 10 hours/week)
Cost: Free to audit; certificate is paid
Link: Excel Basics for Data Analysis
Where the first three courses teach Excel itself, this one teaches you to think like an analyst. It frames the material around real analytical workflows: getting data ready, checking its quality, and then summarizing it. It’s an excellent bridge from the basics to practical data work, and it works with Excel Online or the desktop app.
What You’ll Be Able to Do Afterward:
- Navigate spreadsheets, import data, and clean and wrangle data with functions
- Use filtering and sorting, lookup functions, and PivotTables for analysis
- Practice on real datasets without coding
If you already understand Excel formulas and want to use spreadsheets for data analysis, you can also explore Excel Data Analysis Basics Class – Data Analysis & BI Made Easy with Excel Power Tools, offered by ExcelIsFun. The course, taught by Mike Girvin, explains how different Excel features work together to turn raw data into meaningful reports. It’s available for free on YouTube through Class Central.
Level: Intermediate · 6 hours · 10 lessons
Link: Excel Data Analysis Basics – Data Analysis & BI Made Easy with Excel Power Tools
You’ll be able to build analytical reports and dashboards that summarize business performance and highlight important trends. You’ll also understand Power Pivot and data models, and how to use Excel alongside Power BI for reporting.
5. Free Power Query Course (Sumit Bansal, TrumpExcel)
Level: Intermediate (beginners to Power Query are welcome)
Length: 41 short video lessons, 6+ hours
Cost: Free, no sign-up
Link: Free Power Query Course
Power Query turns repetitive data preparation into a refreshable workflow. This course is split into short, single-topic videos, so it’s easy to fit into a workday, and it includes an example-files download.
What You’ll Be Able to Do Afterward:
- Import data from the web, CSV and text files, other workbooks, and whole folders
- Append and merge tables without VLOOKUP
- Split, filter, sort, group, and unpivot data
- Add custom and conditional columns
- Read basic M code
- Refresh everything with one click when the source changes
You can also explore Skillwave’s Power Query Fundamentals course, taught by Ken Puls, Matt Allington, and Miguel Escobar. It includes four modules, three quizzes, and downloadable learning materials. The course is free and includes a certificate of completion. Registration is required to enroll.
Level: Beginner–Intermediate · 2 hours 30 minutes · 4 modules
Skillwave Training: Skillwave’s Power Query Fundamentals
You’ll be able to import data, identify and fix common Power Query errors, prepare messy data for analysis, and refresh your queries when the source information changes.
6. Excel for Office 365 & Dynamic Arrays (Leila Gharani)
Level: Intermediate–Advanced
Length: 8 hours 23 minutes, 50 videos
Cost: Free on YouTube
Link: Excel for Office 365 & Dynamic Arrays
Dynamic array functions have changed how Excel handles calculations and data analysis. Instead of copying formulas across hundreds of cells, you can use a single formula to return multiple results automatically.
Leila Gharani’s free YouTube playlist introduces modern Excel features, with particular attention to dynamic arrays and efficient spreadsheet workflows.
What You’ll Be Able to Do Afterward:
- Filter records dynamically with FILTER
- Extract and count unique values with UNIQUE, and sort with SORT and SORTBY
- Work with modern Excel 365 functions
- Create flexible reports that expand automatically when the underlying data changes
You can also explore the Advanced Excel 365 Training course, offered by Simon Sez IT. This course focuses on dynamic arrays. It starts with what spill ranges are and how they behave, then works through the functions that make modern Excel formulas shorter and easier to maintain. The course is free on YouTube (listed on Class Central).
Level: Advanced · 3 hours · 38 videos
Simon Sez IT: Advanced Excel 365 Training: Dynamic Arrays, Complex Lookups, and Power Tools
You will be able to extract and count unique values with UNIQUE, sort with SORT and SORTBY, generate sequences with SEQUENCE, filter data with AND and OR logic using FILTER, perform complex lookups, and create your own reusable functions with LET and LAMBDA.
7. Work Smarter in Excel with Copilot Chat (Microsoft Learn)
Level: Beginner (no prerequisites)
Length: One self-paced module with 7 units, including two hands-on exercises and a knowledge check
Cost: Free
Link: Work smarter in Excel with Copilot Chat
Copilot is most useful once you already know enough Excel to judge its answers, which is why it sits last. This short Microsoft module covers the basics of asking Copilot Chat for help inside a workbook. Microsoft also offers a companion module, “Summarize sales data using Copilot in Excel”, if you want more practice.
What You’ll Be Able to Do Afterward:
- Understand data analysis workflows with Copilot in Excel
- Generate formulas from plain-language prompts
- Use natural-language prompts to explore datasets
- Generate insights with Microsoft’s Analyst Agent
- Explore AI-assisted data visualization that highlights key insights
- Automate routine tasks to save time and reduce errors
- Practice Copilot workflows through a guided exercise
You’ll understand how to use Copilot to assist with analytical tasks, such as identifying patterns in sales data or preparing visual summaries.
The Microsoft Learn module is free. However, access to specific Copilot features for hands-on practice depends on your Microsoft 365 subscription and available licensing. You can still study the learning materials without purchasing a Copilot license.
How to Put the List Together
You don’t need to take all seven. Here are three sensible routes:
- Complete beginner: Course 1 or 2, then 3, then 4.
- Working with messy data: Course 3, then 5, then 4 for the analysis habits.
- Already comfortable with formulas: Course 6 for dynamic arrays, Course 5 for Power Query, and Course 7 to speed up the rest.
Whichever route you choose, open Excel alongside every video and rebuild each example on your own data. Watching alone rarely sticks.
Final Thoughts
You can follow these 7 free Excel courses to master Excel in 2026. Free Excel training in 2026 is deep enough to take you from your first formula to automated, Copilot-assisted reporting. Pick one course, finish it, and apply it to a real task this week. Course lengths, access terms, and what’s free to audit change over time, so check each provider’s page before you commit.
Get FREE Advanced Excel Exercises with Solutions!

