When   Wednesday, November 18, 2009   Time   9:00 AM - 12: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 needed for mastering Excel's charting capabilities and working with multiple workbooks to illustrate data, relationships, and trends. Participants learn to quickly transform hard-to-read numbers from a table or spreadsheet into professional-looking charts, to update several worksheets at once using 3-D formulas, and to effectively manage large workbooks with multiple worksheets. Prerequisite: Excel 2007 - Beyond the Basics or equivalent skills.

Key Points Create different types of charts Format charts with themes and styles Add titles, gridlines, annotations, and a data table to a chart Work with a 3-D chart Change viewing options, hide and display data, and print large worksheets Insert, delete, rename, move, and copy multiple worksheets Summarize data from different worksheets using the Consolidate command Use 3-D formulas and external links to perform calculations on data from multiple worksheets and workbooks