Engineers and Geoscientists BC

Please note that the Engineers and Geoscientists BC office will be closed on Monday, April 29, 2024, as staff will be attending an all-day meeting. Regular business hours will resume on Tuesday, April 30.

HomeEventsMicrosoft Excel Expert: Functions, Forms, and Data

Microsoft Excel Expert: Functions, Forms, and Data

Date(s):
Tuesday, April 20, 2021
Registration/Log-In: 8:15 AM–8:30 AM Pacific Time
Webinar: 8:30 AM–4:30 PM Pacific Time
Format:
Webinar
Status:
This course is currently full. If you wish to be placed on the waiting list, and/or be notified of the next scheduled course, please contact Jennifer Chan at [email protected]. Thank you.

7.0 CE Hour(s) of Technical Learning in the Formal Category

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



  • This course is currently full. Another course is scheduled on Monday, May 31, 2021.
  • The authorized Microsoft Manual will be mailed to you upon online registration. Please review your online account and ensure that your preferred mailing address is up to date.
  • Two monitors are highly recommended for the course; or alternatively, one monitor and one tablet screen can work also.  
  • Updated Microsoft 2016 software or higher is required for this course.

Event Details

Cost

Engineers and Geoscientists BC Registrant Early Bird Price: $399.00 + GST = $418.95 until Apr 6, 2021

Engineers and Geoscientists BC Registrant Regular Price: $499.00 + GST = $523.95

Non-Registrant Price: $499.00 + GST = $523.95

Student Price: $250.00 + GST = $262.50

Contact

Jennifer Chan

Event Description

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

Event Presenter(s)

David Poitras
Microsoft Master Instructor
PowerConcepts

About the Event

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

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.




Cancellation Policy
  • “The business name of the Association of Professional Engineers and Geoscientists of the province of BC”