O'Reilly logo

Office 2019 For Seniors For Dummies by Faithe Wempen

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 10

Using Excel as a Database

IN THIS CHAPTER

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

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