6 Reasons to use Tables in Excel
-
Quick totals. If you need to get totals quickly, convert your data into a table and the totals will be calculated for you.
-
Quick formatting. You can quickly format a table using predefined formats in the Table Styles gallery.
-
Simple to sort and filter. Excel’s table function automatically applies filters to the tables. This allows you to quickly sort and select the data you need.
-
Automatic formula fill down. When you use a table in Excel and add a new row for data entry, any formulas in the above rows will automatically fill down.
-
Dynamic Charts. If you create a chart based on a table, on refresh the chart will update with the new data.
-
Quick navigation and selection. Using tables you can quickly navigate around and select rows or columns that you need.
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
