Office 2007: Top 100 Simplified® Tips & Tricks

Chapter 4. Optimize Excel

You can use Excel to perform a wide variety of number-crunching tasks on data, from the simplest calculation to the most complex formula. You can also use Excel to track and manage large quantities of data such as inventories, price lists, and more. You can even use Excel as a database, entering and sorting records.

Data you enter into Excel is stored in a workbook. Each workbook contains individual worksheets, which hold your data. By default, Excel workbooks have three worksheets, each identified by a tab at the bottom of the screen, but you can add or remove worksheets as needed.

A worksheet is a grid, formed by columns and rows. Columns are labeled with letters, while rows are numbered.

Every intersection of a column ...