Engineers and Geoscientists BC
Our website navigation was recently updated. See what's changed >>

Microsoft Excel Expert Part 2 - Database Management

Date(s):
Friday, April 5, 2024
Registration/Login: 8:15 AM – 8:30 AM Pacific time
Webinar: 8:30 AM – 4:30 PM Pacific time
Format:
Webinar
Status:
Active

Eligible for 7.0 CE Hour(s) of Technical Learning

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


  • Two monitors are highly recommended for the course; alternatively, one monitor and one tablet screen can work.  
  • Updated Microsoft 2016 software or higher is required for this course.

Event Details


Cost

Engineers and Geoscientists BC Registrant Early Bird Price: $429.00 + GST = $450.45 until March 22, 2024

Engineers and Geoscientists BC Registrant Regular Price: $529.00 + GST = $555.45

Non-Registrant Price: $529.00 + GST = $555.45

Student Price: $250.00 + GST = $262.50

Contact

Jen Chan | Senior Continuing Education Coordinator
Direct: 604.412.4861
Toll Free: 1.888.430.8035 ext.4861
Email: [email protected]

Event Presenter(s)


David Poitras
Microsoft Master Instructor
PowerConcepts

About the Event


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 to use Excel to capture potential data errors and minimize input errors, and then how to automate the updating of datasets into Excel tables, and finally, creating and using 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 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 how to use the new Excel’s Business Intelligence (BI) Tools to make updating and analyzing data a breeze.

Skills Checklist

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

  • Creating tables and learning to sort, filter, and report on data with a few clicks;
  • Adding data validation, including using pick lists;
  • Removing duplicate data and circling invalid data;
  • Using data analysis tool;
  • Creating and modifying Pivot Tables;
  • Creating and modifying Pivot Charts;
  • Adding calculations and custom functions within a Pivot Table;
  • Using slicers and filters with Pivot Tables; and
  • Importing data with Power Query.

Instructor Bio

David Poitras 

Microsft 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.