Course curriculum

    1. Course Instructions

    2. Learning Objectives

    3. Welcome to the Course

      FREE PREVIEW

    4. Structure of the Course

      FREE PREVIEW

    5. Introduction to the Case

    6. Download the Modeling Files

    7. Introduction to the Financial Model

    8. Building an End-to-End Process

    1. Why Use Power Query

    2. Connecting Power Query to Data

    3. How to Find and Edit Queries that Already Exist

    4. The Power Query Editor

    5. The Home Ribbon

    6. Sorting Data

    7. Splitting Columns

    8. Group By

    9. Data Parameters and Pathways

    10. Merging and Appending Queries

    11. Review Questions

    1. Transform and Add Column Ribbons

    2. Unpivot Data

    3. Pivot Data

    4. Detect Data Type

    5. Renaming Columns and Steps

    6. Moving Data

    7. Converting Data to Lists

    8. Why Data Lists Matter

    9. Formatting, Trimming, and Cleaning Text

    10. Add Prefix and Suffix

    11. Performing Real-Time Calculations

    12. Averages and Dividing by 1000

    13. Absolute Value, Rounding, and Binaries

    14. Review Questions

    1. The Add Column Ribbon and Indexing

    2. Adding Custom Columns

    3. Adding Conditional Columns

    4. Column from Examples

    5. Review Questions

    1. Introduction to the End-to-End Process

    2. Transforming Data with Multiple Applied Steps

    3. Best Practices in Table and Query Naming

    4. Extracting Dynamic Data with XLOOKUP

    5. Extracting Dynamic Data with SUMIFS

    6. Replacing One Data Source with Another

    7. Duplicating Queries for New Data

    8. Appending Queries with New Data

    9. Grouping and Organizing Queries

    10. Updating Queries with Folders and Directories

    11. Bringing it All Together

    12. Review Questions

    1. Final Thoughts

About this course

  • $299.00
  • 54 lessons
  • 3.5 hours of video content

Discover your potential, starting today

Enroll today