| QuickLook Guide |
ix |
| Finding Your Best Starting Point |
xiii |
| Using the Microsoft Excel 2000 Step by Step CD-ROM |
xix |
| Conventions and Features in This Book |
xxvii |
| PART 1 Getting Acquainted with Excel 2000 |
1 |
| Lesson 1 Working in the Excel Environment |
3 |
| Getting Started with Excel 2000 |
4 |
| Navigating Easily in a Workbook |
9 |
| Navigating Easily in a Worksheet |
11 |
| ntering Information |
15 |
| Changing and Correcting Information |
19 |
| One Step Further: Customizing Excel |
22 |
| Lesson 1 Quick Reference |
25 |
| Lesson 2 Setting Up a Worksheet |
29 |
| Setting Up a New Workbook |
30 |
| Setting Up an Invoice |
33 |
| Previewing the Invoice and Making Additional Adjustments |
36 |
| Adding Other Useful Features to an Invoice |
37 |
| Changing Cell Alignment and Wrapping |
39 |
| Printing an Invoice |
42 |
| One Step Further: Adding a Picture to the Workshee |
43 |
| Lesson 2 Quick Reference 45 |
. |
| Lesson 3 Adding Formulas |
49 |
| Opening an Existing Workbook Using its File Properties |
51 |
| Making Formulas Easier to Understand and Use |
53 |
| Entering Calculation Formulas |
55 |
| One Step Further: Displaying Special Messages on Invoices |
61 |
| Lesson 3 Quick Reference |
63 |
| Lesson 4 Dressing Up a Worksheet |
65 |
| Formatting Cells to Create a Professional Look |
66 |
| Using Styles |
69 |
| Formatting Numbers to Create a Professional Look |
72 |
| Adding Custom Headers and Footers |
75 |
| Changing Page Margins |
77 |
| Saving an Invoice as a Template |
78 |
| One Step Further: Editing a Template |
80 |
| Lesson 4 Quick Reference |
81 |
| Part 1 Review & Practice |
83 |
| PART 2 Organizing and Summarizing Your Data |
87 |
| Lesson 5 Consolidating Multiple Lists |
89 |
| Opening Groups of Workbooks |
90 |
| Viewing and Arranging Groups of Workbooks |
92 |
| Combining Groups of Workbooks |
94 |
| One Step Further: Creating a Year-to-Date Summary and Chart |
96 |
| Lesson 5 Quick Reference |
99 |
| Lesson 6 Filtering to Find Information |
101 |
| Locating a Set of Records by Filtering |
102 |
| Calculating Filtered Sets of Records |
106 |
| One Step Further: Adjusting Project Revenues |
111 |
| Lesson 6 Quick Reference |
113 |
| Lesson 7 Organizing Data by Sorting and Subtotaling |
115 |
| Sorting a List |
116 |
| Summarizing Data with Subtotals |
120 |
| Using the Outline Feature |
124 |
| Presenting the Customer List to Others |
126 |
| One Step Further: Adding a Macro to Your Workbook |
130 |
| Lesson 7 Quick Reference |
133 |
| Part 2 Review & Practice |
135 |
| PART 3 Presenting Data to Others |
139 |
| Lesson 8 Creating PivotTable Reports |
141 |
| Creating a Dynamic Summary with a PivotTable |
142 |
| Using Data from Other Programs |
148 |
| Changing the Data Displayed |
152 |
| Showing Cost by Category |
156 |
| Refreshing PivotTable Report Data |
158 |
| Showing Details of a Calculation |
158 |
| One Step Further: Creating Page Reports for Distribution to Individuals |
159 |
| Lesson 8 Quick Reference |
161 |
| Lesson 9 Using PivotChart Reports |
163 |
| Using an Embedded Chart to Graphically Convey Data |
164 |
| Creating Different PivotChart Reports |
168 |
| Creating a Custom Chart Format |
171 |
| Anticipating Data Trends and Relationships |
172 |
| One Step Further: Creating a Pie PivotChart Report |
174 |
| Lesson 9 Quick Reference |
177 |
| Lesson 10 Printing Worksheets and Charts |
181 |
| Printing a Multiple-Page Worksheet |
182 |
| Printing Selected Areas of a Worksheet |
188 |
| Printing Charts |
193 |
| One Step Further: Adding Headers and Footers to a Worksheet |
196 |
| Lesson 10 Quick Reference |
198 |
| Lesson 11 Distributing Information Online |
201 |
| Saving an Entire Workbook in HTML Format |
202 |
| Modifying a Web Page Using Excel |
205 |
| Publishing Worksheets Online |
206 |
| One Step Further: Creating a PivotTable List |
210 |
| Lesson 11 Quick Reference |
214 |
| Part 3 Review & Practice |
217 |
| PART 4 Analyzing Data and Sharing Your Work |
221 |
| Lesson 12 Comparing Alternative Scenarios |
223 |
| Determining Target Revenues |
224 |
| Creating Multiple Scenarios |
226 |
| Comparing Scenarios |
231 |
| One Step Further: Editing a Scenario |
232 |
| Lesson 12 Quick Reference |
233 |
| Lesson 13 Sharing a Workbook |
235 |
| Sharing a Workbook |
237 |
| Deciding Which Changes to Keep in a Workbook |
246 |
| One Step Further: Protecting a Workbook |
252 |
| Lesson 13 Quick Reference |
253 |
| Lesson 14 Integrating Microsoft Office Programs |
257 |
| Linking Information Between Programs |
258 |
| Embedding Information From One Program Into Another |
262 |
| Creating a Hyperlink Between Documents or Programs |
264 |
| Pasting an Excel Chart into Another Office Program |
266 |
| Converting a Worksheet into an Access Table |
268 |
| One Step Further: Filtering a List in a Microsoft Access Table |
270 |
| Lesson 14 Quick Reference |
270 |
| Part 4 Review & Practice |
273 |
| PART 5 Using Advanced Features of Excel 2000 |
277 |
| Lesson 15 Enhancing Worksheets |
279 |
| Making a Worksheet More Readable |
280 |
| Creating a Flowchart |
283 |
| One Step Further: Creating and Customizinga WordArt Logo |
291 |
| Lesson 15 Quick Reference |
293 |
| Lesson 16 Using Data from Other Sources |
295 |
| Validating Data from Other Sources |
296 |
| Retrieving Data from Workbooks |
301 |
| Retrieving Data from a Database |
304 |
| One Step Further: Retrieving a Filtered List from a Database |
308 |
| Lesson 16 Quick Reference |
310 |
| Lesson 17 Working With Macros |
313 |
| Locating and Viewing a Macro |
314 |
| Stepping Through a Macro |
317 |
| Modifying a Macro |
321 |
| Making Macros Easier to Use |
324 |
| One Step Further: Making a Macro Run Automatically |
330 |
| Lesson 17 Quick Reference |
332 |
| Lesson 18 Manipulating and Summarizing Lists |
337 |
| Sorting Data in a List |
338 |
| Subtotaling a List |
342 |
| Filtering a List |
344 |
| Selecting Random Rows |
346 |
| Extracting Data in a List |
347 |
| One Step Further: Customizing a Filter |
349 |
| Lesson 18 Quick Reference |
351 |
| Lesson 19 Customizing Charts and Creating Maps |
353 |
| Using the Chart Wizard |
354 |
| Creating a Gantt Chart |
358 |
| Creating an XY (Scatter) Chart |
363 |
| Creating a Bubble Chart |
365 |
| One Step Further: Creating Data Maps |
367 |
| Lesson 19 Quick Reference |
369 |
| Part 5 Review & Practice |
373 |
| Appendix A If You're New to Windows or Excel 2000 |
377 |
| If You're New to Windows |
377 |
| Getting Help with Windows |
384 |
| What Is Microsoft Excel 2000? |
393 |
| Appendix B Matching the Exercises |
395 |
| Installing Windows or Excel 2000 Components |
395 |
| Matching the Screen Display to the Illustrations |
396 |
| Changing Other Options |
399 |
| Index |
403 |
