Microsoft Office Tutorials and References
In Depth Information
Chapter 2
Exploring Excel
Workbooks . . . . . . . . . . . . . . . . . . . . . . . .13
The Excel Interface. . . . . . . . . . . . . . . . . . 18
Worksheets . . . . . . . . . . . . . . . . . . . . . . . .14
Formulas . . . . . . . . . . . . . . . . . . . . . . . . . 21
Cells and Ranges . . . . . . . . . . . . . . . . . . .15
If you’re interested in programming Microsoft Office Excel 2003, you’re probably pretty
familiar with the basic layout of an Excel workbook and have a good handle on how to
manipulate workbooks, worksheets, data, and formulas. Even if you are familiar with Excel,
you should at least skim this chapter to see if there are any interesting tidbits that you can use
to make your life easier. But, if you’re comfortable creating scenarios, know how many colors
can be used in an Excel workbook, and have a good handle on how Excel helps you create for­
mulas, feel free to skip right to the next chapter.
Workbooks
The basic unit of organization in Excel is the workbook . In the Microsoft Office hierarchy, an
Excel workbook is at the same level as a Microsoft Word document, a Microsoft Access
database, and a Microsoft PowerPoint presentation. And, just as documents contain sections,
databases are built around tables, and presentations contain slides, Excel workbooks contain
a set of sheets that actually hold the data and other Excel objects. Excel 2003 supports the
following four types of sheets, but you will probably just use the first two of them:
Worksheets
Chart sheets
Excel 4.0 macro sheets (also known as XLM files)
Excel 5.0 dialog sheets (a way to create a custom dialog box)
While you can no longer create XLM files or dialog sheets, Excel 2003 does let you open files
from Excel 4.0 or Excel 5.0 without losing any of the workbooks’ functionality. If you’re work­
ing in a company that has used the same basic workbooks for quite some time, the ability of
Excel 2003 to work with the older files allows a straightforward transition from old to new.
New Excel workbooks come with three worksheets by default, but you can change that value
by clicking Tools, Options, General and typing the desired number of worksheets in the
Sheets In New Workbook box.
Search JabSto ::




Custom Search