Top 5 features of Excel-

DATA TABLES

Change values in some cells and see the rest of the table dynamically calculate the rest.

PIVOT TABLE

The best way to do quick analysis of a data set.

DATA VALIDATION

Let’s you restrict the type of data input to go in a model. A great way to keep the confidence of your model while allowing others to input data.

POWER QUERY

Let’s you automate and minimize time spent on repetitive tasks. Remove columns or change data types and load directly into your model.

GROUP DATA

For instance Group your chart of accounts into overall accounts and statements. That’ll help give a quick overview of any model you create.