Microsoft Excel 2021/365 - Advanced Training Course
Master Microsoft Excel 2021 and fast-track your knowledge to ‘guru’ status with this advanced course!

In this third course of our ‘Excel 2021’ series, students will build on the skills learned in the beginner and intermediate courses and fast-track their knowledge to ‘guru’ status. Students will be introduced to 6 brand-new dynamic array functions, learn how to build advanced Excel formulas, analyze data with advanced PivotTable skills, create macros to automate tasks, import, and clean data with Power Query, forecast data, and so much more!
Excel 2021 Advanced is designed to take advantage of the latest updates from Microsoft including the ‘game-changing’, LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions.
This course is designed to help students think about problem-solving differently and encourage them to think about how to combine Excel’s myriad of functions together to complete practical tasks.
Excel 2021 Advanced is designed for students who have intermediate-level knowledge of Excel and are looking to build on those skills. It’s also perfect for students with skills in an older version of Excel.
The only pre-requisites for this course are a working copy of Excel 2021 and an intermediate-level knowledge of Excel.
Features
Verifiable
Online
Anytime

1
Guide
12
Quiz
86
Video

The “IT" in Simon Sez IT stands for “Information Technology." We offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The company was founded in 2008 by Chris “Simon" Calder, Director of IT operations for one of Los Angeles' most...