X210L1
Microsoft Office Excel 2010 Foundations
Course Duration: 1 Day
Class Time: 9 am - 4:30 pm

LESSON 1 – Getting Started

  • Understanding Spreadsheet Terminology
  • Working in The Excel Environment
  • Getting Help
  • Navigating a Worksheet

LESSON 2 – Entering and Editing Data

  • Entering and Editing Text and Values
  • Entering and Editing Formulas
  • Working with Pictures
  • Saving and Updating Workbooks

LESSON 3 – Modifying a Worksheet

  • Moving and Copying Data
  • Moving and Copying Formulas
  • Using Absolute and Relative References
  • Inserting and Deleting Ranges, Rows, and Columns

LESSON 4 – Functions

  • Entering Functions
  • Using AutoSum
  • Employing Common Functions

LESSON 5 – Formatting

  • Using Text Formatting
  • Using Row and Column Formatting
  • Understanding Number Formatting
  • Employing Conditional Formatting
  • Working with Additional Formatting Options

LESSON 6 – Printing

  • Preparing to Print
  • Understanding Page Setup Options
  • Printing Worksheets

LESSON 7 – Charts

  • Understanding Chart Basics
  • Formatting Charts

LESSON 8 – Managing Large Workbooks

  • Viewing Large Worksheets
  • Printing Large Worksheets
  • Working with Multiple Worksheets