In this video, I will show you some advanced Excel formula examples that involve using one or more than functions.
There a lot of awesome stuff you can do with a combination of these advanced formulas in Excel.
While a lot of things can be managed with in-built Excel functions, sometimes you need to use a combination of these formulas to get the work done.
This video covers 10 such examples where you can use advanced excel formulas (including a combination of in-built Excel functions) to achieve the desired result.
I cover the following advanced formula examples 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
Again, the combination of formulas you need to use will depend on what you want to achieve, but these advance excel formula examples will give you a lot of ideas on how you can mix and match formulas and use the result from one formula as an input for another formula. It also covers array formulas, where you need to use Control + Shift + Enter instead of a simple Enter.
☕ If you’re the videos useful and would like to support me, you can buy me a coffee – https://www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training 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: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Free Excel Course – https://trumpexcel.com/learn-excel/
Paid Online Training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic – https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
