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.

Prerequisite: Excel 2013: Beyond the Basics or equivalent experience/skills. If you have not completed Excel 2013: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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