Microsoft Excel in BIM and Construction- From Zero from Udemy

Note: This is a project-based Course where all the topics covered have been examined on real-world projects.

Does modeling certain tasks, such as creating Rooms for spaces, take a long time from you?
Have you ever needed to import an Excel file into Revit and use its data?
Were you aware that you can even change the parameter values of objects in the project using Excel?

This Excel training course is designed to efficiently and intelligently transfer data from Excel to BIM-related software such as Revit or Microsoft Word. Participants will first familiarize themselves with Excel and its practical tools, followed by exploring the connection and applications of Excel in BIM Base projects. Emphasis is placed on the importance of using Excel to save time during modeling and editing.

Upon completion of the course, participants will have acquired the skills to efficiently use Excel for increasing speed and transferring data between Excel and other software.Headlines:

Connecting Excel with Revit
Writing Excel Formula
Creating Rooms by Using Excel
Changing Parameter Values of Revit Objects
Filter Data in Excel
Importing Excel Tables to Revit
Conditional Formatting
Adding Parameters in Navisworks

Please watch this course and feel free to ask me any questions you have while watching it. Additionally, during the learning Excel, ask me questions so that I can guide you. Enroll now for being professional in BIM and Excel.

What's inside

Learning objectives

Connecting excel with revit
Writing excel formula
Creating rooms by using excel
Changing parameter values of revit objects

Filter data in excel
Importing excel tables to revit
Conditional formatting
Adding parameters in navisworks

Connecting excel with revit
Writing excel formula
Creating rooms by using excel
Changing parameter values of revit objects
Filter data in excel
Importing excel tables to revit
Conditional formatting
Adding parameters in navisworks

Syllabus

Editing Elements Parameters

What Makes This Course Unique?

Why This Course?

Course Catalog

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Focuses on practical tools and techniques for efficiently transferring data between Excel and BIM-related software, such as Revit and Navisworks, which are commonly used in the industry

Develops skills in using Excel to automate tasks like creating rooms and changing parameter values, potentially saving significant time in modeling and editing workflows

Explores the connection between Excel and Revit, teaching learners how to import Excel files, change parameter values, and filter data, which are valuable skills for BIM projects

Features the Sheetlink Plugin, which may require learners to purchase a license or subscription in order to fully utilize the plugin's features

Reviews summary

Practical excel use for bim workflows

According to learners, this course offers a highly practical introduction to leveraging Excel specifically within BIM and construction contexts. Students found the content directly applicable to real-world projects, praising its focus on tasks like creating rooms and editing parameters using Excel. The course is particularly noted for demonstrating how to use Excel to save time and improve efficiency in BIM workflows. While many found it clear and helpful, especially for specific tasks, some reviewers noted that certain sections could benefit from more in-depth explanation or felt the course assumed a certain level of prior knowledge in either Excel or BIM software. Recent reviews remain generally positive, indicating the core value proposition holds.

Covers specific plugins like Sheetlink.

"The section on the Sheetlink plugin was invaluable; it opened up new possibilities for managing data between Excel and Revit."

"I specifically wanted to learn about connecting Excel to Revit, and this course covered the Sheetlink workflow well."

"Understanding how to import and export data using plugins is a key takeaway for me."

Helps save time on repetitive BIM tasks.

"Using the methods shown, especially for creating rooms and editing parameters, has drastically reduced the time I spend on tedious tasks."

"The course really delivers on its promise to show how Excel can save time in modeling and editing within Revit."

"I feel much more efficient in handling BIM data after taking this course."

Directly applicable to BIM/Construction projects.

"This course is extremely practical and directly applicable to my work in the construction industry. The examples were spot on."

"I learned techniques I could immediately use on my BIM projects to improve efficiency."

"The focus on real-world BIM scenarios makes the Excel concepts much more relevant than generic courses."

Potential challenges with specific software versions.

"I encountered some issues getting the exercise files and plugins to work seamlessly due to software version differences."

"It would be helpful if the course addressed potential compatibility issues with newer versions of Revit or Excel."

"Had to spend some time troubleshooting getting Sheetlink configured correctly based on the course material."

Some parts could benefit from more detail.

"While helpful, I felt some topics were covered too quickly and could have used more in-depth examples."

"The course is a great starting point, but it might not be deep enough for advanced users looking for complex data manipulation."

"Some explanations felt a bit basic, requiring me to seek external resources for clarification on certain functions."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel in BIM and Construction- From Zero with these activities:

Review Excel Fundamentals

Show steps

Reinforce your understanding of core Excel concepts like formulas, functions, and formatting to build a solid foundation for using Excel in BIM and construction workflows.

Browse courses on Excel Fundamentals

Show steps

Review basic Excel functions like SUM, AVERAGE, and COUNT.
Practice formatting cells and tables for clear data presentation.
Familiarize yourself with Excel's user interface and navigation.

Explore Revit-Excel Interoperability Tutorials

Show steps

