Skip to content
Write a review
UdemyOffice ProductivityPaid courseExpert levelCertificate

Microsoft Excel 365 Advanced (Udemy.com)

Unlock the power of advanced Excel 365 features and boost your data analysis and productivity skills.

4.8
131 reviews

Created by: Simon Sez IT

Last updated June 2026

icon
What you will learn

  • Extract and count unique entries using Dynamic Array Functions.
  • Differentiate between unique and distinct values in Excel spreadsheets.
  • Utilize SORT and SORTBY functions for data organization and analysis.
  • Employ FILTER functions with logical operators for precise data filtration.
  • Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
  • Perform complex lookups efficiently using XLOOKUP and XMATCH functions.
  • Develop custom formulas with LET and LAMBDA functions for tailored analysis.
  • Create and manage data models with Power Pivot, including table relationships.
  • Clean and manipulate data effectively using Power Query functionalities.
  • Automate repetitive tasks and customize Excel with macros and VBA.

How it compares

Against the other 459 rated Udemy courses in Office Productivity on CourseDuck:

  • Rating4.8 out of 5higher than 98% of them
  • Reviews131#388 of 460 by number of reviews
  • Length6 hourslonger than 63% of them
  • Last updatedJune 2026more recently than 80% of them

icon
Course Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


Welcome to the Microsoft Excel 365 Advanced course. In this course, you will delve into advanced features of Excel 365 to enhance your data analysis and productivity skills.


You'll explore dynamic array formulas, unlocking the power of functions like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn to perform complex lookups and reference functions, even with multiple criteria and duplicate values. Moreover, you'll discover how to create your own functions using LET and LAMBDA, empowering you to tailor formulas to your needs.


Master Power Pivot and Power Query to manage and analyze vast datasets effortlessly. Gain insights into advanced PivotTable and Pivot Chart techniques, including customization and dynamic labels, and harness the potential of form controls and checkboxes to create interactive Excel applications. Then, delve into Excel macros and VBA to automate repetitive tasks and customize Excel functionalities.


By the end of this course, you should have the proficiency to utilize the advanced features of Microsoft Excel 365, empowering you to tackle complex data analysis tasks with confidence. Join us in this comprehensive journey and unlock new productivity levels in your spreadsheet endeavors.



In the course, you will be able to:

  • Extract and count unique entries using Dynamic Array Functions.

  • Differentiate between unique and distinct values in Excel spreadsheets.

  • Utilize SORT and SORTBY functions for data organization and analysis.

  • Employ FILTER functions with logical operators for precise data filtration.

  • Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.

  • Perform complex lookups efficiently using XLOOKUP and XMATCH functions.

  • Develop custom formulas with LET and LAMBDA functions for tailored analysis.

  • Create and manage data models with Power Pivot, including table relationships.

  • Clean and manipulate data effectively using Power Query functionalities.

  • Automate repetitive tasks and customize Excel with macros and VBA.


This course includes:

  1. 6 hours of video tutorials

  2. 68 individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion
Read More Expert Expert Level product length iconTime: 6h

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

Simon Sez IT

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 12,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 1 million Udemy students in over 190 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

Read More

icon
More courses by Simon Sez IT

$19.99

$14.99

$109.99

$174.99

$84.99

$84.99

All courses by Simon Sez IT

icon
More Office Productivity courses

$19.99

$10.99

$39.99

$64.99

$12.99

$19.99

All Office Productivity courses

icon
Reviews

4.8

131 ratings on Udemy

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

Write a review

By Simeon Tor-Agbidye on 2/16/2026

After taking the Intermediate course, this course is living up to my expectations. I am absolutely fired up to start practicing my newly acquired Advanced Excel skills.

By Markus Louis Faasen on 1/5/2026

This course really helps understand Excel better. It really how Excel use to its full potential

By Miguel Hernandez on 7/25/2025

Great course, a lot of excercise and clear explanation.

By Aina Deborah on 7/22/2025

I feel very excited taking the course, it's been a great experience so far.

By XUHUA GU on 7/6/2025

Well presented and learnt many new things as I have already used excel for 10+ years, I really enjoy the new functions and tips shared in this course. Thanks!

By Fernanda on 2/20/2025

Yes, I learned a lot and it was very easy to understand and follow with the way it is explained.

By Jana Huss on 2/4/2025

Very nice course with lots of hands on exercices. I really enjoyed the journey.

By Ketra Wolfe on 11/30/2024

So far so good! I had to slow down video speed to follow along accordingly.

By Pete Murphy on 11/6/2024

It's a great course, really covering the advanced concepts. To be honest, yes the concepts are advanced level, but if you already have some background in Excel you can manage this course.

By Grant Wykerd on 10/1/2024

Learning little to humongous nuggets of worthy information, making this course more than worth its weight in gold and by that I mean this course focuses HEAVILY on bringing you up to speed quicker than any of the other Excel related courses I've encountered... Are you still reading this? Stop already and get enrolled now...

Showing all 10 reviews on CourseDuck

Read all 131 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 96 / 100

Microsoft Excel 365 Advanced
Visit course on Udemy Write a review
  • Video Duration: icon 6h
  • Price: $74.99
  • Provider: icon Udemy
  • Updated: icon June 2026
  • Level: Expert Expert
  • Language: icon English
  • Certificate: icon Yes
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