Excel for BIM Data Transfer: for BIM Modelers and BIM Coordinators- Data Management and Reports
What you'll 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
Requirements
Basic knowledge about Revit and BIM
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.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 RevitConditional Formatting Adding Parameters in NavisworksPlease 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.
Overview
Section 1: Introduction of Excel
Lecture 1 User Interface
Section 2: Creating Table & Border
Lecture 2 Creating Table & Border
Section 3: Conditional Formatting
Lecture 3 Conditional Formatting
Section 4: Sorting Types
Lecture 4 Sorting Types
Section 5: Filtering
Lecture 5 Filtering
Section 6: Charts
Lecture 6 Creating Charts
Section 7: Formula in Excel
Lecture 7 Formula in Excel
Section 8: Pivot Table
Lecture 8 Pivot Table
Section 9: Additional Tips
Lecture 9 Additional Tips
Section 10: Excel in BIM (Importing Tables)
Lecture 10 Importing Tables (Part 1)
Lecture 11 Importing Tables (Part 2)
Section 11: Revit Plugins
Lecture 12 Revit Plugins
Section 12: Exporting Quantities Table
Lecture 13 Exporting Quantities Table (part 1)
Section 13: Sheetlink Plugin
Lecture 14 Sheetlink Plugin (Part 1)
Lecture 15 Sheetlink Plugin (Part 2)
Lecture 16 Sheetlink Plugin (Part 3)
Section 14: Export by Type ID
Lecture 17 Export by Type ID
Section 15: Annotation Categories
Lecture 18 Annotation Categories
Section 16: Editing Elements Parameters
Lecture 19 Editing Element Parameters
Section 17: Exporting Quantities Table (part 2)
Lecture 20 Exporting Quantities Table (part 2)
Section 18: Creating Room (Spatial Tab)
Lecture 21 Creating Room (Spatial Tab)
Section 19: Export Project Standards
Lecture 22 Export Project Standards
Section 20: Data Tools
Lecture 23 Data Tools
Engineers,Architects,BIM Modelers,Project Managers
Screenshots