Microsoft Office Excel 2010: Intermediate

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: Instructor Introduction

Lecture 3: Instructor Introduction A

Chapter 2: Unit 01 – Using Multiple Worksheets and Workbooks

Lecture 1: Using Multiple Worksheets and Workbooks

Lecture 2: Topic A: Using Multiple Workbooks

Lecture 3: Switch Between Workbooks

Lecture 4: Demo – A-1: Switching Between Workbooks

Lecture 5: The Move or Copy Dialog Box

Lecture 6: Demo – A-2: Copying a Worksheet to Another Workbook

Lecture 7: Topic B: Linking Worksheets with 3-D Formulas

Lecture 8: Inserting a 3-D Reference

Lecture 9: Demo – B-1: Creating 3-D Formulas

Lecture 10: Adding a Watch Window

Lecture 11: Demo – B-2: Adding a Watch Window

Lecture 12: Topic C: Linking Workbooks

Lecture 13: Demo – C-1: Examining External Links in a Worksheet

Lecture 14: Syntax for External Links

Lecture 15: Creating External Links

Lecture 16: Demo – C-2: Creating External Links in a Worksheet

Lecture 17: Redirecting Links

Lecture 18: Demo – C-3: Editing Links

Lecture 19: Topic D: Managing Workbooks

Lecture 20: Creating a Workspace

Lecture 21: Demo – D-1: Creating a Workspace

Lecture 22: Unit 01 Review

Chapter 3: Unit 02 – Advanced Formatting

Lecture 1: Advanced Formatting

Lecture 2: Topic A: Using Special Number Formats

Lecture 3: The Format Cells, Number Tab

Lecture 4: Demo – A-1: Applying Special Formats

Lecture 5: Hiding Zero Values

Lecture 6: Demo – A-2: Controlling the Display of Zero Values

Lecture 7: Customizing Number Formats

Lecture 8: Custom Number Formats

Lecture 9: Demo – A-3: Creating Custom Formats

Lecture 10: Topic B: Using Functions to Format Text

Lecture 11: Text Functions

Lecture 12: Demo – B-1: Using PROPER, UPPER, and LOWER

Lecture 13: The SUBSTITUTE Function

Lecture 14: Demo – B-2: Using SUBSTITUTE

Lecture 15: Topic C: Working with Styles

Lecture 16: The Cell Styles Gallery

Lecture 17: Creating Styles

Lecture 18: Demo – C-1: Creating and Applying Styles

Lecture 19: Modifying Styles

Lecture 20: Demo – C-2: Modifying Styles

Lecture 21: Topic D: Working with Themes

Lecture 22: Theme Colors

Lecture 23: Demo – D-1: Changing to a Different Theme

Lecture 24: Creating New Theme Colors

Lecture 25: Topic E: Other Advanced Formatting

Lecture 26: Merging Cells

Lecture 27: Wrap Text in a Cell

Lecture 28: Changing Orientation of Text

Lecture 29: Demo – E-1: Merging Cells

Lecture 30: Demo – E-2: Changing the Orientation of Text in a Cell

Lecture 31: Demo – E-3: Splitting Cells

Lecture 32: Transposing Data

Lecture 33: Demo – E-4: Transposing Data During a Paste

Lecture 34: Use Paste Special to Add Values

Lecture 35: Demo – E-5: Using Paste Special to Add Values

Lecture 36: Adding Backgrounds

Lecture 37: Demo – E-6: Adding and Deleting Backgrounds

Lecture 38: Adding a Watermark

Lecture 39: Demo – E-7: Adding a Watermark

Lecture 40: Unit 02 Review

Chapter 4: Unit 03 – Outlining and Subtotals

Lecture 1: Outlining and Subtotals

Lecture 2: Topic A: Outlining and Consolidating Data

Lecture 3: The Expanded Outline Form

Lecture 4: The Collapsed Outline Form

Lecture 5: Demo – A-1: Creating an Outline

Lecture 6: Create a Custom View

Lecture 7: Switch Among Custom Views

Lecture 8: Demo – A-2: Creating Custom Views

Lecture 9: The Consolidate Dialog Box

Lecture 10: Demo – A-3: Using the Consolidate Command

Lecture 11: Topic B: Creating Subtotals

Lecture 12: The Subtotal Dialog Box

Lecture 13: Demo – B-1: Creating Subtotals in a List

Lecture 14: Demo – B-2: Using Multiple Subtotal Functions

Lecture 15: Unit 03 Review

Chapter 5: Unit 04 – Cell and Range Names

Lecture 1: Cell and Range Names

Lecture 2: Topic A: Creating and Using Names

Lecture 3: Defining Names

Lecture 4: Demo – A-1: Naming and Selecting Ranges

Lecture 5: Using Names in Formulas

Lecture 6: Demo – A-2: Using Names in Formulas

Lecture 7: Using Create from Selection

Lecture 8: Demo – A-3: Using the Create from Selection Command

Lecture 9: Applying Names

Lecture 10: Demo – A-4: Applying Names to Existing Formulas

Lecture 11: Topic B: Managing Names

Lecture 12: The Name Manager Dialog Box