BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Aurora College - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Aurora College
X-ORIGINAL-URL:https://www2.auroracollege.nt.ca
X-WR-CALDESC:Events for Aurora College
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Inuvik
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20220313T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20221106T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Inuvik:20231003T000000
DTEND;TZID=America/Inuvik:20240119T235959
DTSTAMP:20260417T103053
CREATED:20231027T234642Z
LAST-MODIFIED:20231027T234645Z
UID:10000337-1696291200-1705708799@www2.auroracollege.nt.ca
SUMMARY:Fall Term 2023
DESCRIPTION:
URL:https://www2.auroracollege.nt.ca/event/fall-term-2023/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Inuvik:20231030T090000
DTEND;TZID=America/Inuvik:20231030T160000
DTSTAMP:20260417T103053
CREATED:20230710T155101Z
LAST-MODIFIED:20230710T155603Z
UID:10000288-1698656400-1698681600@www2.auroracollege.nt.ca
SUMMARY:Excel Advanced – Instructor-led Online Series
DESCRIPTION:This 1-day workshop is for experienced users of the Excel program. In this session\, we learn some of the more advanced features of Excel\, including advanced functions such as lookup\, date & time\, and financial functions; how to nest functions; Data analysis using Pivot Tables and Pivot Charts; and how to perform What-if Analyses. We also learn how to create forms in Excel. Students should have a good understanding of the basics of the program before taking this course. \n\n\n\nFunctions & Formulas \n\n\n\n\nNamed Ranges\n\n\n\nLookup Functions\n\n\n\nDate & Time Functions\n\n\n\nChecking for Formula Errors\n\n\n\nData Verification\n\n\n\nFinancial Functions\n\n\n\nNesting Functions\n\n\n\n\nPivot Tables & Pivot Charts \n\n\n\n\nCustomizing Pivot Tables\n\n\n\nFilters\n\n\n\nData Slicers\n\n\n\nGrouping Data\n\n\n\nCreating a Pivot Chart\n\n\n\nChanging Pivot Chart Options\n\n\n\nDrilling Down\n\n\n\n\nCreating Forms in Excel \n\n\n\n\nAdding Command Buttons\n\n\n\nSpin Buttons and Scroll Bars\n\n\n\nCheck Boxes and Option Buttons\n\n\n\nList Boxes and Combo Boxes\n\n\n\nGroup Box\n\n\n\nText Boxes\n\n\n\n\nPerforming What-if Analysis \n\n\n\n\nUsing the Goal Seek Tool\n\n\n\nWorking with Scenarios\n\n\n\nUsing Cell Watch\n\n\n\n\nDate: October 30\, 2023Time: 9:00 a.m. – 4:00 p.m.Cost: $350.00Instructor: Heather Lyon
URL:https://www2.auroracollege.nt.ca/event/excel-advanced-instructor-led-online-series/
CATEGORIES:Continuing Education Aurora Campus, Inuvik,Continuing Education Thebacha Campus, Fort Smith,Continuing Education Yellowknife North Slave Campus,Continuing Education, Online
END:VEVENT
END:VCALENDAR