Excel Seminar 201 Fundamentals and Advanced Tools

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,
  • Slicers,
  • Data Cleaning & Basic ETL (extract, transform, and load),
  • Paste Special,
  • Sumifs,
  • Index and Match,
  • Conditional Formatting,
  • Pivot Tables 

Follow along in the exercises using this file20170215 – SEBT – Excel Seminar – Michael McEvenue

part 1

part 2

 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.

Advertisements