Skip to content
Write a review
#2 in ExcelUdemyBestseller on UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel: Advanced Excel Formulas & Functions (Udemy.com)

Learn 75+ Excel spreadsheet formulas for data analysis & business intelligence, with a top Microsoft Excel instructor!

4.6
120,271 reviews

Created by: Maven Analytics

Last updated June 2026

Our take

Based on the ratings of 120,271 students, a sample of their written reviews and the syllabus, as the course stood in June 2026. No course pays to be reviewed.

A formulas-only Excel course from Maven Analytics, taught by founder Chris Dutton. The syllabus shows 112 lectures across 11 sections, about 9.4 hours, covering lookup and reference functions, statistical functions, text and date functions, formula-based formatting and a large block on dynamic array formulas. It's pitched at all levels but suits people who already use Excel a little and want to write proper formulas from scratch. The course was refreshed in June 2026, so XLOOKUP and dynamic arrays are covered in depth rather than bolted on. It carries a Bestseller badge and 4.6 stars from around 120,000 reviews, and about 475,000 students.

Reviewers like Dutton's teaching. One says he never disappoints, and several praise the clear, concise explanations and the homework files, which they say are the reason the material sticks. Not everyone had luck with the downloads: one found a file protected and could not follow along. The complaints are milder but real. A beginner reports the course took closer to 20 to 25 hours once practice time was included. One student found the OFFSET and COUNTA homework jumped ahead of what the videos covered. Another wanted a final project to compare the different ways of solving one problem. The two low ratings in the sample call the style dry and the example datasets too complex to follow.

Value is good if formulas are what you need. Next to the beginner-to-advanced Excel courses it sits beside, this one goes deeper on formulas and skips pivot tables, so pair it with a pivot table course if you want the whole picture. The videos are short, which one low-star reviewer found choppy. Our recommendation: take it once basic formulas feel comfortable, and budget more time than the runtime suggests.

Best forExcel users who know basic formulas and want to build lookups, dynamic arrays and formula-driven tools with homework to practise on.
Skip it ifYou want pivot tables, VBA or a gentle beginner intro; this is formulas only and reviews the fundamentals briefly.

Pros

  • Refreshed in June 2026, with XLOOKUP coverage and a 24-lecture section on dynamic array formulas
  • Homework files and project downloads that reviewers say make the material stick
  • Clear, concise explanations; students who came for a refresher say they learned new things
  • Teaches why and when to use a formula, not just the syntax, with practical demo datasets

Cons

  • No pivot tables or VBA; this is formulas only, so it is not a full Excel course
  • A beginner reports it took 20 to 25 hours with practice, not the 9.4 hours listed
  • Some homework, notably OFFSET and COUNTA, goes beyond what the videos explain
Chris Dutton never disappoints. I wanted to do a quick refresh and I ended up learning stuff, not just refreshing.
MacArena Magofke Gilbert, a student

Listed as all levels, but the requirements suggest basic formula experience; total beginners should expect to slow down and practise.

icon
What you will learn

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Automate, streamline, and completely revolutionize your workflow with Excel
  • Master unique tips & techniques that you won't find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective demos from a best-selling MS Excel instructor
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Write advanced conditional, text, date and lookup functions, including XLOOKUP & Dynamic Arrays

Course content

11 sections · 112 lectures · 9.4 hours of video 8 quizzes, 12 articles

  1. 1Getting Started 2 free previews5 lectures · 9 min
  2. 2Excel Formulas 101 2 free previews13 lectures · 1 quiz · 1.4 hours
  3. 3Conditional Statements & Logical Operators8 lectures · 1 quiz · 30 min
  4. 4Common Excel Statistical Functions 1 free preview11 lectures · 1 quiz · 1 hour
  5. 5Lookup & Reference Functions20 lectures · 1 quiz · 1.8 hours
  6. 6Text Functions10 lectures · 1 quiz · 35 min
  7. 7Date & Time Functions11 lectures · 1 quiz · 48 min
  8. 8Formula-Based Formatting7 lectures · 1 quiz · 24 min
  9. 9Dynamic Array Formulas 1 free preview24 lectures · 1 quiz · 2.5 hours
  10. 10Bonus Functions2 lectures · 17 min

Who it is for

The instructor says it suits

  • Excel users who want to learn how to write advanced formulas from scratch
  • Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
  • Excel users looking to build powerful analytical thinking and business intelligence skills
  • Anyone looking to pursue a career in analytics, data science or business intelligence

What you need before you start

  • Microsoft Excel 2013+ or Office 365 (Some features may not be available in earlier versions)
  • Experience with Excel formulas is recommended, but not required (we'll review the fundamentals)

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews120,271#2 of 356 by number of reviews
  • Length9.4 hourslonger than 68% of them
  • Last updatedJune 2026more recently than 87% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute MS Excel power user, you've come to the right place.


This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful data analytics tool.


While most Excel courses focus on simply WHAT each formula does, I teach through hands-on, contextual examples designed to showcase WHY these formulas are so powerful and HOW they can be applied in practical use cases for data analytics and business intelligence.


In other words, I will not teach you how to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.


By the end of the course you'll be writing robust spreadsheet formulas from scratch, allowing you to:


  • Build dynamic tools & Excel dashboards to filter, display and analyze your data

  • Create your own formula-based Excel formatting rules

  • Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions

  • Manipulate dates, times, text, and arrays

  • Use formulas for data prep, data cleaning and QA

  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)

  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)


