Microsoft® Office Excel Level 1: Proficiency

This course is designed for students who wish to learn operations on Microsoft word to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex word features that enhance word application

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 an Excel 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