Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows) @ExcelExciting
Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)  @ExcelExciting
Uploaded February 2022 | Updated November 2026, 5 days ago
In this video, we will learn how to use the Microsoft Excel NEW Advanced Formula Environment (AFE). The new AFE is rich and advanced formula writing experience in Excel. It has made it easy to share and import Lambdas in Excel so we don't need to re-invent the wheel.

Download Links:
1. Life Saver Lambdas: gist.github.com/ExcelExciting/6adf6a3858300e8e49da16968eb1a82c
2. Example Lambdas by MSFT: gist.github.com/chgrossMSFT/d172fd552cf6893bcdc7942223cb0e55

โฑ Time Stamp
00:00 Intro
01:24 How to Download AFE?
02:00 Expanding the AFE
02:28 Copy & Paste Lambda in AFE
03:08 Sync your formulas in AFE
03:56 Edit Lambda with UI
04:29 Import Lambda from GitHub (import from URL)
06:15 Import Lambda with Name Space
06:55 Rename AFE Name Space
07:26 Delete AFE Name Space
07:54 Testing Imported Lambda
08:30 Exploring the Raw Editor
09:08 Creating Lambda with UI
10:07 Rearranging formulas
10:26 Creating Lambda with Editor
11:10 Rename Lambda with Editor
11:20 Accidentally deleted Lambda from Name Manager (Bonus Trick)
13:40 Hidden worksheet in AFE
14:05 End
--------------------------------------------------------------
๐Ÿ›’ 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 queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform 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
I Automated ๐Ÿค– my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU

How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo

Sort Problem With Numbers As Text SOLVED โœ… (Excel for mac & windows)
youtu.be/7phGPaZ89DQ

How to Calculate Hijri Age In Excel (mac & windows)
youtu.be/Cs0MgpppuPA

***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #AFE
Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)Excel Trick# 32 โ€“ Sort Data by Salary Using Python in ExcelCombine Sheet Into One Master Sheet With VBA [Excel for Mac & Windows]Excel Trick# 13 - Separate First & Last Name (Flash Fill) #shorts #exceltips #exceltricksExcel Trick# 3- Convert Numbers to Percentage [Part 01] - #Shorts  #exceltips #excel  #exceltricksHow and when to use LAMBDA Function in Excel for Mac & WindowsApple Watch Series 7 Nike Edition (Unboxing & Setup) โŒš๏ธI Automated ๐Ÿค– my Meetup Event with Power Automate Desktop & ExcelSave Email Attachments from Outlook To OneDrive - Power AutomateCreate Excel Table with current sheet name (Excel For Mac & Windows)How To VLOOKUP & Handle VLOOKUP Error #NA In ExcelBest Practice Financial Modelling with Danielle Stein Fairhurst
Faraz Shaikh |

Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER