Among the Excel features that I like include Tables and easy date filtering.
One user, sethsn wrote the benefits of Excel at an online forum:
- It automatically populates the formula throughout the table – and continues to do so as you extend the table
- It automatically moves cells below the table down to make room for new roles
- You refer to columns by name rather than address which hugely improves readability as well as obviating the need to use absolute references
- It enables autofilter on each column and allows several columns to have filters on them
- The table can be referenced as a unit when used, say, as input to a pivot table
- It automatically formats the tables with alternating row colors to aid readability
- It allows you to total columns by name from outside the table (which, in turn, ensures that your total references the entire table no matter how many rows are added