MS Excel has been one of the most popular spreadsheet software programs ever since its inception and its relevance has been growing by the day. One of the main reasons for this is its ability to simplify the process of handling huge amounts of information. Also, when it comes to analyzing large chunks of data, Microsoft Excel has some powerful features to offer. This Advanced Excel tutorial specifically helps in understanding how to analyze large data.

This online Excel tutorial will teach you how to make flexible financial models, derive insights from large data sets and summarize information. This course follows an illustration based approach to teaching these advanced excel functions. There are examples of practical situations that are leveraged to teach all the advanced excel functions.

The following topics are covered in detail in this course:

• List
• Offset
• Sum Product
• Goal-seek
• Index Match (3-Dimensional data)
• Pivot Tables
• Indirect Function

This online Excel Functions course is best suited for learners who are looking forward to building a career as Financial Analysts or Financial Model Designers. Learners who are generally enthusiastic about Excel but are not immediately looking at a career with significant Excel usage can also benefit a lot from this course. As a prerequisite for the course, you are expected to have a basic understanding of MS Excel and its interface.