Excel Tables are very powerful and have many advantages when using them.  You should start using them asap regardless of the size of your data set, as their benefits are HUUUGE:

1. Structured referencing;
2. Many different built in Table Styles with color formatting;
3. Use of a “Total Row” which uses built in functions to calculate the contents of a particular column;
4. Drop down lists that allows you to Sort & Filter;
5. When you scroll down from the Table, its Headers replace the Column Letters in the worksheet;
6. Remove Duplicate Rows automatically;
7. Summarize the Table with a Pivot Table;
8. Supports calculated Columns so you can create dynamic formulas outside the Table;



STEP 1: Select a cell in your table

STEP 2: Let us insert our table! To do that press Ctrl + T or go to Insert > Table:


STEP 3: Click OK.

Your cool table is now ready!

Inserting a Table

Helpful Resource:


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Create a Named Range in Excel Whenever I work with spreadsheets, there's no escaping the fact that I have to work with a lot of ranges.Some of these ranges I have to reuse time and time again to create different calculations!Good thing there are Named Ranges in Excel!By using a Named Range, you ca...
Show The Percent of Parent Row Total With Excel Pi... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT ROW TOTAL calculation.This is a new calculation in Excel 2010 and onwards.This option will immediately calculate the percentages f...
Copy The Cell Above In Excel Sometimes we get data that is downloaded from an external source and it is not formatted properly.You may have cells with missing data and cases where you want to copy the cell directly above to fill in your empty cell in Excel.This can be achieved with the following step...
Filter & Search The Search box within the Filter button is powerful if you know how to use it to your advantage.For example, if you had a list of customers the Search box allows you to find specific customers by typing in a few letters only, allows you to add a selection to your filtered lis...