Explore What You'll Learn

7 Chapters · 49 Lessons

    1. Welcome & Let's Get Started! Free preview
    2. How to Proceed in this Course Free preview

    1. Module 1 Introduction Free preview
    2. (Included in full purchase)

      Lesson 1: Worksheets, Quick Access Toolbar, Alt Shortcuts

    3. (Included in full purchase)

      Lesson 2: Resize & Shortcuts

    4. (Included in full purchase)

      Lesson 3: Entering Data

    5. (Included in full purchase)

      Lesson 4: Basic Text Cleaning & Hiding

    6. (Included in full purchase)

      Lesson 5: Flash Fill

    7. (Included in full purchase)

      Bonus Lesson: Newer Features

    8. (Included in full purchase)

      Complete Your DRAFT of the Module 1 Assignment

    9. (Included in full purchase)

      Final Module 1 Assignment: Tutorial & Submission

    1. Module 2 Introduction Free preview
    2. (Included in full purchase)

      Lesson 1: Relative & Absolute Cell Referencing

    3. (Included in full purchase)

      Lesson 2: Mixed Absolute Cell Referencing

    4. (Included in full purchase)

      Lesson 3: Comparison, Logic, IF

    5. (Included in full purchase)

      Lesson 4: Nested IF & IFS

    6. (Included in full purchase)

      Lesson 5: Conditional IF(S)

    7. (Included in full purchase)

      Lesson 6: VLOOKUP

    8. (Included in full purchase)

      Lesson 7: XLOOKUP

    9. (Included in full purchase)

      Complete Your DRAFT of the Module 2 Assignment

    10. (Included in full purchase)

      Final Module 2 Assignment: Tutorial & Submission

    1. Module 3 Introduction Free preview
    2. (Included in full purchase)

      Lesson 1: Pivot Tables Overview

    3. (Included in full purchase)

      Lesson 2: Pivot Tables Part I

    4. (Included in full purchase)

      Lesson 3: Pivot Tables Part II

    5. (Included in full purchase)

      Lesson 4: Pivot Tables Part III

    6. (Included in full purchase)

      Lesson 5: Get Pivot Data

    7. (Included in full purchase)

      Lesson 6: Calculated Fields, Name Manager, SUM/AVERAGEIF

    8. (Included in full purchase)

      Complete Your DRAFT of the Module 3 Assignment

    9. (Included in full purchase)

      Final Module 3 Assignment: Tutorial & Submission

    1. Module 4 Introduction Free preview
    2. (Included in full purchase)

      Lesson 1: Data Validation Overview

    3. (Included in full purchase)

      Lesson 2: Data Validation Part II

    4. (Included in full purchase)

      Lesson 3: Conditional Formatting Introduction

    5. (Included in full purchase)

      Lesson 4: Conditional Formatting Referencing

    6. (Included in full purchase)

      Lesson 5: Conditional Formatting Advanced

    7. (Included in full purchase)

      Lesson 6: MS Excel Auditing

    8. (Included in full purchase)

      Complete Your DRAFT of the Module 4 Assignment

    9. (Included in full purchase)

      Final Module 4 Assignment: Tutorial & Submission

    1. Module 5 Introduction Free preview
    2. (Included in full purchase)

      Lesson 1: Goal Seek

    3. (Included in full purchase)

      Lesson 2: One Variable Data Table

    4. (Included in full purchase)

      Lesson 3: Two Variable Data Table

    5. (Included in full purchase)

      Lesson 4: Scenario Manager

    6. (Included in full purchase)

      Lesson 5: Putting It Together

    7. (Included in full purchase)

      Complete Your DRAFT of the Module 5 Assignment

    8. (Included in full purchase)

      Final Module 5 Assignment: Tutorial & Submission

    1. (Included in full purchase)

      Congratulations - You Did It!

    2. (Included in full purchase)

      Congratulations on completing Excel Mastery! End-of-Course Survey