Microsoft® Excel Level I Foundations

Length: 1 day
Software Version:  2007/2010
Prerequisites: Familiarity with the Windows operating system.

Course Objectives:

  • create a basic worksheet by using Microsoft Excel 2010.
  • perform calculations in an Excel worksheet.
  • modify an Excel worksheet.
  • modify the appearance of data within a worksheet.
  • manage Excel workbooks.
  • print the content of an Excel worksheet.

Lesson I:  Getting Started with Excel

Identify the Elements of the Excel Interface

Navigate and Select Cells in Worksheets

Customize the Excel Interface

Create a Basic Worksheet

 

Lesson 2:  Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet

Insert Functions in a Worksheet

Reuse Formulas

 

Lesson 3:  Modifying a Worksheet

Edit Worksheet Data

Find and Replace Data

Manipulate Worksheet Elements

 

Lesson 4:  Modifying the Appearance of a Worksheet

Apply Font Properties

Add Borders and Colors to Cells

Align Content in a Cell

Apply Number Formatting

Apply Cell Styles

 

Lesson 5:  Managing an Excel Workbook

Manage Worksheets

View Worksheets and Workbooks

 

Lesson 6: Printing Excel Workbooks

Define the Page Layout

Print a Workbook

Click here for course cost and dates