background

Excel Expert Q&A + How to Prevent a Project Haunting


Tuesday Brief: This week, master DAX measures with Mike Thomas before his live Q&A tomorrow, plus Ronald Smith's beloved Halloween tradition returns with project management wisdom wrapped in spooky fun.

October 28, 2025

In This Issue:

  • Video Tutorial: Excel DAX Measures Explained (with Examples)
  • Live Event (10/29): Excel Power Hour #3 - Q&A with Mike "TheExcelTrainer" Thomas
  • Featured Article: Ronald Smith's PM Survival Guide
  • Community Poll: What's your go-to resource when you hit a roadblock?
  • PM Best Practices: Don't Let Project Ghosts Haunt You

Excel Tutorial: DAX Measures Explained (with Examples)

Working with Excel's data model? DAX measures are essential for creating efficient calculations in pivot tables. In this 13-minute tutorial, Mike "TheExcelTrainer" Thomas demonstrates the difference between calculated columns and measures, showing you why measures are the best practice approach for aggregated data.

You'll learn:

  • What DAX measures are and how they differ from regular Excel formulas
  • Why measures use less memory and scale better than calculated columns
  • How to create measures from both the data model and Excel interface
  • Real examples: calculating total profit and average profit per order

This is the perfect primer before tomorrow's live Excel Power Hour - come armed with your DAX questions!

Live Event (10/29): Excel Power Hour #3 Q&A with Mike "TheExcelTrainer" Thomas

Bring your toughest Excel challenges to this interactive Q&A session with Excel expert Mike "TheExcelTrainer" Thomas. Whether you're troubleshooting formulas, optimizing workflows, or exploring Power BI integration, Mike provides real-time demonstrations and practical solutions tailored to your specific business needs.

What You'll Gain:

  • Expert guidance from a trainer with 35+ years experience
  • Live demonstrations of Excel techniques and best practices
  • Solutions to your specific Excel questions and challenges
  • Actionable strategies for data analysis and automation

This session welcomes all skill levels - from Excel beginners to advanced users seeking to level up their capabilities.

๐Ÿ—“๏ธ Wednesday, October 29
๐Ÿ•› 12:00pm - 1:00pm EDTโ€‹
๐Ÿ“ Live on Zoom
๐Ÿ… 1 PMI PDU: 1 Business Acumen

P.S. Live events + on-demand replays are exclusive for MPUG members! Join today for just $14.75/month.

Featured Article: A PM's Halloween Survival Guide - Ronald Smith's Annual Tradition Returns

It's that spooky time of year again! MPUG community favorite Ronald B. Smith, MBA, PMP brings back his beloved Halloween tradition with a fun look at the eerie parallels between failing IT projects and Halloween horrors. From scope creep monsters to ghosted team members, Ronald finds the humor in our everyday project challenges while weaving in genuine insights about risk management and lessons learned.

Have a fang-tastic Halloween from all of us at MPUG!

Community Poll: What's your go-to resource when you hit a roadblock?

Every project manager faces those moments when you need guidance fast. We're curious - where do you turn first when challenges arise?

Upcoming Live Events

MPUG host live events with leading experts on Wednesdays from 12:00pm - 1:00pm ET! MPUG members get access to live events where you get direct access to industry leaders, actionable insights, hands-on training, and opportunities to earn PDU's.

Learn more and register for upcoming events:

10/29: Excel Power Hour #3 - Q&A with Mike โ€œTheExcelTrainerโ€ Thomas | Learn More / Register Here

10/29: Mastering Microsoft Project Dependency Analysis with SSI Tools | Learn More / Register Here

PM Best Practice: Don't Let Project Ghosts Haunt You

Before closing your next project or phase, schedule a brief retrospective with your team to document what worked, what didn't, and what you'd change next time. The scariest thing in project management isn't failureโ€”it's repeating the same mistakes because lessons learned were never captured. Capture those insights while they're fresh, and your future self won't be haunted by the same project poltergeists next time around.

Don't be spooked this week!

Share this newsletter on Socials

Follow MPUG for PM Tips + Training

View our Privacy Policy

1001 Woodward Ave Suite 500, Detroit, MI 48226
โ€‹Unsubscribe ยท Preferences

background

Subscribe to MPUG