Page 216 - Excel 2007 Bible
P. 216

15_044039 pt02.qxp  11/21/06  11:04 AM  Page 173
                                                      Working with
                                                     Formulas and
                                                             Functions
                                            ormulas and worksheet functions are essential to manipulat-  IN THIS PART
                                            ing data and obtaining useful information from your Excel
                                       Fworkbooks. The chapters in this part present a wide variety  Chapter 11
                                        of formula examples that use many of Excel’s functions. Two of the  Introducing Formulas and
                                        chapters are devoted to array formulas. These chapters are intended  Functions
                                        primarily for advanced users who need to perform calculations that
                                        may otherwise be impossible.                           Chapter 12
                                                                                               Creating Formulas That
                                                                                               Manipulate Text
                                                                                               Chapter 13
                                                                                               Working with Dates and Times

                                                                                               Chapter 14
                                                                                               Creating Formulas That Count
                                                                                               and Sum
                                                                                               Chapter 15
                                                                                               Creating Formulas That
                                                                                               Look Up Values
                                                                                               Chapter 16
                                                                                               Creating Formulas for Financial
                                                                                               Applications
                                                                                               Chapter 17
                                                                                               Introducing Array Formulas
                                                                                               Chapter 18
                                                                                               Performing Magic with Array
                                                                                               Formulas
   211   212   213   214   215   216   217   218   219   220   221