|
SYNOPSIS:
This course introduces the skills necessary to organize Excel information.
Tasks include using styles, custom formats, and templates; consolidating
worksheets; working with comments and custom views; and sharing workbooks.
Students will also learn how to use auditing tools and the Report Manager.
PREREQUISITES:
Excel users who want to create and use styles templates, and reports.
OBJECTIVES:
l Using
Styles & Custom Formats
l Using Templates
l Consolidating Worksheets
l Working with Comments
l Using Auditing Tools
l Working with Views
l Using the Report Manager
l Sharing Workbooks
DURATION:
Half Day
|
THIS MODULE INCLUDES:
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.
|
