Office 2019 For Seniors For Dummies

Chapter 10

Using Excel as a Database

IN THIS CHAPTER

Understand Databases

Prepare a List for a Mail Merge

Store Data in a Table

Sort a Table

Filter Data in a Table

Split a Column’s Content

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 ...