NEW Advanced Formula Environment - Finally the formula editor we've been waiting for!

Excel 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...

In this Video

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