Microsoft Excel 2010 - Level 1

Overview

In this course, students will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Who Should Attend?

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

Course Outcome

Upon successful completion of this course, students will be able to:

- 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.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the
computer; and manage files and folders. 

It is recommended that delegates attend the following courses before attending the Microsoft Excel 2010 Level 1 course:

- Windows 2000 -Level 1
- Windows XP Professional - Installation and Administration

Course Outline

Lesson 1: 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 an Excel 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