ZDNet
Free Membership

Search Help



Help Channel
 Windows
 Macintosh
 Linux
 Internet
 Hardware
 Office
 Healthy PC
 Applications
 Games

TipZone
Bugs!
Q&A
How Do I…?
Downloads
Books
Ask the Experts
Help Tools
Newsletter



X10.com - The SuperSite for Home Automation!

Newsletter



ZD3D

jobEngine

 
  GAMES
  UTILITIES
  PALM PILOTS
 SCREENSAVERS
 BUSINESS
 GRAPHICS
 INTERNET
 MAC
 AND MORE!



Reviews | News | Downloads | Shop | Auctions
Books
 
   TipZone find help with…




  NEXT <

 Return To
> Excel Annoyances
main page
 
Page Tools
print Print this page

 
How Excel Works

By Woody Leonhard, Lee Hudspeth, and T.J. Lee

Excel is a feature rich development environment that is limited primarily by the user's imagination. And the central canvas for this development effort is the workbook. This is the file Excel produces to hold the various worksheets, charts, macros, etc., that make up your model.

Now, before you toss this book as a boring jargon feast, let's define some terms. Development environment simply means that if you want something in Excel you're gonna have to build it yourself, or use a template that someone else has built for you. This can be as simple as saying, "If you want to add up a column of numbers in Excel you're going to have to input the numbers, and create a formula to sum them." The term model we use to mean this "thing" that you're going to build. We could say document to mean the same thing, so don't let the stuffy terms throw you.

In this chapter, we'll start off with the workbook and drill down through the basics of model building.

NEXT<

 Sections In This Chapter
Introduction
Working with the Workbook
  The Book You Save
  Backward Compatibility Issues
  Fitted Sheets
  Constants and Formulas
Working with Data
  AutoEntry
  AutoFill
  Data Validation
  The Editing Room
Working with Names, Formulas...
  Range Names and Labels
  Formulas and Functions


  
Reviews | News | Downloads | Shop | MyZDNet | Games | ZDTV | Forums

AnchorDesk | PC Magazine | PC Week | Help! | Yahoo! Internet Life

HOME | FREE MEMBERSHIP | CONTACT ZD | AD INFO | ZIFF-DAVIS
 
Use of ZDNet is subject to certain Terms & Conditions
Please read ZDNet's Privacy Statement

Copyright (c) 1999 ZDNet. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of ZDNet is prohibited. ZDNet and the ZDNet logo are trademarks of Ziff-Davis Inc.