■
Chapter 3, “Create Spreadsheets and Enter Data,” starts by explaining how to create a new
workbook in any of several convenient ways and how to save it, and then shows you how to
create your own templates to use as the basis for future worksheets. You’ll also find out
how to enter data in your worksheets manually and by using Excel’s AutoFill feature, how
to use Excel’s Find and Replace features, and how to recover your work if Excel crashes.
■
Chapter 4, “Format Worksheets for Best Effect,” discusses how to manipulate the worksheets
in a workbook, and then moves on to cover formatting cells and ranges using the many
types of formatting that Excel supports.
■
Chapter 5, “Add Graphics and Drawings to Worksheets,” shows you how to add visual
impact to your worksheets by including pictures, shapes, diagrams, and other graphical
objects. This chapter also explains how Excel’s drawing layer handles graphical objects
and how you can position, resize, and format objects.
■
Chapter 6, “Check, Lay Out, and Print Worksheets,” explains how to get your worksheets
into shape for printing and how to print them. Topics covered include checking spelling,
setting the print area, specifying the paper size and orientation, creating headers and footers,
and using Print Preview to avoid wasting paper. You’ll also learn to set and adjust page
breaks and specify which extra items to include in the printout.
■
Chapter 7, “Perform Calculations with Functions,” covers what functions are and how
you enter them in your worksheets. You’ll also learn about the nine categories of functions
that Excel provides, with examples of some of the most useful functions in each category.
■
Chapter 8, “Create Formulas to Perform Custom Calculations,” starts by teaching you
the basics of formulas in Excel and the components from which formulas are constructed.
After that, you’ll learn how Excel handles numbers, and how to create both regular
formulas and array formulas. The end of the chapter shows you how to troubleshoot
formulas when they don’t work correctly.
■
Chapter 9, “Organize Data with Excel Databases,” shows you how to create Excel
databases, enter data, and sort and filter the data to find the information you need. This
chapter also covers how to link an Excel worksheet to an external database (for example,
an Access database) so that you can extract data to an Excel worksheet and manipulate it
there, and how to perform web queries to bring web data into worksheets.
■
Chapter 10, “Outline and Consolidate Worksheets,” discusses how to outline a worksheet
so that you can collapse it to show only the parts you need and how to consolidate multiple
worksheets into a single worksheet. Both outlining and consolidation can save you welcome
amounts of time.
■
Chapter 11, “Analyze Data Using PivotTables and PivotCharts,” explains how to use
Excel’s powerful PivotTables and dynamic PivotCharts to manipulate your data so that
you can draw conclusions from it. You’ll also learn how to create a conventional (static)
chart from PivotTable data.
■
Chapter 12, “Solve Problems by Performing What-If Analysis,” discusses how to create
data tables that enable you to assess what impact one or two variables have on a calculation.
xvi How to Do Everything with Microsoft Office Excel 2003
HowTo-Tght (8) / How to Do Everything with Microsoft Office Excel 2003 / Hart-Davis / 3071-1 / Front Matter
P:\010Comp\HowTo8\071-1\fm.vp
Friday, August 29, 2003 2:51:50 PM
Color profile: Generic CMYK printer profile
Composite Default screen