Using Styles and Custom Formats

Using, applying, creating, modifying, and merging styles; creating a style by example; creating a custom format

Using Templates

Working with, saving, using, and editing templates; inserting new worksheets; creating default templates

Consolidating Worksheets

Consolidate worksheets by category and by position

Working with Comments

Creating, viewing, editing, showing, hiding, deleting, and printing comments; viewing all comments; using the Reviewing toolbar

Using Auditing Tools

Displaying the Auditing toolbar; displaying and removing dependents and precedents; removing tracer arrows; tracing errors

Working with Views

Using views, creating normal and custom views, displaying and deleting views

Using the Report Manager

Use the Report Manager and worksheets in a report, printing and creating a report, using a scenario and a view in a report, reordering report sections

Sharing Workbooks

Using shared workbooks; saving a shared workbook, viewing users and changes, displaying comment boxes, changing the update frequency, highlighting changes, managing and resolving conflicting changes, setting change history options, creating the History worksheet, reviewing tracked changes, merging shared workbook files

Modifying Charts

Creating, applying, and deleting user-defined charts; changing the data source; editing text/axis titles; adding unlinked text; removing/adding axes labels; using and disabling the time-scale axis; using the chart Range Finder; moving a legend; adding data labels and tables

Working with Chart Data Series

Adding and deleting a data series, adding data series/multiple worksheets, editing data series names, changing data series types, adding a trend line, charting non-adjacent ranges

Formatting Charts

Changing patterns, colors, the plotting order, and the axis scaling; creating borders and picture graphs; formatting axes and data markers; adjusting 3-D chart views; scaling a picture graph

Working with Advanced Graphics

Inserting a graphics image; drawing a filled rectangle; changing the graph layering, fill color, and pattern color; adding a pattern; grouping and ungrouping objects

Working with the Data Map

Using the Data Map; organize the map worksheet; creating a basic map; changing the map format type; inserting data into a map; editing a map title and legend

Modifying Maps

Creating a pie map; deleting chart formats; removing and adding map features; adding text to a map; magnifying, moving, and reducing the map; changing pie chart colors; using push-pins and map labels; refreshing the map; printing the Data Map