BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Construction Industry Training Network - ECPv6.15.20//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:20180311T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20181104T090000
END:STANDARD
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Vancouver:20190925T080000
DTEND;TZID=America/Vancouver:20190925T163000
DTSTAMP:20260415T025158
CREATED:20190305T235933Z
LAST-MODIFIED:20190305T235933Z
UID:8297-1569398400-1569429000@trainingnetwork.ca
SUMMARY:Microsoft Excel (Advanced) - Burnaby
DESCRIPTION:Save hours and minimize errors by learning how to manage data and reporting through tables and with the use of pivot tables\, graph data and be able to make dynamic charts and identify trends with trend lines. \nBuild error proof data entry sheets through the use of data validation techniques so that reporting is virtually error free. Learn to use advanced functions like Vlookup\, If function and build complex nested functions with ease. \nCome with your questions and learn tips\, shortcuts and how to program simple macros from a Microsoft Master Instructor. \nThe following list summarizes skills that participants will be comfortable with after this course. \n\n Use advanced functions such as\no Information\no Lookup and reference\no Conditional logic\no Conditional summary\n Add data validation\, including using pick lists\n Remove duplicate data; circle invalid data\n Create\, modify or remove a hyperlink\n Work with shared workbooks\n Add protection to workbooks and worksheets\n Track changes\n Use data analysis toolsc\n Create and modify PivotTables or PivotCharts\n Use slicers with PivotTables\n Create and run Macros\n Add form controls\n\nThis hands-on course is taught by a certified Microsoft Master Instructor. Participants will receive authorized Microsoft manuals and Microsoft approved practice exercises. \nAll participants will be provided with laptops for the course. \nMax participants: 12 \n Register Now!
URL:https://trainingnetwork.ca/event/microsoft-excel-advanced-burnaby/
LOCATION:Accent Inn\, 3777 Henning Drive\, Burnaby\, British Columbia\, V5C 6N5\, Canada
CATEGORIES:Business,Equipment Training
END:VEVENT
END:VCALENDAR