From the course: Excel 2016: Advanced Formatting Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with tables
From the course: Excel 2016: Advanced Formatting Techniques
Work with tables
- We're looking at the worksheet called TableConversion. A feature introduced in Excel 2007 was called a table. Kind of wish it had a different name, because sometimes you talk about pivot tables, a different kind of table. Sometimes the two features are related. But, the idea behind a table is if you work with lists of data. There's a list here. It's scientific data. Don't ask me what these things mean, but perhaps I've been using it or a friend of mine has. It's somewhat dry. It's got a lot of information in it. As we scroll left and right, up and down, it might be easier to see if we could add color to every other row or use some technique to make it easier to read. Now, there are ways to do that, but there is a feature in Excel called a table and although primarily it's a formatting tool, it also gives us some content features as well. Now, you can create a table in a couple of different ways. Before converting data to a table, you want to make sure you have no empty rows within…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.