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://www.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: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:20240627T090000
DTEND;TZID=America/Inuvik:20240627T160000
DTSTAMP:20260418T015759
CREATED:20240429T164744Z
LAST-MODIFIED:20240429T164746Z
UID:10000467-1719478800-1719504000@www.auroracollege.nt.ca
SUMMARY:Excel Advanced (CMPT 0269) – Instructor-led Online Series - Online / Multi-Day
DESCRIPTION:This 2-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: June 20 & 27\, 2024Time: 9:00 am – 4:00 pmCost: $700.00Instructor: Heather Lyon
URL:https://www.auroracollege.nt.ca/event/excel-advanced-cmpt-0269-instructor-led-online-series-online-multi-day/2024-06-27/
CATEGORIES:Continuing Education Aurora Campus, Inuvik,Continuing Education Thebacha Campus, Fort Smith,Continuing Education Yellowknife North Slave Campus,Continuing Education, Online
ORGANIZER;CN="Karen Horn":MAILTO:KHorn@auroracollege.ca
END:VEVENT
END:VCALENDAR