Chapter 12. Using Excel Worksheets and Workbooks

This chapter serves as an introductory overview of Excel 2010. If you're already familiar with a previous version of Excel, reading this chapter is still a good idea. You'll find that Excel 2010 is very similar to Excel 2007. However, both Excel 2007 and Excel 2010 are different from every previous version—very different.

What Is Excel Good For?

Excel, as you probably know, is the world's most widely used spreadsheet program and is part of the Microsoft Office suite. Other spreadsheet programs are available, but Excel is by far the most popular and has become the world standard.

Much of the appeal of Excel is due to the fact that it's so versatile. Excel's forte, of course, is performing numerical calculations, but Excel is also very useful for non-numeric applications. Here are just a few of the uses for Excel:

  • Number Crunching. Create budgets, analyze survey results, and perform just about any type of financial analysis you can think of.

  • Creating Charts. Create a wide variety of highly customizable charts.

  • Organizing Lists. Use the row-and-column layout to store lists efficiently.

  • Accessing Other Data. Import data from a wide variety of sources.

  • Creating Graphical Dashboards

Get Microsoft® Office 2010 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.