Excel 2007 Fundamentals - Full 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 course, students will be able to:

  • Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbook contents
  • Manage large workbooks

Course Content

Lesson 1: Creating a Basic Worksheet

  1. Explore the User Interface and the Ribbon
  2. Navigate and Select in Excel
  3. Obtain Help
  4. Enter Data and Save a Workbookbook
  5. Customize the Quick Access Toolbar

Lesson 2: Performing Calculations

  1. Create Basic Formulas
  2. Calculate with Functions
  3. Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

  1. Manipulate Data
  2. Insert and Delete Cells, Columns, and Rows
  3. Search for Data in a Worksheet
  4. Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  1. Modify Fonts
  2. Add Borders and Color to Cells
  3. Change Column Width and Row Height
  4. Apply Number Formats
  5. Position Cell Contents
  6. Apply Cell Styles

Lesson 5: Printing Workbook Contents

  1. Print Workbook Contents Using Default Print Options
  2. Set Print Options
  3. Set Page Breaks

Lesson 6: Managing Large Workbooks

  1. Format Worksheet Tabs
  2. Manage Worksheets in a Workbook
  3. Manage the View of Large Worksheets

If you would like to customize this training clsas, 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!