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 the term ARRAYS, and look at the new dynamic array functions in Excel 2021. There is also a topic included on database functions and a final topic exploring COUNTIFS.
The following list of topics will be covered in this chapter:
- Learning...
