BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Construction Industry Training Network - ECPv6.15.18//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Construction Industry Training Network
X-ORIGINAL-URL:https://trainingnetwork.ca
X-WR-CALDESC:Events for Construction Industry Training Network
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Vancouver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20190310T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20191103T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20200308T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20201101T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20210314T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20211107T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Vancouver:20200909T080000
DTEND;TZID=America/Vancouver:20200909T163000
DTSTAMP:20260407T141239
CREATED:20200811T194407Z
LAST-MODIFIED:20200811T194407Z
UID:9818-1599638400-1599669000@trainingnetwork.ca
SUMMARY:WEBINAR: Microsoft Excel Advanced 2: Database Management and Analysis
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. \nNeed 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. \nThe following list summarizes skills that participants will be comfortable with after this course. \n\nCreate tables and learn to sort\, filter and report on data with a few clicks\nAdd data validation\, including using pick lists\nRemove duplicate data\, circle invalid data\nUse data analysis too\nCreate and modify Pivot Tables\nCreate and modify Pivot Charts\nAdd calculations and custom functions within a Pivot Table\nUse slicers and filters with Pivot Tables\nImport data with Power Query\n\nCourse Length: 7 Hours \nThis hands-on course is taught by a certified Microsoft Master Instructor. \nIn 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.  \nWorkshop Time: 8:30am – 4:30pm Pacific Standard Time (PST) \n Register Now!
URL:https://trainingnetwork.ca/event/webinar-microsoft-excel-advanced-2-database-management-and-analysis/
LOCATION:Online
CATEGORIES:Business
END:VEVENT
END:VCALENDAR