Chapter 5. Optimizing 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.

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, ...

Get Office 2010 Visual™ Quick Tips now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.