Description:

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 2016: Beyond the Basics or equivalent experience/skills. If you have not completed Excel 2016: 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