Construction Industry Training Network (CITN)

Microsoft Excel Advanced 2: Database Management and Analysis (Live Online Training)
Gold Seal: 1 Credit
Date
Wednesday, December 2nd, 2020
Location
Online
Registration Deadline
Wednesday, December 2nd, 2020
Event Description

This interactive, live instructor-led online training course will cover the same content as the in-person course.  All live online courses will be recorded, and participants will have access to the recorded session for 3 months.  

 

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! Learn how Excel will capture potential data errors, minimize input errors and then automate the updating of datasets into Excel table and then into Pivot Tables and Pivot Charts. 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. And also learn how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports. Learn to use the new Excel’s Business Intelligence (BI) Tools that can make updating and analyzing data a breeze.

 

The following list summarizes skills that participants 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 too
  • 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
  • Import data with Power Query

Course Length: 7 Hours

 

This hands-on course is taught by a certified Microsoft Master Instructor. 

 

In order to participate in this course, you will require either two monitors or a second device (tablet) or computer so that you are able to watch the instructor while at the same time practicing and applying the new skills. 

 

Workshop Time: 8:30am - 4:30pm Pacific Standard Time (PST)

Contact & Support

For support or inquiries, please email info@trainingnetwork.ca or call 604-293-2339.

Pricing
All prices in Canadian dollars
Ticket Price
Attendee Registration for Webinar
BC Road Builders Member $235.00
CITN Member $235.00
ICBA Member $235.00
Non-Member $259.00
Agenda
8:30am - 4:30pm
Webinar
Cancellation &
Refund Policy
COURSE REGISTRATION CANCELLATIONS, TRANSFERS & REFUNDS:
 
Cancellations received at least 5 business days prior to the webinar date will result in a full refund.
 
Registrants who do not attend/log into a webinar, and/or who do not notify CITN of cancellation at least 5 full business days prior to the course date will be assessed the full cost of the webinar. There will be no refunds or credits in this case.
 
Substitution of attendees is permitted up to and including the day of the webinar.
 
COURSE CANCELLATION BY CITN:
 
CITN may have to postpone or cancel webinars due to insufficient enrolment, in which case CITN's liability will be limited to a refund of the registration fee.
 
^ Back to Top