Page 11 - Excel Data Analysis

01 537547 FM.qxd 3/5/03 2:54 PM Page ix

Excel Data Analysis:
Your visual blueprint for creating and
analyzing data, charts, and PivotTables

4) CREATING FORMULAS

Sum Cells with the AutoSum Button ..............................................................................58
Add a Function via the Insert Function Dialog Box ......................................................60
Edit Formulas ......................................................................................................................62
Evaluate a Formula ............................................................................................................64
Using Solver to Produce Specific Values ........................................................................66
Create a Conditional Formula ..........................................................................................68
Solve a Formula with a Data Table ..................................................................................70
Trace a Formula Error ........................................................................................................72
Look Up a Value in a Specific Row and Column ............................................................74
Determine the Location of a Value ..................................................................................76
Return a Value at a Specific Location in a Data List ......................................................78
Rank a Value within a Data List ........................................................................................80
Create an Amortization Table for a Loan ........................................................................82

5) WORKING WITH EXTERNAL DATA

Link Data to Other Windows Programs ..........................................................................84
Import a Delimited Text File ............................................................................................86
Divide a Column into Multiple Columns ......................................................................90
Create a Web Query ..........................................................................................................92
Import a Database Table ..................................................................................................94
Using Queries to Screen External Databases ..................................................................96
Find the Average of a Database Range ..........................................................................102
Save For Web ....................................................................................................................104

6) CHARTING DATA

Chart Basics ......................................................................................................................106
Modify a Chart Type ........................................................................................................110
Explode Slices of a Pie Chart ..........................................................................................111
Create a Custom Chart Type ..........................................................................................112
Add a Trendline to a Chart ..............................................................................................114
Add or Change New Data to a Chart ............................................................................116
Create a Chart with Multiple Chart Types ....................................................................118

ix