There a lot of awesome stuff you can do with a combination of formulas in Excel.
In this video, I will show you some advanced formula examples that involve using one or more than functions.
I cover the following topics this video:
— Compare Lists, Get Unique List
— Get the Closest Match
— Get Last Value in the List
— Find the Last Occurrence of an Item in a List
— 2 Way and 3 Way Lookup using Index/Match
— Count the Number of Words
— Extract Username from Email Id
— Find the First Monday of the Month
— Extract Data using Drop Down List
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:
TrumpExcel.com | Online Excel Tips & Tutorials (with videos)
-~-~~-~~~-~~-~-
Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel