Microsoft Excel 2000 Step by Step

Catapult, Inc., is a national software training company. Their classrooms provide instructor-led Performance-Based Training nationwide in open-enrollment classes as well as in private, dedicated classes at customer sites.

Contents QuickLook Guide ix Finding Your Best Starting Point xiii Finding the Best Starting Point for You xiii New Features in Microsoft Excel 2000 xv Corrections, Comments, and Help xvi Visit Our World Wide Web Site xvii Using the Microsoft Excel 2000 Step by Step CD-ROM xix Installing the Practice Files xx Using the Practice Files xxi Using the Multimedia Files xxv Uninstalling the Practice Files xxv Need Help with the Practice Files? xxvi 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 Entering 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 Worksheet 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 Customizing a 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