Page 10 - Excel Data Analysis

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

TABLE OF CONTENTS

HOW TO USE THIS BOOK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .XII

1) GETTING STARTED WITH EXCEL

Excel Data Analysis Options ..............................................................................................2
Excel Data Types ..................................................................................................................4
Locate a Value in a Worksheet ..........................................................................................6
Select a Range of Cells ........................................................................................................7
Name a Range ......................................................................................................................8
Create Label Ranges ..........................................................................................................10
Modify Named Ranges ......................................................................................................12
Copy and Paste a Range of Cells ......................................................................................14
Create a Custom Number Format ..................................................................................16
Apply AutoFormat to a Worksheet ..................................................................................18
Create a Named Style ......................................................................................................20
Create a Custom Template ..............................................................................................22
Protect Worksheets ............................................................................................................24

2) ORGANIZE WORKSHEET DATA

Create a List ........................................................................................................................26
Add a Series to a List ........................................................................................................28
Sort a List ............................................................................................................................30
Create a Custom Sort ........................................................................................................32
Consolidate Data ..............................................................................................................36
Outline Your Data ..............................................................................................................40

3) EVALUATE WORKSHEET DATA

Apply Conditional Formatting ..........................................................................................42
Summarize Data with Subtotals ......................................................................................46
Filter a List ..........................................................................................................................48
Create a Custom Filter ......................................................................................................50
Create an Advanced Filter ................................................................................................52
Create Scenarios ................................................................................................................54
Validate Data ......................................................................................................................56

viii