Microsoft Office Tutorials and References
In Depth Information
Introduction
Excel 2010 Features
With its what-if analysis
tools, research capabilities,
collaboration tools,
streamlined user interface,
smart tags, charting
features, Web capabilities,
hundreds of functions,
and enhanced formatting
capabilities, Excel 2010 is
one of the easier and more
powerful spreadsheet
programs available.
Its dynamic analytical
features make it possible
to answer complicated
what-if questions and its
Web capabilities allow you
to create, publish, view,
share, and analyze data on
an intranet or the World
Wide Web.
requirements
document
Worksheet
Development Cycle
Spreadsheet specialists
do not sit down and start
entering text, formulas,
and data into a blank
Excel worksheet as soon as
they have a spreadsheet
assignment. Instead, they
follow an organized plan,
or methodology, that
breaks the development
cycle into a series of
tasks. The recommended
methodology for creating
worksheets includes:
(1) analyze requirements
(supplied in a
requirements document);
(2) design solution;
(3) validate design;
(4) implement design;
(5) test solution; and
(6) document solution.
Figure 1– 2
Overview
As you read this chapter, you will learn how to create the worksheet shown in
Figure 1–1 on the previous page by performing these general tasks:
Enter text in the worksheet
Total data in the worksheet
Format the text in the worksheet
Insert a chart into the worksheet
Identify the worksheet with a worksheet name
Preview and print the worksheet
Plan
Ahead
General Project Guidelines
While creating an Excel worksheet, you need to make several decisions that will determine
the appearance and characteristics of the i nished worksheet. As you create the worksheet
shown in Figure 1–1, you should follow these general guidelines:
1. Select titles and subtitles for the worksheet. Follow the
BTWs
For a complete list of the
BTWs found in the margins
of this topic, visit the
Excel 2010 BTW Web page
(scsite.com/ex2010/btw).
guideline. The less
text in the titles and subtitles, the more impact the titles and subtitles will have. Use
the fewest words possible to specify the information presented in the worksheet to the
intended audience.
less is more
(continued)
 
Search JabSto ::




Custom Search