Microsoft Excel In Bim- From Zero To Advanced

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 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.

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


Published 8/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.71 GB | Duration: 5h 36m

Download
http://s19.alxa.net/one/2023/08...o.Advanced.rar