Microsoft EXCEL INTERMEDIATE SERIES
Take your Excel skills to the next level with our Microsoft Excel Intermediate series. In this practical, hands-on course, you’ll learn how to create smarter, more efficient worksheets that will save you time and effort. Say goodbye to repetitive tasks and get comfortable with Excel’s advanced tools, so you can make better use of its powerful capabilities. Each virtual session is designed to help you master Excel techniques that will make your daily tasks easier and more productive. Whether you attend the whole series or just a few sessions, you’ll gain valuable insights that you can apply immediately.
Our partner in delivering this training, Zentek Consultants, has extensive experience working with the construction industry, ensuring that our training is tailored to address the unique challenges and real-world applications of Excel in construction projects.
Best of all, this virtual training is completely free for our members, providing a valuable benefit to your membership. And you’ll earn 2 Project Management credits for each session attended if you are enrolled in the MBD program.
SESSION ONE: WORKING WITH TEMPLATES
April 9, 2025 | 9:00am - 11:00am
In this session, you will discover how to use Excel Online Templates, create custom templates from your own worksheets, and save and share templates for future use. Learn how to edit templates, use them to quickly start new worksheets, and apply best practices to keep your work organized and efficient.
SESSION TWO: DATA CONTROLS
April 16, 2025 | 9:00am - 11:00am
Explore how to manage and organize data with advanced sorting and filtering techniques. You will also learn how to quickly find specific data, apply conditional formatting to highlight important information, and integrate filters with conditional formatting to streamline your data analysis process.
The Master Builder Designation program will offer credits for completion of this course. For more information on becoming a ‘Master Builder’, please visit MBI’s website
SESSION THREE: CONDITIONAL & LOOKUP FORMULAS
April 23, 2025 | 9:00am - 11:00am
Master the art of linking workbooks and worksheets with formulas and discover how to create conditional formulas that adjust based on your data. This session covers lookup formulas and functions to retrieve specific data, as well as nesting formulas for more complex calculations.
SESSION FOUR: CHARTS & TABLES
April 30, 2025 | 9:00am - 11:00am
Learn how to plan and create impactful charts and tables that visually represent your data. You’ll be introduced to different chart types and formats, and how to use pivot tables to summarize and analyze large datasets. Plus, we’ll show you how to share charts and tables with others for easy collaboration.
Presenter
Hackensack, NJ
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.
Have Questions?
If you have any questions, please contact Janel Haynes at JHaynes@MBI.Build or 515-461-9237.
David Mills, ZenTek Consultants - Hackensack, NJ
David Mills
ZenTek Consultants
Microsoft EXCEL INTERMEDIATE SERIES
4-Part Online Training Series
Contact Name:
Title:
Email:
Company:
Address:
City: State: Zip:
Phone:
Cell:
The sessions below are scheduled for a la carte registration allowing attendees to participate in the
Please mark which online session(s) you would like to connect to:
Session 1: WORKING WITH TEMPLATES
April 9, 2025 | 9:00 am - 11:00 am
Session 2: DATA CONTROLS
April 16, 2025 | 9:00 am - 11:00 am
Fee: No Charge / MBI Members
$160 Per person / Per Session / Non-Members
Session 3: CONDITIONAL & LOOKUP FORMULAS
Session 4: CHARTS & TABLES
April 30, 2025 | 9:00 am - 11:00 am
METHOD
Only the individual whose email address is used to register and is attached to the Zoom connection is eligible to receive Master Builder Designation credits. Zip:
Name on card: Card address:
Total enclosed: $
A 3% processing fee will be charged on all credit card transactions.
Cancellation Policy: Registration cancellations must be submitted to Master Builders of Iowa via email to NFry@MBI.Build. Cancellation requests submitted at least 14 days prior to the start of this program will be refunded 100%. Cancellations received between 7 and 14 days prior to the start of this program will be refunded 50%. No refund for cancellations less than 7 days prior to the start of this program. No refund for no-shows.
Please send registration and payment to:
MASTER BUILDERS OF IOWA
4100 Westown Pkwy | West Des Moines, Iowa 50266
Attn: Nichole Fry NFry@MBI.Build
Further information and instructions for each of the online sessions will be forwarded to participants upon receipt of registration.
For more information, please contact Janel Haynes at JHaynes@MBI.Build or 515-461-9237.