Microsoft Excel 2021/365 Masterclass: Excel Advanced Course

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

What you'll learn
Using the NEW Dynamic Array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and calculating the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analyzing data with advanced PivotTable and PivotChart hacks
Adding interaction to 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

Requirements
Microsoft Excel 2021 desktop version for Windows installed and ready to use on your computer.
Intermediate-level Excel knowledge

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

With this 10-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/365 course series, where you can build on the skills learned in the beginner and intermediate courses to fast-track your way to becoming 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/365 Advanced will take you through learning how to use the most business-relevant functions and formulas you might need, which include dynamic array functions, forecasting, statistical functions, PivotTables, PivotCharts, Power Query, Macro VBA, and so much more!

This course is designed to help you think about problem-solving differently and encourage you to think about how to combine Excel’s myriad of functions together to complete practical tasks.

Excel 2021/365 Advanced is for students who already have a good understanding of Excel and are looking to take their capabilities to the next level. It’s also suitable for students with experience in an older version of the software.

What you’ll learn

Using the NEW Dynamic Array functions to perform tasks

Creating advanced and flexible lookup formulas

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

Producing accurate results when working with financial data using math functions

Creating variables and functions with LET and LAMBDA

Analyzing data with advanced PivotTable and PivotChart hacks

Adding interaction to 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.

This course includes

10 hours of video tutorials

87 individual video lectures

Course and exercise files to follow along

Certificate of completion

Who this course is for
Users with intermediate knowledge of Excel 2021 and those upgrading from previous software versions
Users who have Microsoft Excel foundation and seeking to advance their Excel knowledge.