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;

DOWNLOAD EXCEL WORKBOOK

 

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:

MOTH-excel_expert470x63

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Rank Largest to Smallest With Excel Pivot Tables 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 RANK LARGEST TO SMALLEST calculation. This option will immediately calculate the rankings (1 being the LARGEST value) for your values, allowing you to pi...
Excel Number Formats – Thousands & Mill... Large numbers in Excel can be formatted so they can be shown in "Thousands" or "Millions". By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions. You can even add som...
Extract Numbers Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is extracting the numbers from your text au...
Drop Down List with Data Validation One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis. You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if y...