Uploaded January 2021 | Updated November 2026, 2 days ago
In this video we will learn how to us the BRAND-NEW LAMBDA function in Excel for the beginners and advance users. Simple tricks explain this video how LAMBDA work in Microsoft Excel for mac and you use the same way for windows
00:00 Introduction
00:22 About the LAMBDA Function
01:24 LAMBDA Syntax
01:40 LAMBDA Example 01
03:28 How paste LAMBDA in name manager
05:04 LAMBDA Example 02
08:14 Advantages using LAMBDA in Excel
08:35 How to share the LAMBDA in Excel
09:22 Can it be reference to another workbook?
09:37 End Screen
Spell Number (VBA UDF Function)
excelexciting.com/convert-numbers-to-word-in-excel-spell-number
Download LAMBDA Example file
[WebsiteLink]
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask to queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page:
facebook.com/ExcelExciting
๐ฅJoin the Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
youtu.be/pTVxxaZQx24
Excel with 41Million+ Records & still why UK have Data Loss of COVID-19 Cases ?
youtu.be/YVMTgZsRCGQ
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
youtu.be/xfIPFiAxQcQ
Create Organizational & Business Flowcharts Linked to Excel
youtu.be/Cor1mixgotY
***********************************************************
#LAMBDA #excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
In this video we will learn how to us the BRAND-NEW LAMBDA function in Excel for the beginners and advance users. Simple tricks explain this video how LAMBDA work in Microsoft Excel for mac and you use the same way for windows
00:00 Introduction
00:22 About the LAMBDA Function
01:24 LAMBDA Syntax
01:40 LAMBDA Example 01
03:28 How paste LAMBDA in name manager
05:04 LAMBDA Example 02
08:14 Advantages using LAMBDA in Excel
08:35 How to share the LAMBDA in Excel
09:22 Can it be reference to another workbook?
09:37 End Screen
Spell Number (VBA UDF Function)
excelexciting.com/convert-numbers-to-word-in-excel-spell-number
Download LAMBDA Example file
[WebsiteLink]
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask to queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page:
facebook.com/ExcelExciting
๐ฅJoin the Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
youtu.be/pTVxxaZQx24
Excel with 41Million+ Records & still why UK have Data Loss of COVID-19 Cases ?
youtu.be/YVMTgZsRCGQ
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
youtu.be/xfIPFiAxQcQ
Create Organizational & Business Flowcharts Linked to Excel
youtu.be/Cor1mixgotY
***********************************************************
#LAMBDA #excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks


![Save Email Attachments from Outlook To OneDrive - Power Automate
In this video we will learn how to save email attachments from Outlook Personal account to OneDrive personal. This can also be applicable for work or school account but need to select the correct connector to make sure it works. There are many VBA complex code that can save the email attachments, this is Modern and easy solution with Microsoft Power Automate.
00:00 Intro
00:20 How to Login to Power Automate (formally Microsoft Flow)
00:50 Checking the template galley
01:40 Create Automated Cloud Flow from scratch
05:15 Test the flow
06:55 End Screen
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅ Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Make Cross functional Charts in Excel with Data Visualizer for VISIO
https://youtu.be/1rZWtY_e9D4
Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
๐ฎExcel Trick: Find Leading & Trailing Spaces In Cell
https://youtu.be/BKT-I6OZ9ww
Extract Online Exchange Price
https://youtu.be/3e0G0IISEpI
***********************************************************
#PowerAutomate #PowerAddicts #ExcelExciting #FarazShaikh #Outlook #OneDrive #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #PowerAutomateTricks Save Email Attachments from Outlook To OneDrive - Power Automate](https://i.ytimg.com/vi/uOPJhFCPhNM/mqdefault.jpg)
![Create Excel Table with current sheet name (Excel For Mac & Windows)
In this video, we will see this VBA Code allows you to create Excel Table with the current sheet name using VBA. Usually, when we convert the data into Excel tables by default it is given with the Table1 and later we need to manually rename the table name. With this VBA code, it will take the active sheet name and update it automatically when we convert it to Excel Table.
00:00 Intro
00:29 Understanding the Scenario
00:59 Using Macro Recorder
02:07 Editing the VBA Code
05:09 Copy the VBA Code from Website
05:33 Validation Error Table cannot overlap another table
06:00 Checking the code & Important Notes
07:10 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
Copy the VBA Code from the Website
https://excelexciting.com/convert-active-sheets-data-into-excel-table-by-sheet-name-with-vba/
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila)
https://youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #ExcelVBA #ExcelMacro Create Excel Table with current sheet name (Excel For Mac & Windows)](https://i.ytimg.com/vi/uQOtQtr2nDk/mqdefault.jpg)



![How to share your videos privately on Youtube
In this video, we see how to share your YouTube videos privately and share with others
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#FarazShaikh #ExcelExciting #ProductivityHack #MadeWithCamtasia #YouTube How to share your videos privately on Youtube](https://i.ytimg.com/vi/x42RE3EgmTo/mqdefault.jpg)

![Excel Hash 2021 Challenge - Secret Formula for Sales Commission
In this Excel Hash Challenge 2021, we have some great ingredients to mashup and provide solutions. This is the third edition of Excel Hash Challenge and there are some great participants around the globe. Please feel to check other participants videos & dont forget to give a vote, like & subscribe.
Vote here:
http://bit.ly/ExcelVotingTool
00:00 Intro
00:39 ExcelHash 2021 Ingredients
01:12 Understanding the dataset
01:54 Power Query Custom Data Type
05:54 Cutout Person
06:50 Dynamic Arrays (Unique Function)
08:36 Even Function
10:00 Building Solution as Dashboard
14:24 End Screen
Check out other entries:
https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_
ExcelHash 2021 Ingredients
- A Cutout Person
- EVEN function
At least 2 from the following:
- LET function
- Dynamic Arrays
- Custom Data Type
- LAMBDA function
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Custom functions in Power Query (and more) with Gaลกper Kamenลกek
https://youtu.be/Qf_i45WinRo
How to Leave or Exit an Organization in Microsoft Teams
https://youtu.be/LNJb9Jj_PYI
Insert Data from Picture In Excel for Mac
https://www.youtube.com/watch?v=3-HgzQl7Khw
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://www.youtube.com/watch?v=c8d3xx8KVl8
***********************************************************
#Excel #ExcelHash #Excel2021 #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Excel Hash 2021 Challenge - Secret Formula for Sales Commission](https://i.ytimg.com/vi/xAlUPWRnfiQ/mqdefault.jpg)
