MS Excel Introduction

Course Content

Lesson 1: Getting Started

1. Starting Excel
2. Opening a Workbook
3. Understanding the Display Screen
4. Working with the Ribbon
5. Exploring the File Tab
6. Working with the Quick Access Toolbar
7. Switching Between Opened Workbooks
8. Using Excel Help

Lesson 2: Entering Data

1. Moving the Cell Pointer
2. Selecting a Range of Cells
3. Creating a New Workbook
4. Inserting, Renaming, and Deleting Worksheets
5. Entering Constant Values
6. Using Auto Fill to Enter Data
7. Saving a Workbook
8. Editing Cell Contents
9. Clearing Cell Contents
10. Working with Undo and Redo
11. Closing a Workbook

Lesson 3: Using Formulas

1. Entering Formulas
2. Using Auto Fill with Formulas
3. Using the SUM Function
4. Summing Columns or Rows Automatically
5. Using Statistical Functions
6. Working with the Range Finder
7. Using Formula Error Checking

Lesson 4: Working with Constant Values and Formulas

1. Copying and Pasting Constant Values and Formulas
2. Cutting and Pasting Constant Values and Formulas

Lesson 5: Formatting Worksheets

1. Formatting Numbers
2. Changing the Font Format
3. Aligning Cell Contents
4. Applying Cell Styles

Lesson 6: Modifying Columns and Rows

1. Changing Column & Row Width
2. Inserting and Deleting Columns or Rows

Lesson 7: Editing Workbooks

1. Working with AutoCorrect
2. Checking Spelling
3. Using Find and Replace

Lesson 8: Printing Worksheets

1. Using Print Preview & Working with Print Settings
2. Using Page Setup Tools
3. Working in Page Layout View
4. Using Page Break Preview & Printing a Worksheet