Microsoft Excel Introduction

Course Content

Lesson 1: Getting Started with Microsoft Excel

Topic 1A: Identify the Elements of the Excel Interface
Topic 1B: Create a Basic Worksheet
Topic 1C: Use the Help System

Lesson 2: Performing Calculations

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: Manipulate Data
Topic 3B: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic 3C: Search for and Replace Data
Topic 3D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
Topic 4C: Apply Number Formats
Topic 4D: Align Cell Contents
Topic 4E: Apply Cell Styles

Lesson 5: Printing Workbook Contents

Topic 5A: Define the Basic Page Layout for a Workbook
Topic 5B: Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets
Topic 6C: Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

Topic 7A: Customize General and Language Options
Topic 7B: Customize Formula Options
Topic 7C: Customize Proofing and Save Options
Topic 7D: Customize the Ribbon and Quick Access Toolbar
Topic 7E: Customize the Functionality of Excel by Enabling Add-Ins
Topic 7F: Customize Advanced and Trust Center Options