Excel has its immense purposeful applications. 95% of the users apply the basic form. There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data.