Excel guides

Best advanced Excel courses in 2026: what to learn and where

What an advanced Excel course should cover, a quick check of whether you are ready, and eight advanced courses compared on price, format and who each one suits.

By Nicolaj, founder of PracticeExcel · · 9 min read

Looking for an advanced Excel course? Here is the short answer. For a structured course with a certificate, take Coursera's Excel Skills for Business: Advanced. For Power Query and Power Pivot, Leila Gharani's courses at XelPlus explain modern Excel better than almost anyone. For finance roles, CFI and Wall Street Prep teach Excel the way analysts use it. And if your problem is that you understand the formulas but can't write them under pressure, practice them until you can.

Before you pick, check what "advanced" means to you. Every provider uses the word differently, and the most expensive course is the one that teaches you things your job never asks for. Below you'll find what an advanced course should cover, a five-minute readiness check, and eight options compared.

What counts as advanced Excel?

There is no official definition. A controller, a data analyst and an office manager will give you three different answers. Most courses and job postings mean some of these:

  • Lookups that don't break: XLOOKUP, INDEX with MATCH, and lookups on more than one condition.
  • Multi-condition math: SUMIFS, COUNTIFS and SUMPRODUCT, such as sales for one rep in one quarter.
  • Dynamic arrays: FILTER, SORT and UNIQUE, which spill a whole result across several cells.
  • Pivot tables: totals, percent of total, grouping by month, and slicers.
  • Power Query: pull in data from files and systems, clean it, and refresh with one click.
  • Power Pivot and data models: several tables linked together, with measures written in DAX.
  • Macros and VBA: automate what you do with the mouse, or build small tools inside Excel.
  • Financial functions and modeling: PMT, NPV and IRR, scenarios and Goal Seek.
  • Dashboards: charts, conditional formatting and drop-down lists on one page.

Nobody needs all of it. In accounting, lookups, SUMIFS and pivot tables cover most days. Analysts reach for Power Query and dynamic arrays early. VBA is for people who build tools for others.

Are you ready for an advanced course?

Plenty of people pay for an advanced course and spend the first module catching up on the basics. Try these five things first. If you can do them without looking anything up, you're ready.

  1. Write an IF that returns "Pass" when a score is 50 or more, and "Fail" otherwise.
  2. Total the sales for one city with SUMIF.
  3. Find a price in another table with VLOOKUP, and explain why FALSE goes at the end.
  4. Copy a formula down a column and lock one cell with dollar signs so it stays put.
  5. Build a simple pivot table with a total per month.

If two or more gave you pause, take an intermediate course or practice the basics first. You can try them free on PracticeExcel, for example SUMIF and VLOOKUP. If they go quickly, you know you're ready.

How this list was made

This page is written by PracticeExcel, which is one of the options. We ranked by who each course helps most and wrote each weakness down plainly, including ours. Some providers on this page run affiliate programs. Where we earn a commission, the link is marked "Paid link", and buying through it costs you nothing extra. We wrote the ranking first and added the links afterward. Facts come from each provider's own site, read on Nov 14 and 15, 2026, unless marked otherwise. We haven't taken every course as a student. Prices change often, so check before you pay.

Eight advanced Excel courses side by side

#CourseFormatPrice (checked Nov 15, 2026)Best for
1Coursera: Excel Skills for Business: AdvancedUniversity video courseCoursera Plus, $59/monthA structured course with a certificate
2XelPlus (Leila Gharani)Video coursesPower Pro bundle $549 oncePower Query and Power Pivot
3PracticeExcel (ours)Graded exercises in a browser gridFree tier, Premium $19/month or $59/yearGetting fast at the hard formulas
4CFIFinance video coursesSelf-Study $372.75/yearFinance and analyst roles
5Wall Street Prep: Excel Crash CourseFinance video course$39Finance on a budget
6Excel Campus: ElevateCoached membership$49/month or $490/yearMacros, VBA and automation
7GoSkillsShort videos with quizzes$39/month or $249/yearBite-size lessons with a CPD certificate
8UdemyLong video coursesVaries with salesA cheap course you keep

1. Coursera: Excel Skills for Business: Advanced

