Chapter 11

Getting on the Data List


check Setting up a data list in Excel

check Entering and editing records in the data list

check Sorting records in the data list

check Filtering records in the data list

check Importing external data into the worksheet

The purpose of all the worksheet tables that I discuss elsewhere in this book has been to perform essential calculations (such as to sum monthly or quarterly sales figures) and then present the information in an understandable form. However, you can create another kind of worksheet table in Excel: a data list (less accurately and more colloquially known as a database table). The purpose of a data list is not so much to calculate new values but rather to store lots and lots of information in a consistent manner. For example, you can create a data list that contains the names and addresses of all your clients, or you can create a list that contains all the essential facts about your employees.

Creating Data Lists

Creating a new data list in a worksheet ...

Get Excel 2019 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.