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
Видео 10 Advanced Excel Formula Examples | FREE Excel Course канала TrumpExcel
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
Видео 10 Advanced Excel Formula Examples | FREE Excel Course канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel 2016 Advanced☑️ Top 30 Advanced Excel Tips and TricksCreating Named Ranges in Excel | Dynamic Named Range in Excel | FREE Excel Course5 Advance Excel Formula in HindiExcel Crash Course for Finance Professionals - FREE | Corporate Finance InstituteTop 10 Most Important Excel Formulas - Made Easy!10 Excel XLOOKUP Function Examples (Better than VLOOKUP & INDEX/MATCH)7 Clever Excel Custom Formatting Tricks (Advanced)[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel25 AWESOME Excel Keyboard Shortcuts (You Should Know)!10 Advanced Excel Functions with Downloadable Reference GuideExcel 2016 IntermediateHow to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX19 Advanced Excel Shortcuts (do you know them all?)40 most useful excel formula and functions - excel formulas in hindi - formula tutorial10 Super Neat Ways to Clean Data in Excel50 Ultimate Excel Tips and Tricks for 2020How to use Excel Index Match (the right way)How To Pass Advanced Excel Test For Job Interview