Home
Username:
Password:
Microsoft Excel 2000 Tutorials

Introduction / Workbooks & Worksheets

Subtitles of the Movie

Workbooks are the files you create when working with Microsoft Excel. One of the features of Excel is that workbooks can be divided into individual worksheets for storing smaller amounts of data. In this sample workbook for 1999 records, there are three sheets: one for bills; one for expenses; and the third for a summary of the year. Each worksheet contains data regarding that particular topic. The entire workbook, deals with all of our financial data for 1999. This first worksheet bills, contains a leftover row. This is what is leftover from our paycheck after all of the bills have been paid. These cells are then carried over onto the expenses sheet. These totals then are what's left after paying the bills and then we subtract our expenses from that amount. Some of this data is then linked into the summary sheet where we have a summary of both our bills, and our expenses at the bottom. This keeps each spreadsheet a manageable size within the workbook. t a manageable size within the workbook.

Tutorial Information

Course: Microsoft Excel 2000
Author: Lorie Flenner/NMG
SKU: 33101
ISBN: 1889347868
Release Date: 1999-11-22
Duration: 8 hrs / 103 lessons
Captions: For Online University members only
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

VTC Sign up & Benefits

  • Unlimited Access
  • 98,729 Video Tutorials (23,265 free)
  • Video Available as Flash or QuickTime
  • Over 1026 Courses
  • $30 for One Month Access
  • Multi-User Discounts Available