Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

CHAPTER 2

Creating advanced formulas

In this chapter, you will:

• Learn how to create powerful, flexible formulas with arrays.

• Understand how iteration works and how you can use it to create approximate formula solutions.

• Consolidate data from multiple worksheets into a single summary sheet.

• Learn how to keep your data models accurate by applying data-validation rules to formula input cells.

• See how to make formula inputs easier for users by adding check boxes, lists, and other dialog box controls to your worksheets.

Excel is a versatile program with many uses, from acting as a checkbook to a flat-file database-management system, to an equation solver, to a glorified calculator. For most business users, however, Excel’s forte is building models ...