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!

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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

Requirements

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

Target audience

• 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.