Page 15 - Excel Data Analysis

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

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

The first chapter, "Getting Started," introduces you to In Chapter 9, you learn how to use VBA to create macros.
various data analysis options. You learn how to select a In Chapter 10, you find out all about forms and form
range of cells, how to use named ranges, label ranges, and controls, and in Chapter 11, you learn all the many useful
styles, as well as how to create a custom template. Add-ins that Excel provides.
Chapter 2, "Organize Worksheet Data," shows you how to The five appendices include Keyboard Shortcuts, an Excel
create Excel lists. In this chapter, you learn how to create, Function reference, a VBA Quick Reference, and a section
add, sort, customize and consolidate your data. on formulas for those not familiar with Excel.
Chapter 3, "Evaluate Data," helps you learn how to apply
conditional formatting, and filters. It also includes tasks on
validating data and creating scenarios. What's on the CD-ROM
The fourth chapter, "Creating Formulas," builds simple and The CD-ROM included in this book contains the sample
complex formulas with the insert function dialog box. It files for the book as well as trial versions of FinOptions
also shows you how to use the Solver, and create a XL 2.0, Sigma XL 1.1, UNISTAT 5.5, and 4TOPS Data that
conditional formula. you can use to work with Excel Data Analysis: Your visual
blueprint for creating and analyzing data, charts, and
In Chapter 5, you learn all about external data, including PivotTables. An e-version of the book is also available on
how to properly copy and import it, as well as how to work the disc.
with database queries and the DAVERAGE feature.
Chapters 6 through 8 show you how to optimize the
presentation of your data with charts, PivotTables, and
PivotCharts.

xiii