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.