
Learn how Excel supports BIM workflows, from templates and ribbons to quick access toolbar, formulas, and sheet management, enabling beam modelers to coordinate with Revit and Navis.
Enter and organize data in Excel by creating a table or using borders. Learn to format cells, apply date, currency, and percentage formats, and use autofill for efficient data entry.
Apply conditional formatting to highlight cells by rules such as greater than, less than, between, or text contains; visualize data with data bars, color scales, and icon sets.
Learn to sort data in Excel for BIM and construction, using table and range sorting with A–Z and Z–A, numeric and color sorts, and custom multi-level rules.
Explore filtering in Excel using sort and filter options, including by color and number, with equals, greater than, and or logic to refine table data quickly.
Learn to create charts in Excel from data, using the insert tab or selecting data, and customize with legends, data ranges, and chart design options for clear analysis.
Master writing Excel formulas and using practical functions like sum, autosum, average, count, min, max, if, sumif, vlookup, and data validation for BIM and construction.
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.