• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Lydon Solutions

Lydon Solutions

Construction Project Management Software Solutions

  • Construction Viz
  • Services
    • Business Consulting
    • Professional Services
    • Microsoft 365 Managed Services
    • Government Agencies
  • Company
  • Events
  • Blog
  • Careers
  • Contact
  • Search
  • Free Consultation
Show Search
Hide Search
Jeff Lydon

Jeff Lydon, the president and founder of Lydon Solutions, has over 20 years of experience in construction project management, project controls, and product management across multiple industries, including civil/environmental, manufacturing, healthcare, and utilities.

Excel as a Construction Project Management Tool

July 28, 2015 Reviews

Learn how you can unleash Excel’s hidden superpowers for your construction project team

Excel is currently the mostly widely used project management tool for construction professionals. You may not want to hear that ­­– especially if you are a VP who just implemented a multi-million dollar project management system­­ – but it’s true. Many of those overseeing programs in your company turn to Excel to handle day-to-day project management and reporting. They do this even if you have multiple in-house project management software packages at their disposal.

The widespread reliance on Excel for construction project management might surprise some readers. After all, using Excel for real project management tasks used to be a taboo in the construction industry. But most, if not all, of the construction project managers we talk with admit that Excel is their go-to tool for multi-million – even billion – dollar projects because it is easy to use.

Pros & Cons of Using Excel for Construction Project Management

Excel is a flexible and easy project management tool because it is simple for project teams to update data and create and share reports. Collaboration is easy, since everyone has Excel and is familiar with the software. This is not the case with the limited licenses and steep learning curve of proprietary project management tools.

But the same construction professionals who told us they relied on Excel were also quick to complain about its shortcomings. The most frequently mentioned limitation on using Excel to manage projects include:

• Files are stored locally so sharing and backups becomes a problem

• Consistency and control across spreadsheets isn’t enforceable

• There are often user errors and version control issues

• Excel isn’t a database

It is a classic love/hate story. The construction project managers we meet love Excel for its simplicity and ease of use, but dislike where that simplicity causes the tool to come up short.

The thing is, Excel in recent years has gained some lesser known capabilities – we consider them superpowers really – that make it an even better construction project management tool than most realize.

Excel Power Maps
Power Maps
Power Pivot
Power View

 

 

Unleashing Excel’s Superpowers for Construction Project Management

The good news for our fellow Excel-loving construction industry professionals is that recent enhancements to Excel enable it to be a more effective construction management software package.

So what’s changed?  With the release of Microsoft’s Excel PowerPivot Add-in, which is already built into to Excel 2010 and 2013 and can be turned on from the COM Add-ins menu, Microsoft has morphed Excel into a relational DAX database.  Combined with SharePoint Power Pivot Services, the entire project team can connect, report and share Excel files across the organization.

Imagine the possibilities. You can take existing Excel cost reports and other tracking spreadsheets and use Excel Power Pivot and SharePoint Power Pivot Services to turn them into full blown web-enabled applications that leverage SharePoint permissions.  It’s now possible to connect Excel to many different data sources such as SharePoint Forms and Lists, SQL tables, Access tables, and even other Excel files.  No longer do you need to purchase or build an expensive custom coded solution. These capabilities turn Excel in a project management superhero for construction professionals.

And this evolution of Excel and SharePoint places the power of building and managing solutions in your hands.  Users can straight away leverage their existing Excel files that they know and love and immediately create robust cost management tools. No long and expensive development cycles, no coding and no complicated proprietary tools required.

Ready to unleash Excel’s superpowers for your team? All of these functions and more are incorporated into Lydon Solutions Program Management Portal for Construction. Contact us for your free demo or download our brochure.


Related Posts

Reviews | February 23, 2023

How AI-generated Images Like DALL-E2 Could Change Construction

Read More >
How-To | February 16, 2023

The Great Metadata Convergence with Microsoft Teams, SharePoint, and OneDrive

Read More >
Microsoft Teams Bulletin App
How-To | February 2, 2023

Keep Your Team in the Loop with the Microsoft Teams Bulletins App

Read More >

Primary Sidebar

Search Blog

Recent Posts

Reviews | February 23, 2023

How AI-generated Images Like DALL-E2 Could Change Construction

How-To | February 16, 2023

The Great Metadata Convergence with Microsoft Teams, SharePoint, and OneDrive

Microsoft Teams Bulletin App
How-To | February 2, 2023

Keep Your Team in the Loop with the Microsoft Teams Bulletins App

ChatGPT Microsoft 365
Reviews | January 23, 2023

What Value Does Microsoft 365 Bring to an Organization? (According to ChatGPT)

How-To | January 16, 2023

Microsoft 365 OneDrive and Teams for Your Construction PMIS

How-To | January 6, 2023

What Microsoft 365 @mentions Mean for Construction Communications

Footer

About

Lydon Solutions is a WBE consulting group specializing in construction project management software solutions using Microsoft SharePoint. Learn more >

Products & Services

  • Construction Viz
  • Professional Services
  • Business Consulting
  • Microsoft 365 Managed Services
  • Government Agencies

News & Events

  • Events
  • Blog

Company

  • About
  • Careers
  • Contact Us

Join our Mailing List

  • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
  • This field is for validation purposes and should be left unchanged.
Lydon Solutions

© Lydon Solutions

  • Sitemap
  • Privacy
  • Cookies
  • Terms of Use
  • Disclaimer