Chapter 10: Exploring New and Useful Workflow Functions

Microsoft Excel 2021 houses some valuable new functions. During this part of the book, you will recap a number of important concepts and investigate some new functions. In the previous book, Learn Microsoft Office 2019, we concentrated on the differences between a formula and a function, learned about operators and formula construction, and how to use the correct order of evaluation. We also covered the Function Library and error checking.

This chapter will concentrate on the latest functions involved in learning the syntax and construction of the formula, such as XLOOKUP, LET, and XMATCH, as well as focus on IFS. We will learn to combine formulas, such as IFERROR and VLOOKUP, explore ...

Get Learn Microsoft Office 2021 - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.