课程: Excel 2016: Managing and Analyzing Data

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Converting lists to tables

Converting lists to tables

课程: 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…

内容