Excel 2000 Step by Step

Part III Presenting Data to Others

Lesson 8      Creating PivotTable Reports

Quick Reference: Pg. 161

  1. Creating a Dynamic Summary with a PivotTable
  2. Formatting a PivotTable
  3. Using Data from Other Programs
  4. Changing the Data Displayed
  5. Refreshing PivotTable Report Data
  6. Creating Page Reports for Distribution to Individuals

Lesson 9      Using PivotChart Reports

Quick Reference: Pg. 177

  1. Using an Embedded Chart to Graphically Convey Data
  2. Creating Different PivotChart Reports
  3. Creating a Custom Chart Format
  4. Anticipating Data Trends and Relationships
  5. Creating a Pie PivotChart Report

Lesson 10   Printing Worksheets and Charts

Quick Reference: Pg. 198

  1. Set Print titles for and print a multiple-page worksheet
  2. Preview page breaks and change the page layout
  3. Fit a multiple-page worksheet into a specific number of pages
  4. Set and clear print areas
  5. Print a worksheet and embedded chart
  6. Create a custom header and footer

Lesson 11   Distributing Information Online

Quick Reference: Pg. 214

  1. Save an entire workbook in HTML format
  2. View a workbook from a browser
  3. Edit a workbook from a browser
  4. Publish a worksheet on line
  5. Add interactivity to an online worksheet
  6. Create and use a PivotTable list

Review & Practice           Pg 217

Part IV Analyzing Data and Sharing Your Work

Lesson 12   Comparing Alternative Scenarios

Quick Reference: Pg. 233

  1. Determining Targets, using Goal Seek
  2. Creating Multiple Scenarios
  3. Comparing Scenarios
  4. Editing Scenarios

Lesson 13`  Sharing a Workbook

Quick Reference: Pg. 253

  1. Set up a shared workbook on a network
  2. Update and enter data in a shared workbook
  3. Distribute a shared workbook as an e-mail attachment
  4. Track changes made in a shared workbook
  5. Reconcile conflicting changes in a shared workbook
  6. Accept or reject revisions in a shared workbook
  7. Merge shared workbooks
  8. Protect a workbook with a password

Lesson 14   Integrating Microsoft Office Programs

Quick Reference: Pg. 270

  1. Linking Information Between Programs
  2. Embedding Information From One Program into Another
  3. Creating a Hyperlink Between Documents or Programs
  4. Pasting an Excel Chart into Another Office Program
  5. Converting a Worksheet into an Access Table
  6. Filtering a List in a Microsoft Access Table

Review & Practice           Pg 273