Wed 1:00 PM

HRD176- Excel 2010: Charts and Multiple Worksheets


export event print e-mail
When: Wednesday, February 20, 2013
1:00 PM - 4:00 PM  
Where: Wieboldt Hall North Entrance, 415
339 E. Chicago Avenue  
Chicago, IL 60611 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

To register, click the "More Info" link above

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.

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