Susan Fuschetto
CIS 151 Excel For I.T.
Excel Tutorial 6 - Managing Multiple Worksheets and Workbooks
This
tutorial is about working with multiple worksheets in the same workbook;
linking workbook files; and a new feature saving files to the SkyDrive.
You will learn how to enter formulas and apply formats across multiple
worksheets at one time. Also, you will create formulas with 3D
references. Usually you are using two dimensional references
referring to the column letter and row number. Now you will create
formulas that reference cells in another worksheet thus adding a third
dimension the worksheet name. You will also create formulas with
3D references in other workbook files. This links the files
together for easy automatic updates.
New to Office 2010 on the File tab, Save &
Send option is the ability to save files to the SkyDrive at the Windows
Live website. Tired of carrying flash drives with you? If
you have access to the Internet, then you will be able to access,
update, and save files to the SkyDrive. It is 25 GB (gigabytes) of
free space. Ever loose a flash drive? Backup your files to
the SkyDrive just in case you loose the flash drive. If you
already have a hotmail or msn email account you may already have a
SkyDrive. Login to your account and then click Windows Live,
SkyDrive. If you do not have an account, then please create an
account following the steps on page EX349. Please note you can use
any email address. Also, some people create a new email account
and then use that account for their SkyDrive.
Please read all of the directions before
getting started on the assignment.
- Please note: Throughout the book it
will instruct you to save your files. In the computer labs on
campus you will need to save the files to your USB drive. If
you are using your own computer, then you may save the file to the
drive of your choice (hard drive, USB, etc.).
- Data file notes: In order to do this
assignment you will need a set of files. The files are in TalonNet
on the Resources page in the Data Files folder. The data file links
are .zip files (compressed
set of files). You will need to download and unzip
(uncompress) the files before using them. Right-click the file
link to get the shortcut menu. Select the Save Target As
option and save the file to your drive. You will then need to
unzip (uncompress) the .zip file. If you are not
familiar with unzipping files please read pages FM17 - FM19 or read the
Unzipping Files
document for a
general set of instructions. The example is from my CIS 101
class.
- Read and do the steps in Excel Tutorial
6 pages
EX301 - EX352.
- Do Case Problem 1 (Java Cafe) on pages EX354 - EX355. When you are done your
spreadsheets should look like this
document.
Please note there are multiple pages in the answer documents so
click the Next Page arrow to see all of the pages.
- Online students: Since
there are more than 5 files you will have to zip/compress the files
in to a compressed/zipped folder and then upload the files to the
assignment in TalonNet. Submit the following files:
Audited 2013.xlsx,
New Mexico.xlsx,
Theme Parks.xlw,
Travel Template.xltx,
New Mexico 2014.xlsx,
SkyDrive New Mexico 2014.xlsx,
Java Cafe.xlsx,
Java Cafe 2014.xlsx,
Java Template.xltx and
SkyDrive Java Cafe 2014.xlsx in a
zipped/compressed file to
the Excel Tutorial 6 assignment on the class website in TalonNet.
Please do NOT submit the files in .rar compressed format.
If you do not know how to compress/zip files here are
two example documents:
Windows XP/Vista and
Windows 7.
- Traditional students:
During the lab time show the
above
files listed in step 5 on your computer screen to me.
Last update:
03/07/11 |
