You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.

Microsoft Excel

  • Home
  • Microsoft Excel

Microsoft Excel Topics

Videos, printable instructions, and downloadable files and templates to help you become better at using Microsoft Excel. These training resources were developed after years of classroom experience and use by Luther Maddy Ph.D, a Microsoft Office Master Instructor. Select a topic from the list below:

Excel - Intoduction and Basic Formula Creation
Excel - Working with Multiple Worksheets
Excel - Creating and Using Pivot Tables
Excel - Creating a Loan Amortization Schedule
Excel - Using filters and subtotaling
Excel - Using Database Functions
Excel - Using Nested If and Or statements
Sponsored Ads

Excel Intoduction and Basic Formula Creation

Back to topic list

This lesson covers beginning Excel and how to create basic formulas, including using Absolute Cell Addressing.

Youtube.Instructional Videos
Creating Basic Formulas and using the Sum and Average Functions Editing Formulas and using the absolute cell addressing in formulas
Excel Introduction - File Downloads

Microsoft Ecel: Time Saving shortcut keys

Calculators & Other Resources
Purchase Excel Basics Workbook

Spoonsored Ads

Excel Working with Multiple Worksheets

Back to topic list

This lesson covers creating, renaming, and grouping worksheets. It also explains how to use cells in another worksheet in formulas.

Instructional Videos
Excel - Using Multiple Worksheets
Calculators & Other Resources
Purchase Excel Beyond the Basics Workbook

Spoonsored Ads

Excel Pivot Tables

Back to topic list

This lesson covers creating and using Pivot tables.

Instructional Videos
Excel-Using Pivot Tables
Excel Pivot tables - File Downloads

Pay Survey with pay rate pivot table

Calculators & Other Resources
Purchase Excel Database & Statistical Features Workbook

Spoonsored Ads

Excel filters & subtotals

Back to topic list

This lesson covers using filters and subtotals.

Instructional Videos
Excel-filters and subtotals
Excel Filter and subtotals - File Downloads

MS Excel - Customer list for filters video

Calculators & Other Resources
Purchase Excel Database & Statistical Features Workbook

Spoonsored Ads

Using Database functions

Back to topic list

This lesson covers using filters and subtotals.

Instructional Videos
Excel-Database functions
Excel Database functions - File Downloads

MS Excel - Customer list for database functions

>MS Excel - Database functons example - complete

Calculators & Other Resources
Purchase Excel Database & Statistical Features Workbook

Spoonsored Ads

Using Nested If and Or Statements

Back to topic list

This video explains creating a complex formula using nested IF and OR statements.

Youtube.Instructional Videos
Creating complex formulas using nested IF and OR statements
Excel - File Downloads

Example file, nested IF and OR statements

Calculators & Other Resources
Purchase Excel Basics Workbook

Spoonsored Ads
413