Excel 2003 Working with Workbooks
Objective
Learn to organize your worksheets effectively by storing them
in workbooks. Also learn to share data within a workbook, from
workbook to workbook, and with other users.
Prerequisite Skills
Course Description
Are you currently saving every Excel spreadsheet in a separate
file? Did you know you can have multiple pages in a one Excel
file called a "workbook?" Did you know you could create
formulas that span multiple worksheets? Did you know you could
share workbooks with other users?
Attend this course if you want to:
-
Learn how to keep related spreadsheets in one workbook file.
-
Name worksheet pages for easy retrieval.
-
Change the color of worksheet tabs.
-
Insert, delete, and move worksheets to where you want them.
-
Change the default number of worksheets in new workbooks.
-
Copy a worksheet within a workbook or to another workbook
(to use as a template for new data).
-
Group worksheets and simultaneously edit or format the data
on all the worksheets.
-
Create formulas that span multiple worksheets.
-
Hide worksheets to reduce the number of worksheet tabs and
prevent undesired viewing.
-
Print workbooks or selected sheets within the workbook.
-
Share workbooks with other users for simultaneous updates.
-
Assign a password to prevent unauthorized people from reading
and/or editing the workbook.
-
Protect specific cells in a worksheet so they can't be modified
until unprotected.
-
Hide formulas from others using the workbook.
Class Length
90 minutes
Delivery Options
-
Virtual classroom - public
($70 per student; check times and register here)
-
Virtual classroom - dedicated (up to ten
people from the same organization)
($480 per class; contact us for
more details)
-
Virtual classroom - one on one
(Register for a 45-minute 1-on-1
Application Support session. Cost is $70 per student per
session.)
-
On-site instructor-led
(Contact us for details)
