Excel 2007 Intermediate - 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


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

  • Create and modify charts
  • Calculate with advanced formulas
  • Sort and filter data

Course Content

Lesson 1: Working with Charts

  1. Creating and Customizing a Chart
  2. Selecting Data for a Pie Chart
  3. Change the Chart Type
  4. Creating a Combination Chart

Lesson 2: Calculating with Advanced Formulas

  1. Naming Cells
  2. Sharing Data between Worksheets
  3. Calculating Across Worksheets
  4. Calculating with Date Functions
  5. Calculating with Financial Functions
  6. Calculating with Lookup and Reference Functions
  7. Calculate with Logical Functions

Lesson 3: Working with Data Lists

  1. Creating a Simple Data List
  2. Using a Form to Add Records

Lesson 4: Sorting and Filtering Data

  1. Sorting a List
  2. Using AutoFilter to Display Specific Records
  3. Creating Advanced Filters
  4. Adding Subtotals to a Worksheet

Lesson 5: Customizing the Excel Window

  1. Splitting a Worksheet
  2. Freezing Panes

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!