From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Creating and using tables

Creating and using tables

From the course: Excel 2016 Essential Training

Start my 1-month free trial Buy for my team

Creating and using tables

“

- If you work with lists of data, maybe a personnel, an HR kind of list, like we're seeing here, or an inventory list or a transaction list, something like that. As lists grow or shrink, you can facilitate the management of them with a feature called a Table. On the Home tab, you might see Format as Table in the Styles group. Now the description there doesn't exactly give you a rationale for using this feature. It says, Quickly convert a range of cells to a table with its own style. On the Insert tab you'll see the same feature, with a much better description: Create a table to organize and analyze related data. Tables make it easy to sort, filter and format data within a sheet. Now the term I've used is Entity. We want to treat this data as an entity. Let's convert it to a table. There are two keystroke shortcuts we could use, either Ctrl +T, think of T for Table, Ctrl + L, think of L for List, or on the Insert or Home tab, I'm going to use Insert tab here. Now, before doing this…

Contents