Chapter 8. Combining Data from Multiple Sources

Chapter at a Glance

Combining Data from Multiple Sources

In this chapter, you will learn to:

Use an existing data list as a template for other lists.

Link to data in other workbooks.

Summarize multiple sets of data.

Group multiple data lists.

Microsoft® Office Excel® 2007 gives you a wide range of tools with which to format, summarize, and present your data. After you have created a workbook to hold data about a particular subject, you can create as many worksheets as you need to make that data easier to find within the workbook. For instance, you can create a workbook to store sales data for a year, with each worksheet representing ...

Get Microsoft® Office Excel® 2007 Step by Step 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.