Microsoft® Office Excel® 2010: Level 1

 

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

 

 

Course Content

Lesson 1: Getting Started with Excel

Topic 1A: Identify the Elements of the Excel Interface

Topic 1B: Navigate and Select Cells in Worksheets

Topic 1C: Customize the Excel Interface

Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

Topic 2A: Create Formulas in a Worksheet

Topic 2B: Insert Functions in a Worksheet

Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

Topic 3A: Edit Worksheet Data

Topic 3B: Find and Replace Data

Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

Topic 4A: Apply Font Properties

Topic 4B: Add Borders and Colors to Cells

Topic 4C: Align Content in a Cell

Topic 4D: Apply Number Formatting

Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

Topic 5A: Manage Worksheets

Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Topic 6A: Define the Page Layout

Topic 6B: Print a Workbook