Excel - the Brand New Excel Formula Editor Is Here! Episode 2466

Показать описание

Microsoft Excel Tutorial: Take a look at the new Advanced Formula Editor in Excel

Welcome to the MrExcel netcast, where we bring you the latest and greatest updates in the world of Excel. In today's episode, we have some exciting news to share with you - the brand new Excel Formula Editor is finally here! This is a game-changing tool that will revolutionize the way you work with formulas in Excel. So buckle up and get ready to take your Excel skills to the next level.

On February 8th, 2022, Chris Gross published an article on the tech community about the release of Lambda to production. This means that more people can now try out Lambda, but the real game-changer is the new Advanced Formula Editor that works on Windows, Mac, and Excel Online. This means that Lambdas are no longer limited to just the desktop version of Excel. You can now use them on any platform, making your work more efficient and accessible.

One of the most exciting features of the new Advanced Formula Editor is the ability to share and import Lambdas through GitHub. This means that you can easily collaborate with others and access a wide range of pre-made Lambdas to use in your own projects. And with improvements like larger recursion limits and Formula AutoComplete, working with Lambdas has never been easier.

To get started with the Advanced Formula Editor, simply go to the Insert tab and search for "Advanced Formula Environment" in the Get Add-Ins section. Once you add it, you'll see a new tab on the Home tab called "Advanced Formula Environment". This is where you can create, edit, and import Lambdas in their own dedicated editor. And with the ability to sync with the Name Manager, managing your Lambdas has never been more seamless.

But that's not all - the Advanced Formula Editor also introduces a new concept called "namespaces". This allows you to organize your Lambdas into different categories, making it easier to find and use them in your projects. And with the option to import Lambdas from GitHub gists, the possibilities are endless. So go ahead and give it a try, and see for yourself how this amazing new tool will make working with Lambdas a breeze.

We want to give a big congratulations to both the Excel team and Microsoft Research for this amazing partnership that brought us the Advanced Formula Editor. And if you're looking to improve your Excel skills even further, be sure to check out our new courses on the Retrieve platform. These video courses come with complete transcripts in multiple languages, making it easier than ever to learn Excel.

If you enjoyed this video, don't forget to Like, Subscribe, and Ring the Bell to stay updated on all our latest content. And feel free to leave any questions or comments down below - we love hearing from our viewers. Thank you for tuning in, and we'll see you next time for another netcast from MrExcel. Happy Excel-ing!

Table of Contents
(0:00) Walkthrough of new Excel Formula Editor
(0:30) Now use LAMBDA in Excel Online
(0:55) Install the Advanced Formula Enivoronment add-in
(1:30) Syncing formulas from add-in to Excel
(1:42) Import from GitHub Gist
(1:55) Categorizing formulas in a Name Space
(2:34) Easier way to share formulas with co-workers
(3:04) Clicking Like really helps the algorithm

#excel #tutorial

This video answers these common search terms:
Add-Ins
Advanced Formula Editor
Excel formulas
Excel Online
Formula AutoComplete
GitHub
Importing formulas

Big news today for Win / Mac / Online versions of Excel. A new Advanced Formula Editor will make LAMBDA and LET far easier. Among the highlights:
New Advanced Formula Editor (Windows, Mac, Online)
Share Lambda through GitHub
Better Recursion Limits (16x larger!)
Formula AutoComplete

How to use formula editor excel

Read Chris Gross article:

Try downloading Lambda from Gist.GitHub

Рекомендации по теме

Комментарии

Super Great News!! Thank you for sharing!! Great work Excel Team!! Excel future looks brighter than ever. Lambdas will get some real traction now.✌

Excelambda

Wonderful! It's about time there was a formula editor in Excel. I am sure it will make writing, editing and reading complex formulae so much eaiser. Thanks for producing a video to let us know that it now exists!

roywilson

Thanks a lot, once I installed this add-in, lambda became available;) !

forgetittube

Oh! So you're MrExcel! I always used your site. Thanks for all the great help you give! This new editor is a super addition by Microsoft. I always thought we needed a more developer friendly refresh.

UTJK.

Hi Mr. Excel. New formula editor looks awesome and is well needed! Thanks for demonstrating how to install and get started. Thumbs up!!

wayneedmondson

Wow....that looks awesome. Thanks Mr.Excel

mattschoular

Lovely. I'll be looking forward to a cumulative total and value last year fomulas

jtremaria

LAMBDAs promise to improve our workflows. Exciting stuff!

andrewcharlesmoss

Excellent! I did encounter some errors, because I use semicolon-separators. This can be solved by replacing all commas with semicolons before importing the formulas in the Name Manager. Or alternatively change permanently to comma-separator in the intl.cpl -additional settings in Windows)

Andnie

It's certainly going to be a useful feature. Thanks for bringing the news 👍

UpExcel

Wow! This is major! Thanks, Mr.Excel! :-)
PS: what? 16x deeper recursion stack? XLambda, I bet you had a hand in that! LOL! ;-)

GeertDelmulle

I rushed to download this new "advanced formula environment". It should really be named "Named Formula Environment" as it is only for editing formulas tied to named ranges (e.g. Lambda formulas). Too bad it doesn't work on formulas contained inside cells :(

KO