O'Reilly logo

Microsoft® Office 2010 Inside Out by Ed Bott and Carl Siechert

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

Chapter 12. Managing Lists and Data

Sorting Out Your Data Management Options

Formatting and Using Tables

Sorting, Filtering, and Outlining Data

Using PivotTables

Importing, Exporting, and Connecting to Data Sources

EXCEL is no one-trick pony. Yes, the program works wonders with number-crunching tasks, but its rows and columns are also tailor-made for managing data that isn’t expressed in numeric formats. With minimal effort, you can keep address lists and membership rosters, track temperatures and rainfall, monitor stock prices, and record your performance in whatever sport or hobby you happen to fancy.

In this chapter, we look at the many options you have for entering and storing data—including tables in Excel worksheets and direct connections to external ...

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