Learn how to effectively link Excel with Revit by following online tutorials that demonstrate data transfer, parameter modification, and automated workflows.

Show steps

Search for tutorials on importing Excel data into Revit.
Follow tutorials on using Excel to modify Revit parameters.
Experiment with different data transfer methods between Excel and Revit.

Practice Excel Formulas for BIM Data

Show steps

Sharpen your Excel formula skills by creating and manipulating data sets relevant to BIM and construction projects, such as calculating quantities, costs, and schedules.

Show steps

Create Excel formulas to calculate material quantities from BIM data.
Develop formulas to estimate project costs based on BIM parameters.
Practice using Excel functions to manage and analyze project schedules.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Mastering Excel: The Complete Definitive Guide

Show steps

Expand your Excel knowledge with a comprehensive guide that covers advanced features and techniques applicable to BIM and construction data management.

View Putting Knowledge to Work on Amazon

Show steps

Read chapters on advanced Excel functions and formulas.
Explore sections on data analysis and visualization techniques.
Practice applying the learned concepts to BIM-related datasets.

Develop an Excel-Based Quantity Takeoff Tool

Show steps

Create a practical tool that automates the process of extracting quantity data from BIM models using Excel, enhancing your efficiency and accuracy in project estimation.

Show steps

Define the scope and requirements of your quantity takeoff tool.
Design the Excel spreadsheet structure and formulas for data extraction.
Implement the tool and test its functionality with sample BIM data.
Refine the tool based on testing and feedback.

Excel Power Pivot and Power Query For Dummies

Show steps

Learn how to use Power Pivot and Power Query to efficiently manage and analyze large BIM datasets within Excel.

View Excel 2019 Bible on Amazon

Show steps

Read chapters on importing data from various sources using Power Query.
Explore sections on creating data models and relationships in Power Pivot.
Practice using Power Pivot to analyze and visualize BIM data.

Create a Data Visualization Dashboard for a Construction Project

Show steps

Design and build an interactive dashboard in Excel that visualizes key performance indicators (KPIs) for a construction project, providing valuable insights for project management and decision-making.

Show steps

Identify relevant KPIs for a construction project (e.g., cost, schedule, safety).
Gather data from BIM models and project management systems.
Create charts and graphs in Excel to visualize the KPIs.
Design an interactive dashboard layout for easy data exploration.

Career center

Learners who complete Microsoft Excel in BIM and Construction- From Zero will develop knowledge and skills that may be useful to these careers:

Building Information Modeling Technician

A Building Information Modeling Technician uses software to create 3D models of buildings and infrastructure. This role often involves data management and collaboration, so the ability to transfer data between Excel and other software, as covered in this course, is highly valuable. This course specifically addresses how to connect Excel with Revit and use Excel to change parameter values of objects. Building Information Modeling Technicians need to create rooms using Excel and import Excel tables into Revit, and this course directly provides this knowledge.

See salaries and explore the career path for Building Information Modeling Technician

BIM Modeler

A BIM Modeler creates detailed 3D models of buildings and infrastructure using Building Information Modeling software. This course directly addresses the skills a BIM modeler would use day to day. This course covers how to connect Excel with Revit, as well as writing Excel formulas. BIM modelers must effectively use data from various sources, including Excel, in their models. This course teaches how to transfer data between Excel and BIM software, which is crucial for a BIM modeler. This role requires the ability to change parameter values of objects in the project using Excel, which is covered in the course.

See salaries and explore the career path for BIM Modeler

Construction Project Coordinator

Construction Project Coordinators help manage the flow of information on a construction project. The course's focus on transferring data between Excel and BIM software, such as Revit, makes it very useful for this role. A construction project coordinator works with project documentation and data, and this course helps build skills that facilitate this work. The ability to filter data and use formulas in Excel, which are taught in this course, are essential for keeping track of project details. The course also covers the creation of rooms using Excel, which is relevant to the creation of construction documents.

See salaries and explore the career path for Construction Project Coordinator

Construction Data Analyst

Construction Data Analysts use data to help optimize construction processes and decision making. The data management and analysis skills gained in this course make it highly relevant to this role. The course's emphasis on connecting Excel with Revit, filtering data, and creating charts directly contribute to a data analyst's skill set. This role uses tools to analyze complex data sets, and this course covers pivot tables and conditional formatting in Excel. This course also covers importing Excel tables to Revit, which further allows a construction data analyst to bring external data into models.

See salaries and explore the career path for Construction Data Analyst

Architectural Drafter

An Architectural Drafter creates technical drawings and plans for buildings using computer-aided design software. The course assists those in this role by improving efficiency in BIM related software. This course teaches skills relating to the use of Excel, and how to transfer data, including creating rooms using Excel, and importing Excel tables to Revit, making this course highly relevant. The course also teaches how to change the parameter values of objects in Revit through the use of Excel, which simplifies and streamlines the drafting of data heavy projects.

See salaries and explore the career path for Architectural Drafter

