From the course: Excel: Setting Up a Database (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Convert data into tables for enhanced visual and content control

Convert data into tables for enhanced visual and content control

From the course: Excel: Setting Up a Database (Microsoft 365)

Start my 1-month free trial

Convert data into tables for enhanced visual and content control

“

- [Instructor] If you convert a list to a table, you get some immediate visual and formatting features, but more important, you also get some data handling and formula handling capabilities, along with the idea that your data is going to be treated as a unit, as an entity. Now, some of that doesn't quite fall into place until we actually see some examples. This worksheet is called Employees. It's a list of data in columns A through K, some 700 rows or so, and other data off to the right. The next worksheet over is identical, except the data has been converted to a table. And of course, what first grabs our eye is this distinctive look. We refer to it as banded rows. Most tables have this look. Something else that you would not see immediately unless you start to scroll is the idea that those headings in row one in this example here are certainly more important than the column letters. So as we scroll using either the…

Contents