Chapter 10

Using Excel as a Database


Bullet Understand Databases

Bullet Prepare a List for a Mail Merge

Bullet Store Data in a Table

Bullet Sort a Table

Bullet Filter Data in a Table

Bullet Split a Column’s Content

Bullet Merge the Contents of Columns

Besides calculations, the other main reason people use Excel is to store tabular data. For example, Excel works great to store the names and addresses of the people you send holiday cards to every year, or to store a home inventory that you create for insurance purposes.

Although spreadsheet programs like Excel weren’t originally created for this purpose, software designers quickly figured out that a lot of people were using Excel to hold lists of data, so they built in features to help do that more effectively. In this chapter, you can read about several Excel features ...

Get Office 2019 For Seniors For Dummies 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.