Part 3: Learning Excel 2021

Throughout this part, you will be taken on a journey through essential updates and new features of Excel 2021. You will learn all about Advanced Filter and the new FILTER function and explore conditional formatting rules further. We will focus on cleaning data and learning how to import, clean, join, and separate data, learning about some new features along the way, such as the UNIQUE function. You will concentrate on the latest functions, learning the syntax and construction of formulas such as XLOOKUP, LET, and XMATCH, and focusing on IFS.

We will learn how to combine formulas, such as IFERROR and VLOOKUP, explore the term ARRAYS, and look at the new dynamic array functions in Excel 2021. Also included is a topic on database functions and a final topic exploring COUNTIFS. We will explore date functions and look at how to work with time. We will also explore DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in...