In this tutorial, you will learn about how to find data in your worksheet by using Lookup functions including Vlookup, Match and Index to help find you what exactly you are looking for. We teach Logical Test Formulas What If analysis by creating alternative scenarios to expand your Analytical abilities. This tutorial will let you learn the amazing Excel Functions and open the doors for creative Data Analysis manipulation.
Learn via Video
Source:
Code:
http://www.exceldummies.com/video/advanced-functions-and-formulas-with-excel-dummies/