Back to ArticlesBack

Join 50,000+ PM Professionals

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

MPUG - Master Project User GroupMPUG - Master Project User Group
Image of 5 people seated at a table looking at charts

Mastering Excel Essentials in Our 3-Part Webinar Series

Join our 3-part webinar series, “Must-Know Excel Functions to Boost Your Productivity,” and unlock the true potential of Excel in just three hours! Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master. Why attend, you ask?

Efficiency

In Part 1, you’ll harness the power of functions like IF, COUNTIFS, SUMIFS, IFERROR, and XLOOKUP to streamline your workflow, make complex calculations a breeze, and automate repetitive tasks.

Precision

In Part 2, dive deep into functions such as INDEX-MATCH, UNIQUE, SORT, and FILTER to efficiently manage and manipulate your data, ensuring accuracy in your analyses and reports.

Insight

In Part 3, you’ll gain invaluable skills with GETPIVOTDATA, SUBTOTAL, LEFT/RIGHT/MID, CONCATENATE, TEXTJOIN, WORKDAY, EOMONTH, and NETWORKDAYS. These functions will empower you to extract meaningful insights from your data, create dynamic reports, and make informed decisions.

By the end of our webinar series, you’ll have a rock-solid foundation in Excel functions, revolutionizing the way you work with data. Don’t miss this opportunity to boost your productivity and excel in your professional journey. Register now and transform the way you use Excel.

Register below to join us!

https://mpugwp.wpengine.com/event/must-know-excel-functions-to-boost-your-productivity-1-of-3

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.

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.

TermsPrivacySitemap
Articles

Why You Should Attend “Must-Know Excel Functions to Boost Your Productivity”

Explore our guide on simple yet effective project estimation strategies. Master project timelines efficiently and make informed decisions.

2 min read
•about 2 years ago•Updated 24 days 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

How Reserves Keep Projects Alive
Articles
1 min read

How Reserves Keep Projects Alive

Learn how project reserves protect your budget and schedule from unexpected risks, including when and how to use contingency, management, schedule, and cost reserves effectively.

A
Anonymous
20 days ago
Read
Why Platform Migrations Fail (And How to Land Yours Successfully)
Articles
1 min read

Why Platform Migrations Fail (And How to Land Yours Successfully)

Learn why platform migrations fail and how to land yours successfully using proven change management tactics for PMOs facing tool transitions like Project Online’s retirement.

A
Anonymous
23 days ago
Read
Beyond Project Online: Why Now Is the Time to Plan Your Move to Modern Portfolio Management and How We Can Help
Articles
1 min read

Beyond Project Online: Why Now Is the Time to Plan Your Move to Modern Portfolio Management and How We Can Help

Microsoft Project Online retires September 2026. Learn why now is the time to plan your transition to modern portfolio management and join our free webinar on January 28.

A
Anonymous
about 1 month ago
Read
Explore All Articles