From the course: Excel 2016: Managing and Analyzing Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Converting lists to tables
From the course: Excel 2016: Managing and Analyzing Data
Converting lists to tables
- [Voiceover] On this Worksheet called Table Conversion, we've got a list of data. And clicking on a cell, double-clicking its bottom edge, we can see it goes down to row 762. If you work with lists, particularly lists that grow and shrink, you can treat the data as a unit more comprehensively if you convert the data to a table. Now converting data to a table means that all of this data here is going to have a certain look, it will automatically allow us to add to the table, either at the bottom or on the right hand side, and always be treating the data as a unit, as an entity. Now, if you have worked with some of the data management features in Excel, there's always that concern, "Is all my data being treated together?" In other words, do I have to scroll up and down and check for empty rows and that sort of thing? Or did I add that data at the bottom, is it going to be sorted if I sort all the data? If you convert data to a table, you don't worry about those issues nearly as often…
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.