- Working with functions If, lookup, statistics, logic, date and time, text, information, matrix and link functions
- Dynamic array functions: FILTER, INDIRECT, MTRANS, UNIQUE, SORT, SORTBY, and SEQUENCE
- Nesting formulas and functions, calculations over several worksheets
- Catching error values with functions
- Create and customise matrixes
- Number formatting: User-defined formats and conditional formatting
- Create, edit and design business charts
- Recommended charts and Quick layout
- Optimised charts, data labelling and chart animations
- Quick analysis and sparklines for fast data presentation