Page 15 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page xii
xii Excel Workbook For Dummies
Part IV: Managing and Securing Data ........................................201

Chapter 16: Building and Maintaining Data Lists.........................................................203
Creating a Data List................................................................................................................203
Sorting Lists............................................................................................................................207
Using sorting keys........................................................................................................207
Sorting on more than three keys................................................................................209
Sorting the fields (columns) in a data list.................................................................209
Subtotaling a List ...................................................................................................................211
Filtering a List.........................................................................................................................213
Querying External Database Tables.....................................................................................216
Chapter 17: Protecting the Spreadsheet.........................................................................221
Password-Protecting the Workbook ....................................................................................221
Protecting the Worksheet .....................................................................................................224
Doing Data Entry in a Protected Worksheet.......................................................................227
Protecting the Entire Workbook...........................................................................................228

Part V: Doing Data Analysis ......................................................231

Chapter 18: Performing What-If Analysis.......................................................................233
Using Data Tables...................................................................................................................233
Creating single-variable data tables...........................................................................233
Creating two-variable data tables ..............................................................................236
Exploring Various Scenarios.................................................................................................238
Performing Goal Seeking.......................................................................................................240
Creating Complex Models with Solver ................................................................................241
Chapter 19: Generating Pivot Tables...............................................................................245
Understanding Pivot Tables..................................................................................................245
Creating Pivot Tables.............................................................................................................247
Modifying the Pivot Table.....................................................................................................250
Modifying the table formatting...................................................................................250
Pivoting the table’s fields ............................................................................................251
Changing the table summary function and adding calculated fields ....................252
Creating Pivot Charts ............................................................................................................254

Part VI: Excel and the Web ........................................................259

Chapter 20: Publishing Spreadsheets as Web Pages..................................................261

Saving Worksheets as Web Pages ........................................................................................261
Creating static Web pages...........................................................................................262
Creating interactive Web pages..................................................................................263
Web pages with interactive data tables.....................................................................264
Web pages with interactive data lists........................................................................266
Web pages with interactive pivot tables ...................................................................267
Web pages with interactive charts.............................................................................268
Exporting an interactive Web page to Excel .............................................................269
Doing a Web Query ................................................................................................................270