February 2023

Microsoft Excel Expert – Database Management

Please Note
  • 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.
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.
Date: Monday, February 13, 2023
Time: Registration/Log-In: 8:15 AM–8:30 AM Pacific Time
Webinar: 8:30 AM–4:30 PM Pacific Time
Location: Webinar
Presenter: Shawn May
Trainer, PowerConcepts
Credit: Eligible for 7.0 CE Hour(s) of Communications and Leadership Learning
Cost: Engineers and Geoscientists BC Registrant Early Bird Price: $399.00 + GST = $418.95 until Jan 30, 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
Please Note:
  • Student Price is eligible for participants in Engineers and Geoscientists BC’s Student Program
  • If you are not an Engineers and Geoscientists BC registrant, and you do not already have an existing account, please proceed to creating a new account to create a profile before completing your event registration
  • For webinar sessions, the webinar login instructions will be made available 3 business days prior to the webinar date
  • A minimum number of registrations are needed by January 30, 2023 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]
Need to do time tracking of various staff on various projects? Need to download reams of data from an online data source? Now you need to make sense of it all! Through this workshop, you will learn how Excel will capture potential data errors, minimize input errors, and then automate the updating of datasets into Excel tables, and then into Pivot Tables and Pivot Charts. You will also learn strategies for collecting and validating data with tables; understand how to automate the collection and cleaning up of data using Power Query, and then how to analyze with Pivot Tables; how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports; and also learn how to use the new Excel’s Business Intelligence (BI) Tools that can make updating and analyzing data a breeze.

Skills Checklist

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

  • Create tables and learn to sort, filter, and report on data with a few clicks;
  • Add data validation, including using pick lists;
  • Remove duplicate data; circle invalid data;
  • Use data analysis tool;
  • Create and modify Pivot Tables;
  • Create and modify Pivot Charts;
  • Add calculations and custom functions within a Pivot Table;
  • Use slicers and filters with Pivot Tables; and
  • Import data with Power Query.


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.

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
Presentations for Post-Secondary Students
Email: [email protected]
Phone: 604.412.4860
Presentations for High School Students
Email: [email protected]
Phone: 604.412.4892