[UPDATE] This tool is now called Excel Labs.

Excel Labs, previously called the Advanced Formula Environment, is a long awaited new improved way to write, name and store Excel formulas.

Download the example file here: https://www.myonlinetraininghub.com/e...

Github Gist file link: https://gist.github.com/jack-williams...

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy  

0:00 Introduction
0:26 Where to get the Advanced Formula Environment
0:51 Working in the Grid environment
2:44 Working in the Names environment
3:00 Using the AFE to write LAMBDAs
4:46 Generating LAMBDAs from existing formulas
7:13 Working in the Named Ranges environment
7:23 Working in the Named Formulas environment
8:08 Working in the Modules environment
9:44 Name Manager
9:59 Localisation