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 ...