BEGIN:VCALENDAR
PRODID:-//planitpurple.northwestern.edu//iCalendar Event//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
CLASS:PUBLIC
BEGIN:VTIMEZONE
TZID:America/Chicago
TZURL:http://tzurl.org/zoneinfo-outlook/America/Chicago
X-LIC-LOCATION:America/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
SEQUENCE:0
DTSTART;TZID=America/Chicago:20261015T171500
DTEND;TZID=America/Chicago:20261015T211500
DTSTAMP:20260926T061949Z
SUMMARY:Kapnick Center - Excel Training (Advanced)
UID:646863@northwestern.edu
TZID:America/Chicago
DESCRIPTION:TO PARTICIPATE IN THIS WORKSHOP\, YOU MUST HAVE A VALID NORTHWESTERN NETID.   Advanced Excel for Business Institutions  *Prerequisite: Must have either previously taken Excel (Basic) Training course or show competency of topics taught in Excel (Basic) Training course.  In the Advanced Excel course you will learn:  Working with List (flat database of data in Excel) o What is a structured list o Format as a Table - new list capabilities o Sort a list using several techniques o Add subtotals to worksheets without writing any formulas o Use the AutoFilter to display only the records that meet one's criteria o Examine the new filtering options for Dates and Numbers o Create Pivot tables and Pivot Charts to summarize a data list Large Spreadsheet o Hide/unhide columns\, rows & sheets o Freeze panes & print titles (review) Multiple worksheets o Grouping worksheets for moving\, copying or printing o Use 3-D formulas to add up through sheets to a summary sheet o Links to perform calculations on data from multiple worksheets and/or workbooks Additional Functions to have in your “bag of skills” for the workplace o Naming ranges for functions o IF statements o VLOOKUP function o DATE360 function o PMT & FV functions o CONCATENATE\, LEFT\, RIGHT\, & MIDDLE functions\n\nMore Info: https://f26-excel2.eventbrite.com/\n\nRegister: https://f26-excel2.eventbrite.com/
LOCATION:Kresge Hall\, 2-530\, 1880 Campus Drive\, Evanston\, IL 60208
TRANSP:OPAQUE
URL:https://f26-excel2.eventbrite.com/
CREATED:20140117T060000Z
STATUS:CONFIRMED
LAST-MODIFIED:20260925T035514Z
PRIORITY:0
BEGIN:VALARM
TRIGGER:-PT10M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR