Humber ASHRAE had the pleasure of welcoming Michael McEvenue back to host an Excel workshop for students and branch members in February. Michael is a Humber graduate from the Sustainable Energy Building Technology program and past president of the Humber ASHRAE branch (2011/2012). He was kind enough to donate his time and expertise for us to learn and also capture his workshop on video.
It is uploaded here as a tool for anyone that would like to delve into the useful tips that can help a novice navigate excel software and maximize its potential. It is in two parts as to accommodate the length of the seminar that was held. It begins with a brief background of Michael’s credentials, followed by the topics that will be covered.
Some key topics include:
- Keyboard shortcuts, Tables,
- Data Cleaning & Basic ETL (extract, transform, and load),
- Paste Special,
- Index and Match,
- Conditional Formatting,
- Pivot Tables
Follow along in the exercises using this file: 20170215 – SEBT – Excel Seminar – Michael McEvenue
We hope you enjoyed this workshop, hopefully it helps with your professional development. A special thanks to Michael for putting together a great presentation, as well as Jeff Taylor and Toban Mills for capturing it and making it available to the public.