Engineers and Geoscientists BC

Microsoft Excel Expert: Database Management

Tuesday, January 25, 2022
Registration/Log-In: 8:15 AM–8:30 AM Pacific Time
Webinar: 8:30 AM–4:30 PM Pacific Time
This course is currently full. The next course is schedule on Thursday, March 3, 2022. 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


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

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


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]

Event Presenter(s)

David Poitras
Microsoft Master Instructor

Event Description

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.

About the Event

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.


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.