This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel basic spreadsheet program into a dynamic and powerful analytics tool. by the end of the course you will be writing robust elegant formulas from scratch allowing you to : Easily build dynamic data, creating your own formula based Excel formatting rules join datasets from multiple sources with XLOOKUP, INDEX and MATCH functions.