Engineers and Geoscientists BC

Microsoft Excel Expert – Functions, Forms, and Data

Date(s):
Friday, February 3, 2023
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.

Eligible for 7.0 CE Hour(s) of Communications and Leadership Learning

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



  • Two monitors are highly recommended for the course; or alternatively, one monitor and one tablet screen can work.  
  • Updated Microsoft 2016 software or higher is required for this course. 
  • The authorized Microsoft Manual will be mailed to you after the course.

Event Details


Cost

Engineers and Geoscientists BC Registrant Early Bird Price: $399.00 + GST = $418.95 until Jan 20, 2023

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 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)


Shawn May
Trainer, 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

Shawn May

Trainer, PowerConcepts

Shawn began his career with Xerox, gaining unparalleled experience in the technology space, while also establishing himself as a respected Analyst/Trainer and Leader. A dynamic results-driven services and management professional with a proven record of achievement in cross-functional team leadership, services delivery, client relations, and project management he earned a reputation for utilizing creativity, drive, and sound judgment to respond to challenges with solution-oriented ideas. He is now focused on teaching the MS Office productivity suite to both corporate and public clients and is currently working as a Trainer for PowerConcepts and is widely known for providing fun, relevant, and meaningful training, while challenging students to apply what they learn. He currently is proud to call Kelowna home, and spends his spare time paddling, skiing, and walking his two dogs.