BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Link: UCOP's e-newsletter - ECPv6.15.20//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:20230312T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20231105T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20240310T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20241103T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20240606T090000
DTEND;TZID=America/Los_Angeles:20240606T120000
DTSTAMP:20260424T123931
CREATED:20240506T213639Z
LAST-MODIFIED:20240506T213639Z
UID:98530-1717664400-1717675200@link.ucop.edu
SUMMARY:Excel PivotTable Techniques
DESCRIPTION:In this workshop you will learn tips and tricks with Excel PivotTables and how they can be an invaluable tool in helping you analyze your data and present your conclusions in compelling ways. If you have been using PivotTables and are wondering what more you can do with them or are maybe running into obstacles and wishing you can get around them\, this workshop will help you unleash the power of PivotTables and get outstanding results. \nThe concepts and techniques that are covered include: \n\nGetting your data ready for PivotTable Reports and Charts including eliminating duplicates\, organizing your data efficiently\, and defining proper relationships between data sets.\nUsing custom functions to perform more advanced analysis and comparisons such as counts\, statistical functions\, % of row\, % of column\, and many more.\nFiltering your report to display subsets of the data and reveal hidden insights about your customers\, product lines\, and other subsets of data sets.\nFormatting your reports\, sorting them automatically\, manually\, or based on pre-determined sort orders\, as well as grouping them based on user-defined groups that reflect your business environment.\nAdding formulas to your PivotTables and Charts so they include the calculations and ratios that are specific to your needs.\nIncorporate your PivotTables reports and Charts into Word documents and linking them so they stay up-to-date
URL:https://link.ucop.edu/event/excel-pivottable-techniques/
ORGANIZER;CN="Learning &amp%3B Development":MAILTO:ucopld@ucop.edu
END:VEVENT
END:VCALENDAR