BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Link: UCOP's e-newsletter - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://link.ucop.edu
X-WR-CALDESC:Events for Link: UCOP's e-newsletter
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
DTSTART:19701029T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:19700402T020000
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
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
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20220313T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20221106T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20210724T090000
DTEND;TZID=America/Los_Angeles:20210724T090000
DTSTAMP:20260409T133144
CREATED:20210721T183129Z
LAST-MODIFIED:20210721T183457Z
UID:81861-1627117200-1627117200@link.ucop.edu
SUMMARY:Excel Advanced Session 2
DESCRIPTION:Excel Advanced is targeted at experienced Excel users and builds on the key concepts learned from the Introduction and Intermediate courses. Content focuses on importing and exporting data\, formatting numbers\, working with ranges\, working with macros\, data analysis tools\, summarizing data\, using “what-if” data analysis and workgroup collaboration. This full day class is hands-on and highly interactive.\nAfter completing the course\, participants will be able to: • Apply advanced functions\, including logical\, financial\, statistical\, and database functions • Use Data Tables to explore the effects of different input values on a formula • Find specific values or determine the cell address of a specific value with lookup functions • Implement data validation to control which values are allowed in cells • Set up\, use\, and format Pivot Tables to analyze complex data sets • Present results to stakeholders graphically with PivotCharts\, SmartArt graphics\, and conditional data bars or icons • Use text files\, XML files\, Microsoft Queries\, and Web Queries to import and export spreadsheet data • …and much more\nPrerequisite: A strong\, working knowledge of Microsoft Excel required. Completion of Excel Introduction and Excel Intermediate training classes is preferred.
URL:https://link.ucop.edu/event/excel-advanced-session-2/
END:VEVENT
END:VCALENDAR