Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Inside Excel 2010
CHAPTER 11
Inside Excel 2010
What’s in an Excel Workbook? . . . . . . . . . . . . . . . . . . . . . 343
Navigating in Worksheets and Workbooks . . . . . . . . . . 348
Entering and Filling in Data and Series . . . . . . . . . . . . . . 352
Using Formulas and Functions . . . . . . . . . . . . . . . . . . . . . 356
Formatting Cells and Ranges . . . . . . . . . . . . . . . . . . . . . . 376
Perhaps because of its long association with accountants, Excel has a reputation as
staid, even dull. It’s the software equivalent of a gray flannel suit. We think that
characterization is unfair. Yes, it’s true that you can use Excel to count beans and widgets
and calculate profits and losses with incredible precision. But you can also use this
allpurpose tool for tasks that are completely unrelated to numbers. In the four chapters that
begin here, we cover as many of those possibilities as we can.
In this chapter, we cover the nuts and bolts of Excel, with a discussion of what’s in a
workbook and how to navigate through the multiple dimensions of cells, rows, columns, and
worksheets. We also explain how to enter data quickly and accurately.
When you look past the grid-style layout, you can think of Excel as a powerful engine for
performing calculations using numbers, dates, and text. The key to making these
calculations work for you is understanding how to create formulas using arithmetic, logical, and
comparison operators. Most valuable of all is a long list of functions that perform scientific,
engineering, and statistical calculations that would take hours to work out manually. We
cover the full range of Excel’s function library in this chapter.
And finally, we dive into the details of how Excel transforms what you type or paste into
what you see on the screen with a look at number formatting.
What’s in an Excel Workbook?
The sheer breadth of things you can create using Excel is staggering. Starting from a blank
sheet, you can enter simple lists, take inventory of a collection, or prepare a consolidated
financial report for a business of any size. With the right formatting, you can produce
reports that look like they come from a desktop publishing shop, generate easy-to-read
forms, and even construct calendars for use online or on paper. All of these uses start with a
workbook, which is the default document format for Excel.
343
Search JabSto ::




Custom Search