Page 21 - Excel Workbook for Dummies

03_798452 intro.qxp 3/13/06 7:32 PM Page 4
4 Excel Workbook For Dummies
maintaining, sorting, and querying database tables and data lists in the worksheet.
Chapter 17, on the other hand, gives you practice using Excel’s various methods for
protecting your data and worksheets from illicit viewing and unwanted changes.

Part V: Doing Data Analysis

This part takes you to the next step of using the Excel spreadsheet by introducing you
to two different kinds of data analysis. Chapter 18 gives you practice in doing various
types of what-if analysis that enable you to look at different potential outcomes in the
spreadsheet. Chapter 19 concentrates on training you in the use of pivot tables, a
dynamic type of data table that you can use to summarize vast amounts of data.

Part VI: Excel and the Web

This part gives you experience with Excel’s Web capabilities in two forms. Chapter 20
gives you experience converting Excel spreadsheets to Web pages, both in static and
dynamic formats. Chapter 21 trains you in the use of hyperlinks in spreadsheets that
connect you to different sheets in the same workbook, different documents on the same
computer, as well as to different pages and e-mail addresses on the World Wide Web.

Part VII: Macros and Visual Basic

for Applications

This part introduces you to the topic of creating and using macros to both streamline
and customize your work in Excel. Chapter 22 introduces you to recording your
actions as Excel macros and then playing them back in the worksheet. Chapter 23
gives you practice using Excel’s Visual Basic Editor to edit macros and extend macros
you’ve recorded as well as to create your own user-defined functions.

Part VIII: The Part of Tens

This part gives you tips for using Excel on your own after you complete the exercises
in this workbook. Chapter 24 is full of tips on using some of the many features you’ve
practiced using in the workbook like a professional. Chapters 25 through 28 are full of
various and sundry keystroke shortcuts designed to save you keyboard enthusiasts
out there all sorts of time as you work in Excel.

Using the Practice Material on the CD-ROM

The CD-ROM that comes with this workbook is an integral part of the workbook experi-
ence. It contains not only the practice material that you need to complete most of its
exercises but lots of third-party utilities that you may be able to put to good use as you
start to work with Excel on your own.

All the practice material for the book is located in a single Excel Workbook folder on the
CD-ROM. This Excel Workbook folder contains 22 chapter folders (Chapter 1 through
Chapter 21 and Chapter 23 — the exercises in Chapter 22 don’t require any practice files),
plus a Templates folder.