Excel: Charts & Functions

- 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