Explore What You'll Learn

7 Chapters · 48 Lessons

    1. (Included in full purchase)

      Welcome & Let's Get Started!

    2. (Included in full purchase)

      How to Proceed in this Course

    1. (Included in full purchase)

      Module 1 Introduction

    2. (Included in full purchase)

      Lesson 1: Import Text Files

    3. (Included in full purchase)

      Lesson 2: Import Folder with Text Files

    4. (Included in full purchase)

      Lesson 3: Import CSV Files

    5. (Included in full purchase)

      Lesson 4: Import Folder of CSV Files

    6. (Included in full purchase)

      Lesson 5: Import Data from Websites

    7. (Included in full purchase)

      Complete Your DRAFT of the Module 1 Assignment

    8. (Included in full purchase)

      Final Module 1 Assignment: Tutorial & Submission

    1. (Included in full purchase)

      Module 2 Introduction

    2. (Included in full purchase)

      Lesson 1: Clean and Reshape Sales Data

    3. (Included in full purchase)

      Lesson 2: Reshape Financial Statements

    4. (Included in full purchase)

      Lesson 3: Conditional and Index Columns

    5. (Included in full purchase)

      Lesson 4: Combine Monthly Sales Files from a Folder

    6. (Included in full purchase)

      Lesson 5: Merge Product and Transaction Data

    7. (Included in full purchase)

      Lesson 6: Group By to Identify Purchasing Exceptions

    8. (Included in full purchase)

      Lesson 7: Apply Discount Rules to Sales

    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. (Included in full purchase)

      Module 3 Introduction

    2. (Included in full purchase)

      Lesson 1: Importing and Loading Excel Data for Analysis

    3. (Included in full purchase)

      Lesson 2: Understanding Excel's Data Model

    4. (Included in full purchase)

      Lesson 3: Analyzing Data with PivotTables

    5. (Included in full purchase)

      Lesson 4: Building Interactive, Refreshable PivotTable Reports

    6. (Included in full purchase)

      Lesson 5: Validating and Communicating Results

    7. (Included in full purchase)

      Complete Your DRAFT of the Module 3 Assignment

    8. (Included in full purchase)

      Final Module 3 Assignment: Tutorial & Submission

    1. (Included in full purchase)

      Module 4 Introduction

    2. (Included in full purchase)

      Lesson 1: From One Table to Multiple Related Tables

    3. (Included in full purchase)

      Lesson 2: Building Relationships in Power Pivot

    4. (Included in full purchase)

      Lesson 3: Analyzing Data Across Related Tables

    5. (Included in full purchase)

      Lesson 4: Introduction to DAX Measures

    6. (Included in full purchase)

      Lesson 5: Understanding Filter Context

    7. (Included in full purchase)

      Lesson 6: Validating and Troubleshooting the Data Model

    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. (Included in full purchase)

      Module 5 Introduction

    2. (Included in full purchase)

      Lesson 1: Orientation and First Report

    3. (Included in full purchase)

      Lesson 2: Prepare Data and Build a Trustworthy Model

    4. (Included in full purchase)

      Lesson 3: Measures and Meaningful Business Calculations

    5. (Included in full purchase)

      Lesson 4: Choose and Build Effective Visuals

    6. (Included in full purchase)

      Lesson 5: Design Interactive, Decision-Ready Reports

    7. (Included in full purchase)

      Lesson 6: Validate, Refresh, and Deliver Locally

    8. (Included in full purchase)

      Complete Your DRAFT of the Module 5 Assignment

    9. (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 Power of Excel! End-of-Course Survey