Page 13 - Excel Data Analysis

01 537547 FM.qxd 3/4/03 11:43 AM Page xi

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

Run a Macro As a Workbook Opens ............................................................................190
Using an Excel Function in a Macro ..............................................................................192

10) FORM CONTROLS

An Introduction to Forms ..............................................................................................194
The Forms Toolbar ..........................................................................................................195
VBA Dialog Box Basics ....................................................................................................196
Add a Form Control to a Worksheet ............................................................................198
Specify Values for a Form Control ................................................................................200
Customize Form Controls with Macros ........................................................................202
Create a Custom Dialog Box ..........................................................................................204
Call a Custom Dialog Box from a Macro ......................................................................206
Capture Input from a Custom Dialog Box ....................................................................208
Validate Input from a Dialog Box ..................................................................................212

11) USING THE ANALYSIS TOOLPACK ADD-INS

Install Excel Add-ins ........................................................................................................214
Using the Conditional Sum Wizard ..............................................................................216
Analysis of Variance for Lists of Values (ANOVA) ........................................................220
Find the Correlation Between Two Sets of Data ..........................................................222
Determine the Covariance of Two Sets of Data ..........................................................224
Calculate Descriptive Statistics ......................................................................................226
Compare the Variances in Two Groups of Data ..........................................................228
Calculate a Moving Average ..........................................................................................230
Determine Rank and Percentile ....................................................................................232

APPENDIXES

Appendix A: Excel Keyboard Shortcuts ........................................................................234
Appendix B: Excel Function Quick Reference ..............................................................240
Appendix C: VBA and Excel Events Quick Reference ..................................................256
Appendix D: Formula Basics in Excel ............................................................................270
Appendix E: What's on the CD-ROM ............................................................................274

INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .280

xi