Northwestern University

Jan
29
Tue 9:00 AM

HRD186- Excel 2010: Sorting, Filtering, Subtotals, Pivot Tables

When: Tuesday, January 29, 2013
9:00 AM - 12:00 PM  

Where: Parkes Hall Lot, 127
1950 Chicago Ave  
Evanston, IL 60208 map it

Audience: Faculty/Staff - Student - Public

Costs: NU Employees: $90 - Non NU Registrants: $150

Contact: Learning & Organization Development   847-467-5081  

Group: Learning & Organization Development

Category: Training

More Info

Add Event to Calendar Email Event More Events

Description:

To register, click the "More Info" link above

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.

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