Microsoft Excel: Quick Start

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Chapter 2: The Excel Interface

Lecture 1: Interface Introduction

Lecture 2: The Title Bar

Lecture 3: The File Command and Backstage View

Lecture 4: The Command Ribbon

Lecture 5: Command Icons

Lecture 6: The Name Box and Formula Bar

Lecture 7: The Workbook and Worksheets

Lecture 8: The Status Bar

Chapter 3: Entering and Changing Data

Lecture 1: Entering Data

Lecture 2: Changing Data

Lecture 3: Moving Data

Lecture 4: Copying Data

Lecture 5: Clearing Data

Lecture 6: Deleting Data

Lecture 7: Using Paste Special

Lecture 8: The AutoFill Feature

Lecture 9: Practice Exercise – Entering and Changing Data

Lecture 10: Practice Exercise Solution – Entering and Changing Data

Chapter 4: Formatting

Lecture 1: Fonts

Lecture 2: Borders

Lecture 3: The Format Painter

Lecture 4: Cell Alignment

Lecture 5: Number Formatting

Lecture 6: Wrapping Text

Lecture 7: Merging Cells

Lecture 8: Freezing Panes

Lecture 9: Practice Exercise – Formatting

Lecture 10: Practice Exercise Solution – Formatting

Chapter 5: Creating Formulas

Lecture 1: Formulas Introduction

Lecture 2: Cell References

Lecture 3: Using Operators

Lecture 4: Moving Formulas

Lecture 5: Cell Reference Types

Lecture 6: Copying Formulas

Lecture 7: Copying Formulas – More Examples

Lecture 8: Practice Exercise – Creating Formulas

Lecture 9: Practice Exercise Solution – Creating Formulas

Chapter 6: Working with Functions

Lecture 1: Functions Introduction

Lecture 2: The SUM Function

Lecture 3: Getting Function Help

Lecture 4: AutoSum Functions

Lecture 5: Counting Functions

Lecture 6: Common Text Functions

Lecture 7: Combining Functions

Lecture 8: Adding Functions to Product List

Lecture 9: Practice Exercise – Working with Functions

Lecture 10: Practice Exercise Solution – Working with Functions

Chapter 7: Designing Tables

Lecture 1: Tables Introduction

Lecture 2: Creating a Table

Lecture 3: Table Styles

Lecture 4: Table Style Options

Lecture 5: Table Totals

Lecture 6: Formulas in Tables

Lecture 7: Adding Rows and Columns

Lecture 8: Deleting Rows and Columns

Lecture 9: Row and Column Addition Shortcuts

Lecture 10: Practice Exercise – Designing Tables

Lecture 11: Practice Exercise Solution – Designing Tables

Chapter 8: Sorting Data

Lecture 1: Sorting Introduction

Lecture 2: Quick Sorts

Lecture 3: The Sort Command

Lecture 4: Multiple Column Sort

Lecture 5: Practice Exercise – Sorting Data

Lecture 6: Practice Exercise Solution – Sorting Data

Chapter 9: Filtering Data

Lecture 1: Filtering Introduction

Lecture 2: Applying Filters

Lecture 3: Number Filtering Options

Lecture 4: Text Filtering Options

Lecture 5: Multiple Column Filters

Lecture 6: Reapplying Filters

Lecture 7: Practice Exercise – Filtering Data

Lecture 8: Practice Exercise Solution – Filtering Data

Chapter 10: Using Multiple Worksheets

Lecture 1: Multiple Worksheets Introduction

Lecture 2: Adding Worksheets to a Workbook

Lecture 3: Grouping and Ungrouping Worksheets

Lecture 4: Adding Data to Multiple Worksheets

Lecture 5: Formatting Multiple Worksheets

Lecture 6: Adding Formulas to Multiple Worksheets

Lecture 7: Multiple Worksheet Formulas

Lecture 8: Practice Exercise – Using Multiple Worksheets