What it is. The last of four courses in Macquarie University's Excel Skills for Business series. It covers array formulas, data cleaning, financial functions such as NPV and IRR, INDIRECT and OFFSET, and building interactive dashboards. Coursera estimates three weeks at 10 hours a week. It is rated 4.7 from 6,304 reviews. The course expects you to have finished the first three courses or to have similar intermediate skills. See the course on Coursera.

Price. Included in Coursera Plus at $59 a month after a 7-day free trial. The yearly plan is normally $399, and on Nov 15, 2026 it was on sale for $239 until Nov 30.

Best for. Learners who want a university-built course and a certificate to add to LinkedIn.

Weaknesses.

  • No Power Query, Power Pivot or VBA.
  • A monthly plan adds up if the course takes you longer than planned.

2. XelPlus: Leila Gharani's courses

What it is. Leila Gharani runs one of the most popular Excel channels on YouTube, and the videos are free. Her paid courses are at XelPlus. The Power Pro bundle has three courses: Power Query, Power Pivot and DAX, and one on automation.

Price. The Power Pro bundle is $549, paid once. The Black Belt bundle with eight courses is $997. The Essentials bundle is $379.

Best for. Analysts and anyone who handles large data sets and wants to learn Power Query and data models properly.

Weaknesses.

  • Expensive if you only need part of it.
  • Video only, so you need to make yourself practice.

3. PracticeExcel: get fast at the hard formulas

This is us, so weigh it with that in mind. On PracticeExcel you learn by writing formulas yourself in a spreadsheet grid in your browser. You get an answer right away, and if the formula is wrong, a hint tells you what to fix. Keys work like Excel: F2, F4, Ctrl+Arrow and the rest.

At the advanced level there are topics on XLOOKUP, INDEX and MATCH, SUMIFS, SUMPRODUCT, FILTER, SORT and UNIQUE, IFS and SWITCH and summary tables. For pivot tables there are 15 pivot table exercises with answers on real sales data, which you do in your own Excel. To test yourself under a clock, try a timed practice test such as the data analyst Excel test.

Price. The first exercise in every topic is free with no account. Premium is $19 a month or $59 a year and unlocks every exercise, the timed tests and certificates. See pricing.

Best for.

  • People who have watched the explanations but can't yet write the formulas themselves.
  • Anyone who uses lookups and conditional math every day and wants to be quicker.
  • Candidates facing an Excel test for a finance or analyst job.

Weaknesses.

  • No videos and no instructor.
  • No Power Query, Power Pivot, macros or VBA. If you need those, pick another option on this list.
  • Pivot tables are done in your own Excel from our files and answers, not graded in the browser.

4. CFI: Excel for finance careers

What it is. The Corporate Finance Institute teaches Excel as part of its finance programs. Its "Advanced Excel Formulas & Functions" course runs 4 hours 30 minutes, and its Excel Skills for Professionals specialization is rated 4.8 from 6,371 ratings. Courses come with a CFI membership, not one by one. See CFI's pricing.

Price. Self-Study is $372.75 a year (shown as 25% off $497), and Full-Immersion is $592.90 a year (30% off $847). There is no monthly plan, and memberships renew each year.

Best for. People heading into financial analysis, banking or FP&A who want Excel taught with finance examples.

Weaknesses.

  • Only yearly billing, and it auto-renews.
  • Built for finance. If your job is operations or admin, much of it won't apply.

5. Wall Street Prep: Excel Crash Course

What it is. A short finance-focused course, 91 lessons and about 8 hours 39 minutes of video, from a company that trains investment bankers. See the Excel Crash Course.

Price. $39 on Nov 15, 2026.

Best for. Finance students and career changers who want the shortcuts and functions analysts use, without a yearly membership.

Weaknesses. Narrow by design. It covers what finance roles need and little else.

6. Excel Campus: Elevate

What it is. Jon Acampora's coached membership, with five levels from beginner to master, an initial assessment, practice files, a community forum and certificates of completion. It includes macros, VBA and automation. See Elevate.

Price. $49 a month or $490 a year, with a full refund in the first 30 days.

Best for. Office workers who want a guided path all the way to macros, and someone to ask.

Weaknesses. Among the priciest options. The sales page is long and not always consistent about what the plans include.

7. GoSkills: short videos with quizzes

