One of the most overlooked data analysis features in Excel is the ability to turn black-and-white cell ranges into tables. All it takes is a few clicks of the mouse.
The resulting table ends up being more eye-appealing. Additionally, it places many data analysis tools right at your fingertips.
In other words, if you don't use tables when working with Excel, you should. Here are three great reasons why:
Reason 1: Tables can easily format cell ranges
When converting Excel cells into table, Excel automatically applies style formatting. Much like you do when using Word, you can easily change this formatting.
Add or remove banded rows and columns from the Design tab by simply checking the checkboxes as shown in the screenshot below.
Or, make wholesale changes to the table Style using the Styles Gallery.
Reason 2: Do quick calculations by adding the Total Row
As covered in the video below, you can quickly add Totals to your table.
From the Design tab, check the "Total Row" checkbox. You can also add Totals by right-clicking your Table, then selecting "Table" and "Total Row".
Reason 3: Tables automatically fill in formulas and functions
If you compose a formula in one of your Table columns, Excel will automatically autofill the formula for the entire column.
As each column is a separate field, there's no reason the formulas should be different for different rows.
All you have to do is create the formula, hit the "Enter" key. Excel will magically populate the remaining rows in the column.
I cover all of the essentials of table creation in just 7 minutes. You can even watch (and improve) while waiting for your coffee to be made!