Index, Match, Offset, and What IF Analysis (Goal Seek, Data Table & Scenario Manager) with Examples. This course will enhance the knowledge of Excel users to understand the Advanced function with examples in an easy way. Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork, and even personal data organization.