What it is. GoSkills' Microsoft Excel 365 Basic & Advanced course by Excel MVP Ken Puls, with 3 to 6 minute videos, each followed by a practice exercise and a quiz. See it on GoSkills.

Price. A 7-day free trial, then $39 a month or $249 a year. The certificate is CPD accredited.

Best for. Busy people who want short lessons and a certificate.

Weaknesses. The course runs from basic to advanced, so the advanced part is only a slice of it. Exercises are done in your own Excel and not graded.

8. Udemy: a cheap course you keep

What it is. Udemy lists 2,467 Excel courses. At the advanced end, Maven Analytics (Chris Dutton), with 1.5 million learners on Udemy, is a common pick for formulas, pivot tables and Power Query. Browse the Excel courses on Udemy.

Price. You buy a course once and keep it. Prices change constantly with sales, so we haven't listed one.

Best for. A focused course on one topic, such as Power Query or VBA, without a subscription.

Weaknesses.

  • Quality varies from instructor to instructor. Check the reviews and the last-updated date.
  • Long, passive videos with no graded practice.

Pivot tables, Power Query or VBA?

Many people search for a course in one skill. That is often the smarter buy.

  • Pivot tables pay off fastest. A day is enough to learn what you need for monthly reports. You can practice for free with our pivot table exercises.
  • Power Query is what most people should learn before VBA. If you paste data from a system every week and fix it by hand, Power Query can do it with one click.
  • VBA is the hardest and the most niche. It makes sense when you build tools for others or need something Power Query can't do. Excel Campus and many Udemy courses teach it.

How to choose

  • Your employer pays and you want a certificate: Coursera or GoSkills, or CFI if you work in finance.
  • You work with lots of data: XelPlus for Power Query and Power Pivot.
  • You have an Excel test for a new job: practice the formulas under a clock. Tests nearly always ask about lookups, SUMIFS and IF, and rarely about VBA. Read our guide to Excel tests for job interviews.
  • You have watched the courses but the formulas don't stick: practice them. One explanation and many repetitions beat many explanations and no repetitions.

For a wider view, including options for beginners, see our list of the best places to learn Excel.

Try an advanced exercise for free

It takes two minutes to find out where you stand. Open the XLOOKUP exercise, write the formula, and see if it works. No account needed. If it goes quickly, try SUMIFS with two conditions and FILTER next.

Nicolaj

About the author

Nicolaj, founder of PracticeExcel

I'm a software developer, and I built PracticeExcel from scratch, including the spreadsheet itself and the engine that calculates the formulas. To make that work, I had to understand every function down to the details: how VLOOKUP behaves when a code has one space too many, why a date is really a number, and when ROUND gives a different answer than the number format.

More about Nicolaj

Practice what this guide covers

Graded exercises in a real grid, in the order the guide uses them.

Timed tests

Questions

What do you learn in an advanced Excel course?

Usually XLOOKUP or INDEX and MATCH, multi-condition math like SUMIFS, dynamic arrays such as FILTER, SORT and UNIQUE, and pivot tables. Many courses add Power Query, Power Pivot, dashboards, macros and VBA. "Advanced" means different things to different providers, so read the syllabus before you pay.

What is the best advanced Excel course online?

For a structured course with a certificate, Coursera's Excel Skills for Business Advanced from Macquarie University is rated 4.7 from 6,304 reviews. For Power Query and Power Pivot, Leila Gharani's Power Pro bundle at XelPlus is a strong pick. For finance, look at CFI or Wall Street Prep. Prices were checked on Nov 15, 2026.

How do I know if I am ready for advanced Excel?

If you can write IF, SUMIF and VLOOKUP without looking them up, and you know what the dollar signs in $B$2 do, you are ready. If not, an intermediate course or a few days of practice on the basics will get more out of the advanced one.

Should I learn VBA or Power Query first?

Power Query, for most people. If you import and clean the same data every week, Power Query does it with no code and refreshes with one click. VBA makes sense when you need to control Excel itself, such as building buttons, sending files or writing small tools for others.

How long does it take to learn advanced Excel?

The formula side, meaning lookups, SUMIFS and dynamic arrays, takes a few weeks of regular practice. Coursera estimates three weeks at 10 hours a week for its advanced course. Power Query, Power Pivot and VBA each take longer, so pick the one your job needs.

More guides