Virtual Design and Construction Specialist

A Virtual Design and Construction Specialist uses Building Information Modeling and other technologies to improve construction project outcomes. The course's focus on using Excel for data transfer and management within a BIM context aligns directly with the work of a virtual design and construction specialist. This course provides a practical approach to leveraging Excel to increase speed and efficiency in BIM projects. The ability to create rooms, change parameter values of objects, and use Excel formulas is highly relevant to this role. Additionally, the course teaches how to import tables, which is important for a Virtual Design and Construction Specialist.

See salaries and explore the career path for Virtual Design and Construction Specialist

Project Engineer

Project Engineers are involved in the planning, design, and execution of construction projects. This course may be helpful by teaching how to use Excel for efficient data management. Project engineers often need to import data from spreadsheets into models, and this course teaches how to import Excel tables to Revit. By increasing proficiency in using Excel to filter data and write formulas the project engineer can help reduce errors and improve overall efficiency in their work. The course's focus on connecting Excel with Revit and changing parameter values of objects using Excel may also benefit a project engineer.

See salaries and explore the career path for Project Engineer

Quantity Surveyor

A Quantity Surveyor manages and controls costs on construction projects by analyzing data. This course may be useful to develop data analysis skills using spreadsheet software. Quantity surveyors often use project data in Excel format, so this course's emphasis on filtering data using Excel may be helpful. The course teaches how to export quantities tables, which the surveyor can then use in their work. This course also covers the use of formulas, which may help in the calculations needed in this role. The use of pivot tables, also covered in this course, may be helpful when creating reports.

See salaries and explore the career path for Quantity Surveyor

Construction Estimator

A Construction Estimator analyzes project plans and specifications to prepare cost estimates for construction work. This course may be useful by helping improve spreadsheet software proficiency. The work of an estimator involves the use of quantities and other data in spreadsheet form, and this course teaches how to export quantities tables from BIM software. The ability to filter data and change formatting settings in Excel is relevant to this role. The course's teachings on pivot tables may be useful for the estimator, when creating reports.

See salaries and explore the career path for Construction Estimator

Facilities Manager

A Facilities Manager oversees the maintenance and operation of buildings. This course may be useful for optimizing facility information in spreadsheet software. Facilities managers often need to import and manage large data sets related to building assets and spaces. This course helps build skills needed to transfer data from Excel to BIM software via techniques like connecting Excel with Revit and importing tables. This course teaches many useful techniques which might improve efficiency for this role, such as how to use formulas and filters in Excel.

See salaries and explore the career path for Facilities Manager

Civil Engineering Technician

A Civil Engineering Technician assists civil engineers in the design, construction, and maintenance of infrastructure projects using computer-aided drafting techniques. This course may be useful in improving proficiency in spreadsheet software. The course covers the use of Excel for data transfer and management, which may be useful for a civil engineering technician. The ability to filter data and use formulas in Excel, which are taught in this course, may help organize project details. The course also covers the creation of rooms, which can be relevant to civil engineering projects.

See salaries and explore the career path for Civil Engineering Technician

Urban Planner

An Urban Planner develops plans for land use and community development. Although much of the work of an urban planner does not involve BIM applications, this course may be useful. Urban planners often use data in spreadsheet form. This course may improve their proficiency in spreadsheet software. This course's emphasis on data filtering and manipulation may be useful for organizing information. The course also covers how to create charts and pivot tables in Excel, which is useful for data analysis and presentations.

See salaries and explore the career path for Urban Planner

Interior designer

An Interior Designer plans and designs interior spaces to meet client needs. This course may be useful by improving proficiency in data entry. Interior Designer's may benefit from the course, especially when they use data in the format of spreadsheets. The course may improve data management and organization. The course teaches how to filter data in Excel. The course teaches how to change the parameter values of objects in Revit, which may also be helpful.

See salaries and explore the career path for Interior designer

Real Estate Analyst

A Real Estate Analyst evaluates real estate market conditions and investment opportunities. This course may be useful in improving spreadsheet proficiency. This role uses data in spreadsheet format. This course emphasizes techniques for using Excel more efficiently, which may be useful. This course teaches how to filter data and conditionally format spreadsheets, which may be useful for data analysis tasks. The course teaches spreadsheet charting techniques, which may be helpful when visualizing information.

See salaries and explore the career path for Real Estate Analyst

Sustainability Consultant

A Sustainability Consultant advises organizations on how to improve their environmental performance. This role works with data and information, and this course may be useful by improving spreadsheet skills. The course focuses on data management, and how to transfer data between software. The course topics of filtering data, using Excel formulas, and conditional formatting might assist in this role. Additionally, this course covers the creation of pivot tables and charts, which might improve data handling and presentation.

See salaries and explore the career path for Sustainability Consultant

Microsoft Excel in BIM and Construction- From Zero

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Practical excel use for bim workflows

Activities

Career center

Reading list

Share

Similar courses