Microsoft® Office Excel® 2003 Step by Step

Table of contents

1. Microsoft® Office Excel 2003: Step by Step
   1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
   2. A Note Regarding Supplemental Files
   3. What’s New in Microsoft Excel 2003
   4. Getting Help
      1. Getting Help with This Book and Its CD-ROM
      2. Getting Help with Microsoft Excel 2003
   5. Using the Book’s CD-ROM
      1. Minimum System Requirements
      2. Installing the Practice Files
      3. Using the Practice Files
      4. Uninstalling the Practice Files
   6. Conventions and Features
   7. Microsoft Office Specialist Skills Standards
      1. Microsoft Office Specialist Skill Standards
      2. Microsoft Office Specialist Expert Skill Standards
   8. Taking a Microsoft Office Specialist Certification Exam
      1. About the Microsoft Office Specialist Program
         1. What Does This Logo Mean?
      2. Selecting a Microsoft Office Specialist Certification Level
      3. Microsoft Office Specialist Skills Standards
      4. The Exam Experience
         1. The Exam Interface and Controls
      5. Test-Taking Tips
         1. Certification
         2. College Credit Recommendation
      6. For More Information
   9. Quick Reference
      1. Chapter 1 Getting to Know Excel
      2. Chapter 2 Setting Up a Workbook
      3. Chapter 3 Performing Calculations on Data
      4. Chapter 4 Changing Document Appearance
      5. Chapter 5 Focusing on Specific Data Using Filters
      6. Chapter 6 Combining Data from Multiple Sources
      7. Chapter 7 Reordering and Summarizing Data
      8. Chapter 8 Analyzing Alternative Data Sets
      9. Chapter 9 Creating Dynamic Lists with PivotTables
      10. Chapter 10 Creating Charts
      11. Chapter 11 Printing
      12. Chapter 12 Automating Repetitive Tasks with Macros
      13. Chapter 13 Working with Other Microsoft Office Programs
      14. Chapter 14 Working with Database Data
      15. Chapter 15 Publishing Information on the Web
      16. Chapter 16 Collaborating with Colleagues
   10. 1. Getting to Know Excel
       1. Introducing Excel
       2. Working with an Existing Data List
       3. Zeroing In on Data in a List
       4. Creating a Workbook
       5. Checking and Correcting Data
          1. Key Points
   11. 2. Setting Up a Workbook
       1. Making Workbooks Easier to Work With
       2. Making Data Easier to Read
       3. Adding a Graphic to a Document
          1. Key Points
   12. 3. Performing Calculations on Data
       1. Naming Groups of Data
       2. Creating Formulas to Calculate Values
       3. Finding and Correcting Errors in Calculations
          1. Key Points
   13. 4. Changing Document Appearance
       1. Changing the Appearance of Data
       2. Applying an Existing Format to Data
       3. Making Numbers Easier to Read
       4. Changing Data’s Appearance Based on Its Value
       5. Making Printouts Easier to Follow
       6. Positioning Data on a Printout
          1. Key Points
   14. 5. Focusing on Specific Data Using Filters
       1. Limiting the Data That Appears on the Screen
       2. Performing Calculations on Filtered Data
       3. Defining a Valid Set of Values for a Range of Cells
          1. Key Points
   15. 6. Combining Data from Multiple Sources
       1. Using a Data List as a Template for Other Lists
       2. Working with More Than One Set of Data
       3. Linking to Data in Other Workbooks
       4. Summarizing Multiple Sets of Data
       5. Grouping Multiple Data Lists
          1. Key Points
   16. 7. Reordering and Summarizing Data
       1. Sorting a Data List
       2. Organizing Data into Levels
          1. Key Points
   17. 8. Analyzing Alternative Data Sets
       1. Defining and Editing Alternative Data Sets
       2. Defining Multiple Alternative Data Sets
       3. Varying Your Data to Get a Desired Result
       4. Finding Optimal Solutions with Solver
       5. Analyzing Data with Descriptive Statistics
          1. Key Points
   18. 9. Creating Dynamic Lists with PivotTables
       1. Creating Dynamic Lists with PivotTables
       2. Editing PivotTables
       3. Creating PivotTables from External Data
          1. Key Points
   19. 10. Creating Charts
       1. Creating a Chart
       2. Customizing Chart Labels and Numbers
       3. Finding Trends in Your Data
       4. Creating a Dynamic Chart Using PivotCharts
       5. Creating Diagrams
          1. Key Points
   20. 11. Printing
       1. Printing Data Lists
          1. Preview a Worksheet Before Printing
          2. Change Your Printer Setup
          3. Zoom in on Part of a Page
          4. Change the Page Breaks in a Worksheet
          5. Change the Page Printing Order for a Worksheet
          6. Suppress Errors in a Worksheet
          7. Print Nonadjacent Sheets from a Workbook
       2. Printing Part of a Data List
       3. Printing a Chart
          1. Key Points
   21. 12. Automating Repetitive Tasks with Macros
       1. Introducing Macros
       2. Creating and Modifying Macros
       3. Creating a Toolbar to Hold Macros
       4. Creating a Menu to Hold Macros
       5. Running a Macro When a Workbook Is Opened
          1. Key Points
   22. 13. Working with Other Microsoft Office Programs
       1. Including an Office Document in an Excel Worksheet
       2. Storing an Excel Document as Part of Another Office Document
       3. Creating a Hyperlink
       4. Pasting a Chart into Another Document
          1. Key Points
   23. 14. Working with Database Data
       1. Looking Up Information in a Data List
       2. Retrieving Data from a Database
       3. Summarizing List Data
          1. Key Points
   24. 15. Publishing Information on the Web
       1. Saving a Workbook for the Web
       2. Publishing Worksheets on the Web
       3. Publishing a PivotTable on the Web
       4. Retrieving Data from the Web
       5. Acquiring Web Data with Smart Tags
       6. Working with Structured Data
       7. Use Professional XML Data Capabilities
          1. Key Points
   25. 16. Collaborating with Colleagues
       1. Sharing a Data List
       2. Managing Comments
       3. Tracking and Managing Colleagues’ Changes
       4. Identifying Which Revisions to Keep
       5. Protecting Workbooks and Worksheets
       6. Authenticate Workbooks
          1. Key Points
   26. Glossary
   27. Index
   28. SPECIAL OFFER: Upgrade this ebook with O’Reilly