The MS Excel advanced level is considered the developer level, and hence, tests the candidate’s ability to look beyond the basic functions and features of this program. If you are planning to take up the Excel advanced certification, you should prepare to get thorough with core functions such as data analysis, complex calculations, etc. You should also be prepared to answer questions relating to write VBA codes in the form of sub procedures, how to use all the features of the DEVELOPER tab, how to use and interpret user defined functions, how to build entry forms for data inputs and updates, and so on. As mentioned, an advanced Excel user carries out the role of a developer.