Course Description

Excel is an indispensable tool in the architect’s toolkit. Though not as exciting as other types of software, most architects use Excel at least one a week, if not once a day. Yet most architect never receive any training in Excel. They just figure it out on their own. Spreadsheets are easy, right?

It turns out that Excel is very powerful software for calculating, managing, and presenting data. Excel is a lot more than just simple spreadsheets. Some industries use Excel as their primary tool, much like architects rely on CAD or BIM software.

Learn how to maximize Excel and take advantage of its advanced features in this fun and fast-paced class. You'll never look at Excel the same after this!

Course Objectives

  • Learn the essential steps for creating functional yet beautiful spreadsheets
  • Learn how to properly setup a spreadsheet in Excel using the table feature
  • Understand how to use Excel formulas and learn the most useful formulas for architects
  • Learn how to easily summarize data using Pivot Tables and Pivot Charts
  • Understand how to record macros to automate tedious tasks in Excel

Senior Instructor and Founder of ArchSmarter

Michael Kilkelly

Hi there! I'm Michael Kilkelly. I founded ArchSmarter 2014 as a way to help other architects become more productive and get the best results out of their design software. I’m a native New Englander. I live and work in Middletown, CT. Prior to starting ArchSmarter, I was an Associate at Gehry Partners in Los Angeles. I also worked for a number of design firms in the Boston area. I received my B.Arch from Norwich University and an SMArchS from MIT

Course curriculum

  1. 1

    • 1.0 - Introduction

    • 1.1 - Presenting Data

    • 1.2 - Formulas & Calculating Data

    • 1.3 - Managing Data Using Tables

    • 1.4 - Visualizing Data with Pivot Tables and Pivot Charts

    • 1.5 - Excel Automation

    • 1.6 - Conclusion

    • Sample Files