Page 249 - Excel Workbook for Dummies

25_798452 pt05.qxp 3/13/06 7:48 PM Page 232

In this part . . .

n being able to perform data analysis in your spread-
Isheets, you begin to tap into the real power of Excel.
Part V introduces you to data analysis in two forms:
what-if analysis, which enables you to test out different
possible outcomes based on different assumptions, and
pivot tables, which enable you to summarize large groups
of data based on varied criteria that you manipulate on
the fly as you will.