Page 20 - Excel Workbook for Dummies

03_798452 intro.qxp 3/13/06 7:32 PM Page 3
Introduction 3
Part I: Creating Spreadsheets

This part contains the most exercises of any in the workbook. It is made up of four
chapters designed to give you practice in all the spreadsheet basics, all the way from
starting Excel to editing a completed spreadsheet:

Chapter 1 enables you to practice creating a new spreadsheet.
Chapter 2 runs you through formatting spreadsheet data.
Chapter 3 gives you training in all aspects of printing the completed spreadsheet.
Chapter 4 gives you plenty of experience with making modifications to the com-
pleted spreadsheet.

Part II: Using Formulas and Functions

This part gives you all the practice you need with creating and using formulas in the
spreadsheet. Chapter 5 introduces you to formula-making just as Chapter 6 introduces
you to the all-important topic of formula copying.

Because of the importance of Excel’s built-in functions in formula building, the remaining
seven chapters in this part concentrate on building formulas using a particular category
of functions:

Chapter 7 gets you up and running on date and time formulas.
Chapter 8 trains you in the use of financial formulas.
Chapter 9 gives you practice creating formulas using Excel’s Math functions.
Chapter 10 concentrates on exercises in creating formulas using Statistical
functions.
Chapter 11 introduces you to the creation of formulas using Lookup functions.
Chapter 12 runs you through the creation of formulas using the Logical func-
tions, the performance of which depends upon prevailing conditions in the
spreadsheet.
Chapter 13 introduces you to the creation of text formulas that manipulate and
change text entries in the spreadsheet.

Part III: Working with Graphics

This part takes you into the graphical aspects of Excel, the most important of which is
its rich and versatile charting capabilities covered in Chapter 14. In addition to charts,
in Chapter 15 you get practice in working with other types of graphics in the spread-
sheet, both those that you generate with the program’s own drawing tools and those
that you import from other sources such as clip art and digital photos.

Part IV: Managing and Securing Data

This part is concerned with the management and security of the vast amounts of data
that you accumulate in your worksheets. Chapter 16 gives you practice in creating,