Microsoft Excel 2021/365 Masterclass: Advanced Excel Course

Go beyond the basics and supercharge your Excel knowledge with this Excel 2021/365 advanced training course!

4.40 (161 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

Using the NEW dynamic array functions to perform tasks

Creating advanced and flexible lookup formulas

Using statistical functions to rank data and to calculate the MEDIAN and MODE

Producing accurate results when working with financial data using math functions

Creating variables and functions with LET and LAMBDA

Analysing data with advanced PivotTable and PivotChart hacks

Creating interactive reports and dashboards by incorporating form controls

Importing and cleaning data using Power Query

Predicting future values using forecast functions and forecast sheets

Recording and running macros to automate repetitive tasks

Understanding and making minor edits to VBA code

Combining functions together to create practical formulas to complete specific tasks

Why take this course?

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

With this ten-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial data.

This is the third part of our Excel 2021 course series, where you can build on the skills learned in the beginner and intermediate courses and fast-track your way to being an Excel power user.

This course covers the latest updates from Microsoft, including the LET and LAMBDA functions, which allow you to create your own variables and even Excel functions.

Excel 2021 Advanced will show you how to use the most business-relevant functions and formulas you might need, such as dynamic array functions, forecasting, statistical functions, PivotTables, PivotCharts, Power Query, Macro VBA, and so much more!

This course is designed to inspire you to approach problem-solving differently and encourage you to combine Excel’s myriad of functions to complete practical tasks.

This Excel 2021 masterclass is for students who already have a good understanding of Excel and want to take their capabilities to the next level. It’s also suitable for students with significant experience in an older version of the software.

What we cover in this course:

Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analysing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.

This course includes:

10 hours of video tutorials
87 individual video lectures
Course and exercise files to follow along
Certificate of completion

Here's what our students are saying...

★★★★★ "So far, it is a good match for me. Everything is explained in better detail and is simple to understand." -Kirsten Morales

Reviews

Omar

October 1, 2023

An advance Excel course with all materials and good explanations of functions and their combination to handle new Excel 2021 / 365 versions.

Sharon

July 19, 2023

The Simon Sez courses are always a great learning experience. Course material is clearly explained. The exercises are an added plus. TY

Rhiannon

July 11, 2023

I'm enjoying the course, but I've found that a lot of the source documents are incorrectly labelled, I'll open the corresponding document with the exact same title as the one she is working with on the screen but the contents are totally different.

Ghanim

July 1, 2023

it was very useful training course, hope i be in second chance tp patecipate in more courses specillay in tech, fileds. Many thanks.

Pam

April 27, 2023

since I haven't taken an excel course in the last 10 years, I was not aware of all of the new functionality. (I thought I knew everything :))

Davide

December 31, 2022

The course is well structured and delivers useful information. I'm not sure the content is fully consistent with the definition of advanced. Perhaps a section on VBA is not a good fit for this course, and I would suggest to keep this topic for a dedicated course. Very good the sections on forecasting and Power Query.

Tricia

October 18, 2022

I thought I knew Excel really well..but the information and how-to's in this course are absolutely invaluable. Each step is broken down clearly and easy to understand. So many time-saving ideas in this course.

Eugene

October 14, 2022

I would have giving you a 5 star rating, but I did not because the file you was using, you did not include or fail to tell us which to open.

Kirsten

August 10, 2022

So far, it is a good match for me. Everything is explained in better detail and is simple to understand.

Ivan

May 10, 2022

I've really enjoyed going through this course. The instructors appealing voice combined with clear and straight to the point explanation skills makes this course a must have. Recommended. Can't give all 5 stars due to video quality which is currently available in 720p max.

Charts

Price

Rating

Enrollment distribution

Microsoft Excel 2021/365 Masterclass: Advanced Excel Course - Distribution chart