The most important thing after you create a table – Give it a name
Today we will learn 10 excel data table tricks that will make you a data guru, no let’s make that DATA GURU. To create an excel table, all you have to do is select a range of cells and press the table button from Insert ribbon in Excel (or use the shortcut CTRL+T). How to create table from a bunch of data?
Excel will take care of everything thus making you a data guru. When you make a table (more on this in a sec) you can easily add more rows to it without worrying about updating formula references, formatting options, filter settings etc. Table is your way of telling excel, “look, all this data from A1 to E25 is related.
Excel tables, (known as lists in Excel 2003) is a very powerful and super-cool feature that you must learn if your work involves handling tables of data. Excel table is a series of rows and columns with related data that is managed independently.
