20
April 2021

Microsoft Excel Expert: Functions, Forms, and Data

Please Note
  • 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. 
  • Webinar login instructions will be emailed to all registrants 3 days prior to the webinar.
  • We will use your preferred email address only in your online account and you can update the email address anytime by logging into your online account. Please also check your junk/spam email folder if you do not receive the webinar login details.
Status: The event is open
Date: Tuesday, April 20, 2021
Time: Registration/Log-In: 8:15 AM–8:30 AM PST
Webinar: 8:30 AM–4:30 PM PST
Location: Webinar
Presenter: David Poitras
Microsoft Master Instructor
PowerConcepts
Credit: 7 Formal Professional Development Hours (PDH)
Cost: Early Bird Price Engineers and Geoscientists BC Member: $399.00 + GST = $418.95 until Apr 6, 2021

Engineers and Geoscientists BC Member and EIT/GIT Regular Price: $499.00 + GST = $523.95

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

Student Member Price: $250.00 + GST = $262.50
Please Note: *A minimum number of registrations are needed by April 06, 2021 to proceed with this seminar. Please register early to avoid cancellation.
**All prices are subject to applicable taxes.
Contact: Jennifer Chan | Senior Professional Development Coordinator
Direct: 604.412.4861
Toll Free: 1.888.430.8035 ext.4861
Fax: 604.639.8180
Email: [email protected]
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.

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.



View the full listing of events sponsored and organized by other groups.
Contact Professional Development
Email: [email protected]
Phone: 604.430.8035
Toll-free: 1.888.430.8035
View our career listings or place an employment ad.
Presentations for Post-Secondary Students
Email: [email protected]
Phone: 604.412.4860
 
Presentations for High School Students
Email: [email protected]
Phone: 604.412.4892