When   Wednesday, November 18, 2009   Time   1:00 AM - 4:00 PM  
Where   Wieboldt Hall 415 339 E. Chicago Ave   map it
Audience   - Faculty/Staff - Student - Public
Contact   HR Training & Development   847-467-5081  
Group   HR: Training and Development
More Info   http://www.northwestern.edu/hr/training/computer.html#excel07

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. Prerequisite: Excel 2007- 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 in 2007 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