When:
Thursday, February 5, 2015
9:00 AM - 12:00 PM CT
Where: Wieboldt Hall North Entrance, 415, 339 E Chicago Ave, Chicago, IL 60611 map it
Audience: Faculty/Staff - Student - Public - Post Docs/Docs - Graduate Students
Cost: NU Employees $115; Non NU Registrants $175
Contact:
Learning & Organization Development
(847) 467-5081
Group: Office of Human Resources | Talent Development & Well-being
Category: Training
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