Microsoft Excel 2021 Intermediate

In this intermediate-level course on Excel 2021, you will go beyond the basics to expand your essential Excel skillset. By working smarter with spreadsheets, you’ll be able to leverage the power of data analysis and presentation for making more informed, intelligent decisions.

By the end of the course, you will know how to create intermediate-level formulas, clean and analyze data using PivotTables and PivotCharts, control data input with validation rules, make decisions with WhatIf analysis tools, and learn the golden rules of spreadsheet design. you’ll have the exciting world of dynamic array functions at your fingertips; and using XLOOKUP, XMATCH, and FILTER, among other powerful tools, will get you on the path to becoming an Excel expert. A basic knowledge of the application is highly recommended, as is having a working copy of Excel 2021 to follow along with your instructor.