Course: Microsoft Excel 2021 - Intermediate

In this second course of an Excel 2021 series, you will build on the skills learned in the beginners' course. Learn how to create intermediate-level formulas, clean and analyze data using PivotTables and Pivot Charts, control data input with validation rules, make decisions with WhatIf analysis tools, and learn better spreadsheet design. Explore dynamic array functions and learn how to use XLOOKUP, XMATCH, FILTER and so much more. Excel 2021 Intermediate is designed for students who have a beginner-level knowledge of Excel.