Structured References
When referring to a Table dynamic Structured References can be used instead of static A1 References.
Style and Structure
Coherent design saves time for the users as they recognize the design and knows what to expect.
Group, Freeze and Split
Group, Freeze and Split functionalities make it possible to view separated data simultaneously.
Conditional Formatting
Conditional Formatting changes how a cell is displayed based on the cell value.
Number Formats
Number Formats are used to change the way numbers are displayed without changing the numbers themselves.
Data Validation
Data Validation is used to force certain predetermined alternatives or value formats when inputting values.
Naming
When using Naming properly your workbooks become more dynamic, with fewer errors, improved readability and traceability.
Tables
Using Tables result in dynamic and more standardized Excel workbooks that saves time and lowers the risk of errors.