xxx
Contents
Floating point number errors ..................................................................................659
“Phantom link” errors ..............................................................................................660
Using Excel Auditing Tools ...............................................................................................661
Identifying cells of a particular type .........................................................................661
Viewing formulas ....................................................................................................662
Tracing cell relationships .........................................................................................663
Identifying precedents ...................................................................................664
Identifying dependents ..................................................................................665
Tracing error values ................................................................................................665
Fixing circular reference errors ................................................................................665
Using background error-checking feature ...............................................................665
Using the Excel Formula Evaluator .........................................................................667
Searching and Replacing ...................................................................................................668
Searching for information ........................................................................................669
Replacing information .............................................................................................670
Searching for formatting ..........................................................................................670
Spell Checking Your Worksheets ......................................................................................671
Using AutoCorrect ............................................................................................................672Part V: Analyzing Data with Excel 675
Chapter 33: Getting Data from External Database Files . . . . . . . . . . . . . . 677
Understanding External Database Files .............................................................................677
Importing Access Tables ...................................................................................................679
Retrieving Data with Query: An Example ..........................................................................680
The database file......................................................................................................681
The task ..................................................................................................................681
Selecting a data source ............................................................................................682
Using the Query Wizard..........................................................................................684
Query Wizard: Choosing the columns ...........................................................684
Query Wizard: Filtering data .........................................................................685
Query Wizard: Sort order ..............................................................................686
Query Wizard: Finish ....................................................................................686
Specifying a location for the data .............................................................................687
Working with Data Returned by Query .............................................................................688
Adjusting the external data range properties ............................................................688
Refreshing a query ...................................................................................................689
Deleting a query ......................................................................................................690
Changing your query ..............................................................................................690
Using Query without the Wizard ......................................................................................690
Creating a query manually ......................................................................................690
Using multiple database tables ................................................................................69202_474877-ftoc.indd xxx02_474877-ftoc.indd xxx 3/29/10 11:34 PM3/29/10 11:34 PM