Page 15 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page xiv
xiv
Excel 2003 Timesaving Techniques For Dummies
Technique 51: Importing Web Data Technique 56: Sprucing Up Your
into the Worksheet 310 Spreadsheets with Graphics 342
Capturing Information for the Spreadsheet Jazz It Up with Clip Art 342
with Web Queries 310 Adding Images from Graphics Files 343
Importing XML Data into a Worksheet 313 Drawing Objects for the Spreadsheet 344
Technique 52: Using Hyperlinks to Drawing various shapes 345
Make Jumps in Workbooks 317 Using text boxes as callouts 346
Making a statement with WordArt 346
Adding Hyperlinks to a Worksheet 317
Drawing diagrams and organization charts 347
Following Links in a Worksheet 320
Technique 57: Doing Automated Table
Editing Links in a Worksheet 321
Lookups 349
Creating Hyperlinks for Custom Menus
and Toolbars 321 Looking Up a Single Table Value 349
Performing a vertical table lookup 350
Part IX: The Scary (Or Fun) Stuff 323 Performing a horizontal lookup 351
Technique 53: Instant Lists in Excel 2003 325 Doing a Two-Way Lookup in a Data Table 352
Creating an Excel 2003 List 325 Technique 58: Using Text Formulas
Converting an existing list into an Excel list 326 for Fun and Profit 355
Creating an Excel list from scratch 327 Getting Right on the Case 355
Sorting and Filtering the List 327
Joining Separate Text Entries Together 356
Toggling the List’s Total Row On and Off 328
Replacing Text Formulas with Their Results 357
Easy List Editing 328
Technique 59: Creating Queries to Import
Inserting or deleting rows and columns 329
Converting a list back into a regular cell range 329 Data from an External Database 358
Deleting a list 329 Setting Up the Data Source Definition 358
Technique 54: Sharing Excel Workbooks Creating the Database Query 360
and Lists with a SharePoint Web Site 330 Technique 60: Automating Repetitive
Adding Excel Spreadsheets to Tasks with Macros 365
the SharePoint Site 330
Recording and Playing Back Macros 365
Opening the spreadsheets on Recording the macro 366
the SharePoint site 332
Playing back the macro 368
Adding a list of your spreadsheets to Editing Macros in the Visual Basic Editor 369
SharePoint site home page 333
Modifying the settings for VBA properties 370
Publishing Lists to the SharePoint Site 334
Getting user input by adding a custom
Publishing an Excel list on a SharePoint site 334
dialog box 371
Synchronizing list data 336
Technique 61: Creating Custom Functions
Technique 55: Entering Data and Issuing
Commands by Voice 337 to Use in Your Worksheets 374
Creating Custom Functions 374
Hands-Free Data Entry 337
Saving Custom Functions in an Excel Add-in 376
Just Tell Me What to Do 339
Choosing menu items, dialog box options, Index 379
and toolbar buttons 340
Telling the cell pointer “where to go” 340