{"id":328,"date":"2014-09-25T17:13:57","date_gmt":"2014-09-25T15:13:57","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=328"},"modified":"2024-02-06T16:02:42","modified_gmt":"2024-02-06T15:02:42","slug":"how-to-insert-an-excel-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-an-excel-table\/","title":{"rendered":"How to Insert an Excel Table"},"content":{"rendered":"

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

1. Structured referencing;
\n2. Many different built in Table Styles<\/strong> <\/span><\/span>with color formatting;
\n3. Use of a “Total Row”<\/span><\/strong><\/span> which uses built in functions to calculate the contents of a particular column;
\n4. Drop down lists that allows you to Sort & Filter;
\n5. When you scroll down from the Table, its Headers replace the Column Letters in the worksheet;
\n6. Remove Duplicate Rows automatically;
\n7. Summarize the Table with a Pivot Table<\/span><\/strong>;
\n8. Supports calculated Columns so you can create dynamic formulas<\/a> outside the Table;<\/p>\n

\n