We'll dive into a broad range of Excel formulas & functions, including:


  • Lookup/Reference functions

  • Statistical functions

  • Formula-based formatting

  • Date & Time functions

  • Logical operators

  • Dynamic Array formulas

  • Text functions

  • INDIRECT & HYPERLINK

  • Web scraping with WEBSERVICE & FILTERXML


I have a genuine passion for Microsoft Excel, and as the founder of Maven Analytics I've been lucky enough to teach more than 1,000,000 students around the world. My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend.


If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel rockstar, you're in the right place!


See you in the course!

-Chris (Founder, Maven Analytics)


__________

Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!


See why this is one of the TOP-RATED Excel courses on Udemy:

"One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!"

-Julio Garcia

"This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can teach!"

-Barbara S.

"Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!"

-Bruno Ricardo Silva Pinho


*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.
Read More All Levels All Levels product length iconTime: 9.4h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Maven Analytics

Maven Analytics is an award-winning platform where individuals and teams build new skills, showcase work, and connect with experts around the world.

We've helped more than 2,000,000 learners around the world build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers.

Start learning for free!

Read More

icon
More courses by Maven Analytics

$139.99

$199.99

$199.99

$17.99

$139.99

$129.99

All courses by Maven Analytics

icon
Reviews

4.6

120,271 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Tairene O'Connor on 8/30/2026

The course itself is amazing! The amount of information can set anyone up for success on excel really GameChanger, as an excel beginner though this course did not take me 10 hours more like 20 - 25 because the course does not account for practice time. Because I wanted to retain the info I used the resource items and actually practiced and did the homework. the downloads on resource tab is equally amazing

By MacArena Magofke Gilbert on 8/18/2026

Chris Dutton never disappoints. I wanted to do a quick refresh and I ended up learning stuff, not just refreshing. He provides a lot of examples and good stuff, but given the multiple ways to achieve the same thing, I'd have appreciated a final project with answers to assess a few options to solve the same problem.

By Michelle Nester on 8/11/2026

I love all things Maven Analytics! I have taken a few of their classes through Udemy and have thoroughly enjoyed them and gotten a wealth of knowledge from them! All very useful!!!!!!!!!!!!!!!!!!!!!!

By Ebony Evans on 8/9/2026

For the most part instruction is clear, concise and easy to understand. Can find references within the instruction to complete homework and then there was the offset/counta homework. There's detailed instruction and examples in the videos with most of the formulas and functions so far and then offset and counta gets this footnote of a video besides the chart video for offset, then suddenly there's all these tasks for offset and counta in the homework. I'm not understanding that one.

By Carli Dicks on 7/2/2026

I am learning a lot so far. This course has already helped me save a lot of time with all the shortcuts. I have greater base to work with, my excel skills and understanding has greatly improved. I better under stand how it can be practical for my everyday work.

By Dat Chau on 6/17/2026

Yes, I love this course a lot. It is getting tougher and tougher especially using OFFSET function to create a dynamics scroll and zoom chart. I was a bit loss there. Perhaps, this function can be reintroduced when chart plotting in excel is taught.

By Vishwas S on 5/30/2026

Taking this course was a very positive experience for me. The content was well structured and easy to follow, and it helped me strengthen both my conceptual understanding and practical skills. The examples and assignments were relevant and directly applicable, which made learning more effective. Overall, the course matched my learning goals well and was definitely a good fit for me.

By Muhammad Talha Butt on 5/26/2026

This course was exceptionally well-structured, insightful, and professionally delivered. The concepts were explained with clarity and supported by practical, real-world applications that significantly enhanced my understanding and skill set. The hands-on exercises and comprehensive content made the learning experience highly engaging and valuable. I would highly recommend this course to both beginners and professionals seeking to strengthen their expertise.

By Meenu Kumar on 5/14/2026

with in a span of 10 minutes I learned couple of great formulas with very easily due to the trainer easy to understand approach with the template to practice on, I think I selected the best course, if you are looking for excel formulas course this is the best one go for it.

By Amrita Bhowmick on 4/19/2026

this advance excel course was genuinely beyond expectations. Real-world examples helped me apply concepts at work immediately. Perfect for anyone wanting to move beyond basics and master excel efficiently.

Showing all 10 reviews on CourseDuck

Read all 120,271 reviews on Udemy

Microsoft Excel: Advanced Excel Formulas & Functions
Visit course on Udemy Write a review
  • Video Duration: icon 9.4h
  • Price: $199.99
  • Provider: icon Udemy
  • Updated: icon June 2026
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
  • Lectures:112 in 11 sections
  • Practice:8 quizzes
  • Students:474,700
  • Subtitles:23 languages
  • Udemy badge:Bestseller
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com