Excel 2010 - Level 1

Course details

In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.

Objectives

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

Lessons

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