22 - 30 July, 2020
Data Day Online 2020
Thursday, 23 July, 2020 | 12:00 PM

Excel for Design Professionals

Patrick Knee, HG Architects
Pre-Design, Design
Data day
Coding and Customisation
Autodesk, Nemetschek, Other Vendor
Advisors/Consultants, Architects/Architectural Designers, BIM Leaders/Managers, CAD Managers, Engineers - Civil, Engineers - Electrical, Engineers - Fire, Engineers - Mechanical, Engineers - Other disciplines, Engineers - Plumbing/Hydraulic, Engineers - Road/Rail, Engineers - Site, Engineers - Structural, Information Managers, Interior Designers, Modellers, Project Managers, Team Leaders


Excel can make your information work for you. It is a powerful tool that can run complex calculations, automatically highlight information, or filter large lists of information. This class is for users who have data that Excel can accept and want an easier way to manage that data.

Learning Objectives:

1. Understand the differences between file formats and how it could be structured.
2. Learn ways available to search and manipulate the information for calculations.
3. Combine multiple data sources into more complex calculations and formulas.
4. Present this data in a graphical way using tools in Excel.


Excel is one of the most utilized and underutilized software in the AEC industry. This course will demonstrate some methods to search data, combine multiple data sets, and present this information in graphic ways.
During this presentation we will walk through some scenarios where data in Excel can be utilized for project management, code calculations, and presentations.
We will focus on:
• How information might be structured.
• Methods to get that information into and out of Excel.
• Learning ways formulas can search data and return values from a set of data.
• Combining these search formulas into traditional calculations.
• Methods to filter and sort data.
• Set up conditional formatting by references or by values.
• Create pivot tables for clearer digestion of information.



Patrick Knee

HG Architects
Project Architect

COVID-19 Update

20th May 2020

DBEI has been closely monitoring the COVID-19 (coronavirus) situation around the world. While some parts of our society are beginning to open in baby-steps, none of us know how the situation will develop over the coming months. As such, DBEI has now made the decision to postpone all our 2020 events to 2021 as the well-being of all our partners and participants in our events remains our utmost priority. For new details on each region please visit our event pages. We have also sent communications to all registered attendees, speakers or sponsors for all of our 2020 events.

In the interim, DBEI will be launching several exciting virtual events and webinars in 2020 to continue to deliver the same expertise, insights and knowledge to the AEC industry during these uncertain times. We also have some other exciting initiatives we are working on to continue to provide value to our community, which we look forward to sharing with you all shortly.

We wish to thank you all for your support and appreciate your patience and understanding under the current circumstances and will continue to update our website and the community if there are any changes.

If you have any concerns or questions about our events please email us at info@dbei.org