From the course: Excel 2016 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
From the course: Excel 2016 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Exploring font styles and effects3m 17s
-
Adjusting row heights and column widths5m 40s
-
Working with alignment and Wrap Text6m 34s
-
Designing borders2m 55s
-
Exploring numeric and special formatting8m 1s
-
Formatting numbers and dates7m 18s
-
Using conditional formatting8m 13s
-
Creating and using tables11m 18s
-
Inserting shapes, arrows, and other visual features9m 35s
-
-
-
-
-
-
-
-
-
-
-
-
-