Jan
29
Tue 1:00 PM

HRD176- Excel 2010: Charts and Multiple Worksheets

export event print e-mail
When: Tuesday, January 29, 2013
1:00 PM - 4: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

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