From the course: Excel 2013 Essential Training

Unlock the full course today

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

Creating and using tables

Creating and using tables - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Creating and using tables

“

If you work with large lists of data or lists that you think are likely to become large, you might want to look into the feature called Tables. You can simplify working with data if you convert Data into a Table. This feature primarily gives you the visual coherence to a data, but also gives you some tabulating enhancements, and allows you to treat your data as an entity, and also, it gives you features that are ideal for dynamic data--lists that are going to grow. You can start this process if you have only a title row and one record stored at that point if you wish. This is larger list here about 700 rows. Let's take a look at this Table feature. First of all, in this list there are no empty rows, there are no empty columns. There are some empty cells in Column G, and there could be some else where too, that's not the issue. We don't worry about that. But how do we convert this into a Table? On the Home Tab within the Styles Group, you'll see a choice called, Format as Table. Also…

Contents