Today Excel is a must know tool for any business. Programme is design to make you use Excel to solve complex problems, automate spreadsheets, and master graphs for presentations. The Advanced Excel course is guided by an Excel expert and trainer of 5+ years, whose experience with the platform will transform your Excel skills in under a week without the disappointment you are used to.
Working with Formulas/Functions
Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
Working with Formulas/Functions
Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc
