Excel 2010 Level 1

Prerequisites:

Delegates should be able to:

* Use a mouse
* Type and use a keyboard
* Navigate through Windows files and folders
* Work with Windows minimise, maximise, open and close

Course Description:

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

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.

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.

This course includes the following modules:

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