|
SYNOPSIS:
This course covers basic techniques for managing large or multiple worksheets.
It includes tasks such as using large worksheets, Paste Special, range
names, labels in formulae, and multiple workbooks. The student will also
learn how to manage worksheets and work with multiple sheets and outlines.
PREREQUISITES:
Users familiar with the basics of Excel 2003 who want to work with large
and/or multiple worksheets.
OBJECTIVES:
l Using Large Worksheets
l Working with Multiple Sheets
l Working with Columns/Rows
l Managing Worksheets
l Working with Outlines
l Using Paste Special
l Using Range Names
l Using Labels in Formulae
l Using Multiple Workbooks
DURATION:
Half Day
|
THIS MODULE INCLUDES:
Using Large Worksheets
Increasing and decreasing the magnification; changing range magnification;
switching to Full Screen view; splitting the window; removing, freezing
and unfreezing panes.
Working with Multiple Sheets
Using multiple worksheets; navigating between, selecting single and
multiple, renaming, inserting, deleting, and printing selected worksheets.
Working with Columns and Rows
Selecting columns and rows; changing column widths and row height; adjusting
columns automatically; hiding, unhiding, inserting, and deleting rows
and columns.
Managing Worksheets
Copying and moving worksheets, using grouped worksheets and functions
in worksheets, moving and copying data between sheets, creating 3-D formulae.
Working with Outlines
Applying, expanding, collapsing, and clearing an outline, modifying outline
settings, using Auto Outline.
Using Paste Special
Using Paste Special; copying formats, values, and formulae between sheets;
performing mathematical operations.
Using Range Names
Using Range names; assigning, applying, deleting, and jumping to
a named range; using range names in formulae and 3-D formulae; creating
names from headings; naming and referencing 3-D ranges.
Using Labels in Formulae
Using labels in formulae, labels to define a range, and multiple stacked
headings; identifying individual cells.
Using Multiple Workbooks
Opening multiple workbooks, cascading and tiling windows, activating tiled
and cascaded windows, copying text between workbooks, opening and saving
a workspace, closing all open windows.
|
