Chapter 6. Combining Data from Multiple Sources

Combining Data from Multiple Sources

Chapter 6 at a Glance

In this chapter you will learn to:

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

✓ Work with more than one set of data.

✓ Link to data in other workbooks.

✓ Summarize multiple sets of data.

✓ Group multiple data lists.

Microsoft Excel gives you a wide range of tools with which to format, summarize, and present your data. Once 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 ...

Get Microsoft® Office Excel® 2003 Step by Step now with O’Reilly online learning.

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