O'Reilly logo

Excel 2019 All-in-One For Dummies by Greg Harvey

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 1

Building and Maintaining Data Lists

IN THIS CHAPTER

check Setting up a data list

check Adding data to a data list

check Editing records in a data list

check Finding records in a data list

check Sorting records on values in a data list

check Sorting a list on font color, fill color, or cell icons

check Subtotaling data in a data list

In addition to its considerable computational capabilities, Excel is also very accomplished at maintaining vast collections of related data in what are referred to as database tables or, more often, data lists (which is a little more accurate). This chapter covers all the basic procedures for creating and then maintaining different types of data lists in the Excel worksheet.

This basic information includes how to design the basic data list and then format it as a table so that you can ...

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