O'Reilly logo

Microsoft Office 2010 In Depth by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15. Using Excel Tables and PivotTables

Although we primarily think of Excel as a number cruncher, it also provides a number of capabilities for working with collections of information—databases. Excel enables you to view and manipulate data records and field information in a database table. You can sort records in your table, filter the records, and import or connect to external data sources.

In this chapter, we look at Excel’s database capabilities, including a number of different table manipulation tools and data tools. We also look at grouping and ungrouping ranges in a table and creating subtotals in a table. We wrap up this chapter with a discussion of PivotTables, which provide you with a dynamic way to view and analyze worksheet data. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required