Course duration: 1 Day

Course Description

You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Target Student:

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.

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.

Objectives

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

• create a basic worksheet by using Microsoft Office Excel 2010.
• perform calculations in an Excel worksheet.
• modify an Excel worksheet.
• format a worksheet.
• print the content of an Excel workbook.
• manage an Excel workbook.

Course Content

Creating a Basic Excel Worksheet
Identify the Elements of the User Interface
Customize the Excel Interface
Work with Cells
Enter Data in an Excel Workbook
Obtain Help in Excel
Performing Calculations in an Excel Worksheet
Create Basic Formulas
Calculate the Cell Values by Using Functions
Copy Formulas and Functions
Modifying an Excel Worksheet
Manipulate Data
Modify the Worksheet Elements
Search for Data in a Worksheet
Modify Rows and Columns
Formatting an Excel Worksheet
Modify Fonts
Check a Worksheet for Spelling Errors
Apply Number Formatting
Add Borders and Colours to Cells
Align the Content in a Cell
Apply Cell Styles
Printing Excel Workbooks
Set the Page Layout Options
Set Page Breaks
Print a Workbook
Managing an Excel Workbook
Format Worksheet Tabs
Manage Worksheets
View Worksheets and Workbooks