10 Advanced Excel Formula Examples | FREE Excel Course

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

Related Posts

How to Subtract in Excel – Quick and Easy Tutorial

How to Subtract in Excel – Quick and Easy Tutorial

This tutorial shows you how to subtract in Excel. It shows you how to subtract numbers from each other, subtract cells from each other and subtract using the SUM function with negative values. Please subscribe to my channel for more Excel tips.

Subtraction in Microsoft Excel

Subtraction in Microsoft Excel

Subtract values in Microsoft Excel using the minus sign (-). You can subtract cells, individual values, or a mix. For example: =A9-A10 =50-30 =H9-20Learn more at the Excel Help Center: https://support.office.com/excel

Sum Function

Sum Function

Learn how to use the Sum function in Microsoft Excel.

Language »
Thanks !

Thanks for sharing this, you are awesome !