Close button
QTalo Insights
|
Tool Tips

My Journey: How I Leveraged Microsoft 365 Tools for Smarter Project Management

Traditional spreadsheets can be so satisfying, seeing your tasks laid out neatly and organized — at least until it all falls apart. Luckily, there's a better way.

The image shows a cheerful cartoon-style man with gray hair and glasses, wearing a professional gray suit and a light blue tie. He is smiling warmly and gesturing with one hand, conveying an approachable and confident demeanor. The background includes a blurred computer screen and a softly lit office environment, adding to the professional yet friendly atmosphere of the image.

Old-school project managers love their spreadsheets. And honestly, I get it. There’s something so satisfying about seeing all your tasks laid out neatly, color-coded, and organized – until it all starts to fall apart. Spreadsheets work great when the project is small, but as things grow, managing multiple versions and scattered updates quickly becomes its own full-time job.

I know this because I experienced it. Fifteen years ago at Dell, I was in the thick of it, juggling a tangled mess of spreadsheets, project charters, and timelines. We passed everything back and forth through endless email chains, never quite sure if we had the right version. Today's spreadsheet could be completely different from yesterday's, and collaboration felt impossible – that constant worry of "Do I even have the right file?" was exhausting and frustrating. I knew there had to be a better way.

Breaking Free: My SharePoint Breakthrough

The first real breakthrough for me came 10 years ago when my project teams moved to Microsoft SharePoint. Suddenly, we had a single source of truth. The document library feature clicked immediately - instead of relying on file shares, we could now manage permissions, send update notifications, and ensure everyone had access to the latest version.

Once we had that foundation, everything else got easier. With tools like SharePoint in place, we spent far less time dealing with administrative headaches. No more manual updates, no more merging different versions, and way fewer follow-up emails. Instead, we got to do the real work—collaborating meaningfully, leading proactively, and focusing on what mattered: planning, executing, and guiding our projects to success.

The adoption wasn't instant, though. About 20% of the team got it right away, while 80% needed convincing. Some team members had to learn the hard way, missing important updates because they were still digging through email instead of checking SharePoint. But once they experienced how it prevented those mistakes, they never looked back.

Moving Beyond Basics: Finding the Right Tools

One of the tools that made a huge difference for me personally was Microsoft ToDo. It’s perfect for managing my own daily priorities and staying on top of individual tasks. I can also assign tasks, and it integrates with Microsoft Outlook.  

For managing smaller projects, Microsoft Planner is fantastic. It’s like a digital task board that helps me visualize all my tasks, assign them to team members, and keep everything on schedule. As projects grew, it became crucial to have a tool that could help us see the big picture – managing timelines, dependencies, and resources – without the chaos of spreadsheets.

Scaling Up: Tools for Complex Projects

As projects grew, it became crucial to have tools that could help us see the big picture. Project Online provides the kind of high-level overview that project managers need to manage large and complex projects. With features like Gantt charts, resource allocation tools, and task dependencies, Project Online made it easier to keep everything on track. 

When I started managing ERP implementations for Dynamics 365 and SAP, we needed more robust solutions. Azure DevOps proved perfect for this – we could track implementation tasks, issues, and risks all in one place. It's not just for developers; it's comprehensive project management that works for any complex initiative.

One key learning: Azure DevOps requires more commitment from the entire team. Unlike SharePoint or Excel where only the core project team needs to be engaged, with DevOps everyone needs to be actively involved in keeping it up to date. But that increased engagement actually improves project outcomes.

The AI Evolution: Microsoft 365 Copilot

These days, Microsoft 365 Copilot is transforming my daily routine. Every morning, I start by asking Copilot what I need to do today. It reviews my Outlook before I've even opened it and identifies my top three priorities. Instead of facing an inbox with 150 messages and trying to decode what matters most, I get clear direction right away. It's been game-changing for managing my workflow.

Looking Ahead

If there’s one thing I’ve learned through all these changes, it’s that collaboration is everything. No tool will magically solve all your problems if the team isn’t communicating well. But with the right tools and a willingness to adapt, you can transform how projects are managed—moving from chaos to clarity, and from frustration to real, impactful progress.

Brad
Holt

Author

Brad Holt is a Project Manager Professional (PMP) with 20 years of experience in the IT industry. He is a Microsoft 365 Partner and passionate about leveraging technology to improve project outcomes. For more information, you can reach Brad at brad@bchol.com.

More QTalo Insights

The Art of Stakeholder Management: A UX Research Lead's Survival Guide
Managing project stakeholders as a UX lead can feel a bit like juggling while walking a tightrope. Diana Riggieri shares advice from her experience.
From Manual Updates to AI Insights: The Evolution of One PM's Toolkit
Brett Miller's journey from spreadsheet warrior to strategic leader at Amazon offers valuable insights for PMs ready to embrace the future.