Excel 2007 Advanced - Half Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this training class, students will be able to:

  • Create macros to automate tasks
  • Collaborate with others using workbooks
  • Audit worksheets
  • Analyze data
  • Import data

Course Content

Lesson 1: Streamlining Workflow

  1. Creating a Macro
  2. Editing a Macro
  3. Applying Conditional Formatting

Lesson 2: Collaborating with Others

  1. Protecting Worksheets
  2. Sharing a Workbook

Lesson 3: Auditing Worksheets

  1. Tracing Cell Precedents
  2. Tracing Cell Dependents
  3. Locating Errors in Formulas

Lesson 4: Analyzing Data

  1. Developing a PivotTable Report
  2. Developing a PivotChart Report

Lesson 5: Importing and Updating Data

  1. Importing Data from a File or Database
  2. Importing Data from a Web Page
  3. Updating Imported Data

If you would like to customize this training class, please contact us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!