Description

Microsoft Project Professional is the industry leading Project Management tool in the Construction world and understanding how to use it is vital to every PM & Construction Super. This class addresses concepts of Project Monitoring, Custom Fields, Resource Pools and Master/Sub-Project controls. It is specifically designed for users who work in the construction industry and are comfortable with basic MS Project, or have already taken the “Microsoft Project Professional: The Basics” course. If you are a construction project manager, superintendent, or executive looking to increase your Microsoft Project skills and have better control over project tracking/reporting, then this is the class for you.

This training will be delivered over the course of four sessions, each lasting two hours. The sessions will be spread out to ensure a manageable pace, allowing participants to absorb and apply the material effectively. 

The recording will be available to participants for a limited time following each session, and a certificate of completion will be issued upon successful completion of the training.  

ZenTek Consultants will show you the most effective means of using the software you already own, so you can get the ROI you were hoping for.

NOTE: Courses are taught using the latest Microsoft software.

Multi-day:  May 27, June 3, 10 & 17, 2025 | 1:00 – 3:00PM ET | 7:00AM – 9:00AM HST

Course Curriculum

This is an intermediate level course.

Session 1: Working with Templates

• Using Excel Online Templates
• Creating Templates from a Worksheet
• Saving and Sharing Templates
• Editing Templates
• Using Templates to Start New Worksheets
• Template Best Practices

Session 2: Data Controls

• Sorting and Filtering Data
• Finding Data
• Working With Conditional Formatting
• Integrating Filters and Conditional Formatting

Session 3: Conditional & Lookup Formulas

• Linking Workbooks and Worksheets via Formulas
• Conditional Formulas & Functions
• Lookup Formulas & Functions
• Nesting Formulas
• Other Useful Formulas and Functions

Session 4: Charts & Tables

• Chart Planning
• Creating Basic Charts and Tables
• Chart Types and Formats
• Pivot Tables
• Sharing Charts & Tables

The Instructor:

David Mills has been working within the construction industry for nearly a decade. He has developed commercial and healthcare projects ranging from $100,000 to $100,000,000+, while working in various positions, including Estimator, Project Engineer, Field Engineer, and Assistant Project Manager. During the COVID-19 pandemic, he was an Owner’s Representative on a large healthcare campus in Michigan. This project had several Construction Managers on it using different software products, which Mr. Mills successfully taught team members to use efficiently.

Mr. Mills joined ZenTek Consultants as a Technology Specialist in early 2023. During his time at ZenTek, he has developed custom solutions and training for clients, as well as written numerous articles and blogs on using Bluebeam and Procore efficiently. His knowledge of software does not end at Bluebeam and Procore, as he is proficient in Microsoft Office, Revit, PlanSwift, PlanGrid, Smartsheet, Adobe Photoshop and Adobe Illustrator.