Excel 2007 Fundamentals - 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 and modify a worksheet
  • Perform calculations
  • Format a worksheet
  • Work with workbooks and worksheets
  • Print a workbook

Course Content

Lesson 1: Exploring the Excel 2007 Environment

  1. Ribbon Overview
  2. Quick Access Toolbar Overview
  3. Using the Office Button
  4. Working with Contextual Tabs

Lesson 2: Creating and Modifying a Worksheet

  1. Selecting Parts of a Worksheet
  2. Entering Data
  3. Saving a Workbook
  4. Filling Multiple Cells Based on an Initial Value
  5. Inserting and Deleting Cells, Columns and Rows

Lesson 3: Performing Calculations

  1. Doing Simple Calculations
  2. Inserting a Formula
  3. Inserting a Function
  4. Understanding Cell References
  5. Copying Formulas across Adjacent Cells
  6. Adding Absolute Cell References to Formulas

Lesson 4: Formatting a Worksheet

  1. Merging Cells
  2. Applying Number Formats
  3. Copying Formatting
  4. Understanding and Using Themes

Lesson 5: Workbooks and Worksheets

  1. Viewing Workbooks
  2. Viewing, Adding and Deleting Worksheets

Lesson 6: Printing Workbooks

  1. Creating Headers and Footers
  2. Inserting and Removing Page Breaks
  3. Setting a Print Range

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!