Skip Navigation

This website uses cookies and related technologies to improve your experience, analyze traffic and personalize content. We may share this data with third-party partners for advertising and analytics purposes. Learn more

Skip navigation
A laptop screen with Microsoft Excel tables and graphs being manipulated by a business person.
Live Virtual Workshop
3 hrs

Mastering Excel Power Tools: Power Query, Power Pivot & Data Modeling

Unlock the full potential of Excel for advanced data analysis and modeling. This dynamic course dives into Excel’s powerhouse trio — Power Query, Power Pivot and data modeling — to transform how you handle data.

Learn to clean and reshape messy datasets with Power Query, tackle complex data challenges, and build robust, sophisticated data models with Power Pivot. Across three hands-on modules, you’ll master tidying data into clean, tabular formats, consolidate reports from diverse sources, and solve modeling challenges by bridging fact and dimension tables.

Perfect for professionals eager to streamline workflows and unlock advanced analytics, this course equips you to work smarter, analyze faster, and deliver impactful insights with confidence.

For the best learning experience, we recommend using Microsoft 365. Windows platform preferred.

Course Outcomes

  • Combine, clean and reshape messy data from multiple sources
  • Automate repetitive tasks and data transformations using Power Query
  • Build scalable, efficient data models with Power Pivot
  • Analyze large datasets and uncover relationships across tables
  • Go beyond formulas and PivotTables to create smarter reporting workflows

Course Agenda

3 hrs
Live Virtual Workshop

Event Dates & Locations

DateTimePriceAction

Live Virtual Workshop

Course Dates & Times
Schedule a private group trainingLearn More

Save when you enroll multiple attendees!

Just $189 per person when you enroll 4+ learners

Included in
SkillPath Unlimited+Live

$ per year

  • Access this course and 6000+ other live virtual workshop sessions(includes live virtual events priced $399 or less)
  • 500+ webinars broadcast daily
  • 2,000+ on-demand resources
  • And so much more!

FAQs

Related Courses

loading icon