Excel 2010 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 course, 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 2010 Environment

  1. Ribbon Overview
  2. Quick Access Toolbar Overview
  3. Customizing the Ribbon and Quick Access Toolbar
  4. Using the Backstage View
  5. 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. Working with AutoFill
  5. Inserting and Deleting Cells, Columns and Rows

Lesson 3: Performing Calculations

  1. Doing Simple Calculations
  2. Inserting a Formula
  3. Frequently Used Functions
  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. Using 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!