This week, I had the pleasure of meeting with the pdx Revit User Group at the fabulous Portland AIA to share Excel knowledge gleaned from years of trial and error in my role at Ideate Software. Many people in the room contributed to the discussion both from a technical standpoint and by providing examples of how they use Excel in their Architecture, Engineering, and Construction workflows.
My favorite new tip came from Ideate Software’s Jesika DiGregorio…I did not know that you can use “Alt+Enter” within a formula to help visually organize complex nested formulas without impacting the results!
Thanks to all who attended, welcomed me to your group, and shared your expertise.
You can download the presentation and sample files from here:
- 06-13-17 Portland Revit User Group Presentation: Excel 201=Beyond the SUM
- Sample Files
About the Author
Glynnis Patterson, NCARB — Director of Software Development
Glynnis is a Registered Architect and has worked within the BIM industry since 1998. A graduate of Carnegie Mellon University, she has worked as an architect, educator and construction site manager. Glynnis is currently the Director of Software Development at Ideate Software, and she continues to work with AEC clients worldwide, developing, and consulting on solutions to Building Information Modeling challenges. In her spare time Glynnis does volunteer work for ECLC of New Jersey and Grow it Green Morristown. Follow Glynnis on Twitter.