Excel Power Query & Dashboards – 2 of 3 | MPUG

Lesson Preview

In this session we cover calculations without formulas, Append & Merge Queries, convert a single text string into multiple rows, and unpivot.

Loading the player...

Duration

Difficulty

Intermediate

Premium Content

This Lesson is Locked

Get unlimited access to all lessons with a membership

Monthly

$14.75

per month

Best Value

Annual

$159

per year

Your membership includes:

Unlock all premium lessons

100s of PDU credits

Weekly live webinars

Unlimited expert articles

On-demand video library

Resource downloads

30-day money-back guarantee

Continue Reading

Discover more insights and articles that complement your current reading

Articles

5 min read

Variance Analysis: An Ideal Application of AI

Learn how proper project structure using IRDM enables AI to transform variance analysis from manual spreadsheet work into data-driven insights and automated narratives.

Eric Christoph

7 days ago

Read

Articles

4 min read

Mastering Microsoft Project Dependency Analysis with SSI Tools

Learn to analyze complex schedule dependencies in Microsoft Project using SSI Tools including Directional Path, Connecting Path, and Dependency Tracer to identify critical paths and troubleshoot task logic.

Beyond the WBS: The Integration Relationship Diagramming Method (IRDM)

Learn how IRDM eliminates bloated control accounts and restores management control while maintaining WBS compliance through metadata-driven integration across four structural domains.