BEGIN:VCALENDAR
CALSCALE:GREGORIAN
METHOD:PUBLISH
VERSION:2.0
PRODID:-//PlanIt Purple//EN
BEGIN:VEVENT
STATUS:CONFIRMED
LAST-MODIFIED:20120227T090800
URL:https://hrweb.northwestern.edu/psp/hr91prod/EMPLOYEE/HRMS/c/ROLE_EMPLOYEE.NW_SS_TRN_REDIRECT.GBL?course=HRD186
PRIORITY:0
CLASS:PUBLIC
UID:427818@northwestern.edu
SUMMARY:HRD186- Excel 2010: Sorting\, Filtering\, Subtotals\, Pivot Tables
DESCRIPTION:This workshop provides the techniques for mastering some of Microsoft Excel's data-management and analysis features. Participants learn to create a list in Excel to keep track of related data. After a list is created\, it is easy to find\, organize\, and analyze its information with Excel's rich set of list-management features. Feel free to bring your own files to practice with. Prerequisite: Excel 2010- Beyond the Basics or equivalent skills. Key Points Create a structured list to maximize current and future data productivity Format as a Table - new list capabilities Sort a list using several techniques Add subtotals to worksheets without writing any formulas Use the AutoFilter to display only the records that meet one's criteria Examine the new filtering options for Dates and Numbers Create a powerful and flexible custom filter Create Pivot tables and Pivot Charts to summarize a data list Protect a workbook by enabling a password and locking cells to prevent unauthorized changes   https://hrweb.northwestern.edu/psp/hr91prod/EMPLOYEE/HRMS/c/ROLE_EMPLOYEE.NW_SS_TRN_REDIRECT.GBL?course=HRD186
DTSTART:20120313T090000
DTEND:20120313T120000
CREATED:20120131T000000
DTSTAMP:20120131T000000
SEQUENCE:0
LOCATION:Chicago
END:VEVENT
END:VCALENDAR