Northwestern University

Jan
29
Tue 1:00 PM

HRD176- Excel 2010: Charts and Multiple Worksheets

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

Add Event to Calendar Email Event More Events

Description:

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