BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Link: UCOP's e-newsletter - ECPv6.15.18//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:20160313T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20161106T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20170312T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20171105T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20180311T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20181104T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20170511T090000
DTEND;TZID=America/Los_Angeles:20170511T160000
DTSTAMP:20260403T112816
CREATED:20170324T221448Z
LAST-MODIFIED:20170324T221448Z
UID:58847-1494493200-1494518400@link.ucop.edu
SUMMARY:Excel – Pivot Tables
DESCRIPTION:Pre-registration is required for all classes.\nClasses take place in downtown Oakland.\nLog into UC Learning Center (UCLC) to pre-register and see full class description and location.\n\nAn Intermediate Level Excel background is strongly encouraged. \nThe pivot table in Excel is arguably the most powerful tool in the entire Microsoft Office suite. When the success of the organization relies on the ability of its employees to analyze complex data efficiently and quickly\, it is essential that you master pivot tables. A pivot table is a data summarization tool that can automatically sort\, group\, count\, filter\, report\, and summate data with simple dragging and dropping. UCOPs pivot tables training will enhance your ability to manipulate\, analyze\, and interpret large quantities of data and empower you to make effective\, data-driven solutions. \nThrough hands-on lessons in our computer lab\, accompanied by the pivot tables training curriculum\, you will learn to: \n\nImport and prepare large datasets into Excel\nSetup data and create a pivot table\nUnderstand source data considerations\nRespond to changes in source data\nWork with Report Layout options\nGroup PivotTable data and create Calculated Fields\nSort and filter data\nCreate data subsets and extract detail from a pivot table\nCreate a Pivot Chart\nand much more
URL:https://link.ucop.edu/event/excel-pivot-tables/
CATEGORIES:Learning & Development
ORGANIZER;CN="Learning &amp%3B Development":MAILTO:ucopld@ucop.edu
END:VEVENT
END:VCALENDAR