EXC102 · Power Query and Consolidation

Categories: Data & BI
Wishlist Share

About Course

Import and standardize multiple files, combine data and build a refreshable transformation pipeline.

Build · 8 hours · Part of the Program in Excel and Power Query for Productivity

Lessons

  • Lesson 1 · Introduction to Power Query and importing data
  • Lesson 2 · Cleaning and standardizing data
  • Lesson 3 · Consolidating multiple files with From Folder
  • Lesson 4 · Merging queries and building a refreshable pipeline

Self-paced, 12-month access. Questions are answered in writing through the student panel. A completion record is issued when you finish the course.

Next step

Continue with EXC103 · Report Controls and Analysis · 8 hours · $56.00

Continue to the next course

Prefer the whole program? Program in Excel and Power Query for Productivity · $202.00 (10% less than buying the courses separately)

Course Content

EXC102 · Power Query and Consolidation (8 h)
Import and standardize multiple files, combine data and build a refreshable transformation pipeline.

  • Lesson 1 · Introduction to Power Query and importing data
  • Lesson 2 · Cleaning and standardizing data
  • Lesson 3 · Consolidating multiple files with From Folder
  • Lesson 4 · Merging queries and building a refreshable pipeline
  • EXC102 Assessment · Power Query and Consolidation
Scroll to Top