| PART ONE: LEARNING THE BASICS |
. |
| 1 Getting Started |
2 |
| An Overview of Workbooks |
6 |
| Entering Data |
6 |
| Entering Text |
7 |
| Entering Numbers as Text |
9 |
| Entering Values |
11 |
| Entering Dates and Times |
12 |
| Moving Around |
13 |
| Selecting Ranges |
14 |
| Giving Excel Instructions |
15 |
| Using Menus |
16 |
| Using Shortcut Menus |
19 |
| Using Toolbars |
20 |
| Saving Workbooks |
23 |
| Getting Help |
24 |
| Quitting Excel |
27 |
| 2 Editing and Formatting Worksheets |
28 |
| Opening Existing Workbooks |
30 |
| Editing Basics |
31 |
| Changing Entries |
31 |
| Copying Entries |
31 |
| Moving Entries |
33 |
| Inserting and Deleting Cells |
36 |
| Clearing Cells |
38 |
| Checking Spelling |
39 |
| Editing Workbooks |
39 |
| Inserting and Deleting Worksheets |
40 |
| Copying Worksheets |
40 |
| Naming Sheets |
41 |
| Moving Worksheets |
42 |
| Formatting Basics |
43 |
| Changing Character Formatting |
44 |
| Changing Alignment |
44 |
| Changing Column Widths |
45 |
| Wrapping Text in Cells |
46 |
| Adding Titles |
48 |
| Specifying How Values Should Be Displayed |
50 |
| Copying Formatting |
52 |
| Creating Templates |
54 |
| 3 Performing Calculations |
56 |
| Simple Calculations |
58 |
| Doing Arithmetic |
58 |
| Totaling Columns of Values |
60 |
| Using the AutoSum Button |
60 |
| Using the SUM Function |
61 |
| Referencing Formula Cells in Other Formulas |
62 |
| Naming Cells and Ranges |
62 |
| Creating a Calculation Area |
65 |
| More Calculations |
68 |
| Averaging Values |
68 |
| Identifying Highest and Lowest Values |
70 |
| Calculating with Names |
71 |
| Formulas That Make Decisions |
72 |
| Copying Formulas |
74 |
| Linking Worksheets with Formulas |
75 |
| Printing and Publishing Worksheets |
78 |
| Previewing Worksheets |
78 |
| Setting Up the Pages |
79 |
| Printing Worksheets |
82 |
| Publishing on an Intranet or the World Wide Web |
83 |
| PART TWO: BUILDING PROFICIENCY |
. |
| 4 Graphing Worksheet Data |
88 |
| Setting Up the Worksheet |
90 |
| Automatic Formatting |
91 |
| Plotting Graphs |
92 |
| Sizing and Moving Graphs |
96 |
| Updating Graphs |
96 |
| Changing the Graph Type |
97 |
| Using Graph Custom Types |
102 |
| Fine-Tuning Graphs |
103 |
| Adding and Formatting Text |
104 |
| Enhancing the Graph's Border |
107 |
| Adding Gridlines |
107 |
| Previewing and Printing Graphs |
108 |
| 5 Extracting Information from a List |
110 |
| Sorting Data |
113 |
| Adding Sort Codes |
114 |
| Using One Sort Column |
115 |
| Using Two Sort Columns |
116 |
| Using Three Sort Columns |
116 |
| Keeping Headings in View |
117 |
| List Basics |
118 |
| Finding Records |
120 |
| Adding and Deleting Records |
121 |
| Filtering Records |
122 |
| Customizing Filters |
123 |
| Summarizing Data |
126 |
| Consolidating Data |
126 |
| Creating Pivot Tables and Pivot Charts |
128 |
| Modifying a Pivot Table |
131 |
| Plotting the Pivot Table as a Pivot Chart |
133 |
| 6 More Advanced Calculations |
134 |
| Creating the Supporting Tables |
137 |
| Counting Entries |
140 |
| Creating an Estimate Worksheet |
141 |
| Looking Up Information |
142 |
| Completing the Estimate |
144 |
| Projecting Profit Margin with Iteration |
145 |
| What-If Analysis |
148 |
| Using Goal Seek to Find One Unknown Value |
148 |
| Using Data Tables to Calculate the Effects of One |
. |
| or Two Variables |
149 |
| Using Scenario Manager to Test Multiple Scenarios |
152 |
| Creating Scenarios |
153 |
| Changing Scenarios |
155 |
| Creating Scenario Reports |
156 |
