Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

Protected by reCAPTCHA: Privacy & Terms

MPUG - Master Project User GroupMPUG - Master Project User Group

Picture this. Your manager has asked for a summary dashboard of this month’s sales figures. It needs to look good, update easily, and be ready for Friday’s meeting. You’ve got the raw data in Excel, a to-do list the length of your arm, and absolutely no idea where to start. Sound familiar?

For most of us, building an Excel dashboard sits in that uncomfortable gap between “I know it’s possible” and “I know how to do it” You’ve seen the polished examples online – dynamic charts, Slicers, clean layouts. But replicating them from scratch feels like a project in itself.

This is exactly where combining Excel with AI changes the game.

Imagine being able to describe what you want in plain English and get back a working formula, a suggested layout, or even a ready-to-use chunk of VBA code that pulls your data together automatically. No trawling through YouTube tutorials. No trial and error with functions you half-remember. Just a practical, back-and-forth conversation with an AI assistant that helps you build what you actually need.

That’s not a distant possibility. It’s something you can do right now, once you know how.

In an upcoming session delivered by Mike Thomas, we’ll use a real-world scenario just like this one to show you how ChatGPT can act as your on-demand Excel expert. You’ll see how to describe your problem clearly, get useful answers quickly, and take those answers straight into your spreadsheet, even if your Excel skills are somewhere between “getting by” and “occasionally Googling things.”

Whether dashboards are your stumbling block or it’s something else entirely – messy data, formulas that never quite work, reports that take forever, the approach is the same and by the end of the session, it’ll be yours too.

Register for this live event here!


mpug logo

Elevate your project management skills and propel your career forward with an MPUG Membership. Gain access to 500+ hours of PMI-accredited training, live events, and a vibrant online community. Watch a free lesson and see how MPUG can teach you to Master Projects for Unlimited Growth. JOIN NOW


Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

Protected by reCAPTCHA: Privacy & Terms

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM Glossary

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUG Logo

© 2026 MPUG. All rights reserved.

TermsPrivacySitemapAdvertise
Articles

“I Need a Dashboard by Friday” – How AI Just Made That Possible

Need a dashboard by Friday? Discover how AI tools like ChatGPT can help you build an Excel dashboard quickly and easily—no advanced technical skills required. Learn how to turn plain-English requests into real, working reports with spreadsheets that actually work for you.

2 min read
•about 8 hours ago•
T
TheExcelTrainerAuthor
Project Management
Microsoft Project
Best Practices
Productivity
T
TheExcelTrainer

Content Writer

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

View all articles by TheExcelTrainer
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

Are You Running a Risk Meeting or a Risk Workshop?
Articles
1 min read

Are You Running a Risk Meeting or a Risk Workshop?

Learn the difference between a risk meeting and a risk workshop, and why structured risk workshops help project teams identify owners, define actions, and protect project outcomes.

A
Anonymous
about 8 hours ago
Read
Why Tools Matter More Than Ever in Project Management (And Why Most Organizations Still Get Them Wrong)
Articles
1 min read

Why Tools Matter More Than Ever in Project Management (And Why Most Organizations Still Get Them Wrong)

Most PPM tools fail because they’re built for oversight, not adoption. Here’s how to design for decisions instead, and why Smartsheet bridges the gap.

A
Anonymous
2 days ago
Read
The Integrated Master Plan: Terrible Name, but a Great Idea
Articles
1 min read

The Integrated Master Plan: Terrible Name, but a Great Idea

The Integrated Master Plan uses events, accomplishments, and criteria to define objective progress before scheduling begins. Here’s what it is and why it works.

A
Anonymous
14 days ago
Read
Explore All Articles