Using Excel as a Database
IN THIS CHAPTER
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 ...
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.