Advanced Excel course: the 10 best in 2026

Best for learners who want to fill gaps before going fully advanced. Warrick breaks down Excel's tools and features in detail, revisits key topics to reinforce them, includes a ready-made workbook for nearly every lesson and adds a section on using AI in Excel.

It has 4.6 stars from more than 28,000 reviews and more than 105,000 students. It runs about 13 hours with 34 quizzes, the most here, and was updated in October 2026. We lowered it because it starts from the beginning.

Best for intermediate users who want financial modelling skills. It focuses on advanced formatting, functions and building financial models in Excel, with real-world examples, course notes, templates, exercises and homework.

It has 4.6 stars from more than 5,600 reviews and more than 27,000 students. It runs about five and a half hours with 15 quizzes and 142 resources, and was updated in January 2026. It is not a beginners' course.

Best for anyone who builds reports and wants a repeatable dashboard process. It covers planning and wireframing, design principles, dashboard formulas such as INDEX MATCH, INDIRECT and SUMIFS, form controls, advanced chart techniques and the Camera tool, building a KPI dashboard and a regional dashboard with pivot slicers and VBA refresh.

It has 4.7 stars from more than 22,000 reviews and more than 110,000 students. It runs about 11 hours with templates, checklists and 27 resources, and was updated in March 2026.

Best for analysts who want to present data visually. It covers 20+ chart types, from histograms and box plots to tree maps, waterfalls and geospatial maps, then advanced demos such as image overlay charts, automation with named ranges, scroll and zoom with form controls, animated charts and custom dashboards.

It has 4.6 stars from more than 61,000 reviews and more than 216,000 students. It runs about four and a half hours, the shortest course here, with three quizzes, and was updated in June 2026.

Best for learners who want one course from the basics to advanced tools. Kyle covers essential formulas, modern functions such as XLOOKUP and TEXTSPLIT, tables, slicers and data validation, importing data, PivotTables and data models, Power Query, and macros and VBA.

It has 4.7 stars from more than 545,000 reviews and more than 1.8 million students, by far the most on this list. It runs about 23 hours with 14 quizzes and 62 resources, and was updated in September 2026. We lowered it because much of it covers the basics.

Best for Microsoft 365 users who want to master modern Excel. It covers FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY and XLOOKUP, how dynamic arrays affect charts, validation and conditional formatting, Boolean logic, array lifting and broadcasting, and builds KPI selectors, dynamic calendars and loan tables.

It has 4.8 stars from more than 5,200 reviews, the highest rating here, and more than 27,000 students. It runs about seven hours with four quizzes and practice workbooks, and was updated in March 2026.

Best for analysts who want business intelligence inside Excel. It walks through the full Excel BI workflow: extracting, transforming and loading data with Power Query, data modelling with relationships and normalisation, and analysing millions of rows with Power Pivot and DAX.

It has 4.7 stars from more than 29,000 reviews and more than 138,000 students. It runs about seven hours with five quizzes and homework, and was updated in June 2026. Power Query and Power Pivot are not available on Mac.

Best for users who want to automate Excel with VBA. It covers recording and writing macros, the VBA object model, ranges and workbooks, variables and arrays, loops, error handling and debugging, files and CSV export, events, UserForms, custom functions and automating Outlook, Word and PowerPoint, through three projects: a table of contents generator, a regional sales reporting tool and an invoice generator.

It has 4.7 stars from more than 48,000 reviews and more than 239,000 students. It runs about 22 hours with 53 resources and was updated in February 2026. A Windows PC is required.

Best for users who want to think like Excel and write powerful formulas. It covers lookup and reference functions including XLOOKUP and INDEX MATCH, statistical, date, time and text functions, formula-based formatting, dynamic arrays, INDIRECT and HYPERLINK, and pulling live data from APIs with WEBSERVICE and FILTERXML.

It has 4.6 stars from more than 120,000 reviews and more than 476,000 students. It runs about nine hours with eight quizzes and was updated in June 2026.