• Post category:StudyBullet-17
  • Reading time:6 mins read

Microsoft Excel in BIM and Construction- From Zero
Excel for BIM Data Transfer: for BIM Modelers, BIM Coordinators and Engineers- Data Management and Reports

What you will learn

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

Description

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.


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

Content

Introduction of Excel

User Interface

Creating Table & Border

Creating Table & Border

Conditional Formatting

Conditional Formatting

Sorting Types

Sorting Types

Filtering

Filtering

Charts

Creating Charts

Formula in Excel

Formula in Excel

Pivot Table

Pivot Table

Additional Tips

Additional Tips

Excel in BIM (Importing Tables)

Importing Tables (Part 1)
Importing Tables (Part 2)

Revit Plugins

Revit Plugins

Exporting Quantities Table

Exporting Quantities Table (part 1)

Sheetlink Plugin

Sheetlink Plugin (Part 1)
Sheetlink Plugin (Part 2)
Sheetlink Plugin (Part 3)

Export by Type ID

Export by Type ID

Annotation Categories

Annotation Categories

Editing Elements Parameters

Editing Element Parameters

Exporting Quantities Table (part 2)

Exporting Quantities Table (part 2)

Creating Room (Spatial Tab)

Creating Room (Spatial Tab)

Export Project Standards

Export Project Standards

Data Tools

Data Tools