Engineers and Geoscientists BC
Our website navigation was recently updated. See what's changed >>

Microsoft Excel Expert Part 1 – Forms and Functions

Thursday, March 28, 2024
Registration/Login: 8:15 AM – 8:30 AM Pacific time
Webinar: 8:30 AM – 4:30 PM Pacific time
Registration is now full

Eligible for 7.0 CE Hour(s) of Technical Learning

Don't have an account with us?
Create an account to register for this event.

  • Two monitors are highly recommended for the course; alternatively, one monitor and one tablet screen can work.  
  • Updated Microsoft 2016 software or higher is required for this course. 

Event Details


Engineers and Geoscientists BC Registrant Early Bird Price: $429.00 + GST = $450.45 until March 14, 2024

Engineers and Geoscientists BC Registrant Regular Price: $529.00 + GST = $555.45

Non-Registrant Price: $529.00 + GST = $555.45

Student Price: $250.00 + GST = $262.50


Jen Chan | Senior Continuing Education Coordinator
Direct: 604.412.4861
Toll Free: 1.888.430.8035 ext.4861

Event Presenter(s)

David Poitras
Microsoft Master Instructor

About the Event

If you are experienced in Excel but need to start building more complex calculations and sequential operations, then join us for this advance Excel course to learn how to assemble complex operations simply, one step at a time. Also, learn to manage multiple sheets or multiple books and to apply protection, navigation, and form controls.

Skills Checklist

The following list summarizes skills that students will be comfortable with after this course:

  • Use advanced functions such as:
    • Information
    • Lookup and reference
    • Conditional logic
    • Conditional summary
  • Create, modify, or remove a hyperlink
  • Work with shared workbooks
  • Add protection to workbooks and worksheets
  • Track changes
  • Consolidate data
  • Create and run macros
  • Add form controls

Instructor Bio

David Poitras

Microsoft Master Instructor, PowerConcepts

David was born and raised in Kelowna. He graduated from Okanagan College in 1992 with a diploma in Computer Informative Systems. Afterwards, he worked in information technology as a programmer for Okanagan College for 5 years and taught various Microsoft programs in Continuing Studies at Okanagan College. He also had his own software development company for 25 years. He built custom Microsoft software solutions for small to midsized companies in the Okanagan and Lower Mainland. He has been teaching at PowerConcepts for many years and has expert knowledge in all Microsoft Applications.