Page 9 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page viii
Technique 35: Outline and Subtotal Magic 191 Part VIII: Internet-Related Timesavers 301
Technique 36: Consolidating Data from Technique 50: Saving Worksheets
Different Worksheets 195 as Web Pages 303
Technique 37: Editing with Search & Replace Technique 51: Importing Web Data
and Spell Check 199 into the Worksheet 310
Technique 52: Using Hyperlinks to
Part VI: Tips for Printing, Sharing, Make Jumps in Workbooks 317
and Reviewing Workbooks 205
Technique 38: Spreadsheet Security 207 Part IX: The Scary (Or Fun) Stuff 323
Technique 39: Printing Tricks for Technique 53: Instant Lists in Excel 2003 325
Flawless Reports 219 Technique 54: Sharing Excel Workbooks
Technique 40: Sharing Data with Other and Lists with a SharePoint Web Site 330
Office Programs 230 Technique 55: Entering Data and

Technique 41: Sharing Workbooks Issuing Commands by Voice 337
on a Network 238 Technique 56: Sprucing Up Your
Technique 42: Sending Workbooks Out Spreadsheets with Graphics 342
for Review 247 Technique 57: Doing Automated
Table Lookups 349
Part VII: Streamlining Data Listing
Technique 58: Using Text Formulas
and Data Analysis 253 for Fun and Profit 355
Technique 43: Adding and Editing Data Lists
Technique 59: Creating Queries to Import
with the Data Form 255
Data from an External Database 358
Technique 44: Sorting Worksheet Data 261
Technique 60: Automating Repetitive Tasks
Technique 45: Quick and Easy Basic Data with Macros 365
List Filtering 267
Technique 61: Creating Custom Functions
Technique 46: More Data List Filtering to Use in Your Worksheets 374
plus Statistical Analysis 272
Index 379
Technique 47: Doing What-if Analysis
in a Snap with Data Tables 280
Technique 48: Easy What-if Analysis through
Scenarios and Goal Seeking 284
Technique 49: Summarizing Data with
Pivot Tables and Pivot Charts 291