Between the Sheets — Excel podcast episode 61: Excel’s new Advanced Formula Environment

In partnership with Experts Exchange.

Excel is introducing a panel called the Advanced Formula Environment that manages custom formulas, range names and lambdas. It does what the old Name Manager dialog does plus a lot more. It’s also much less awkward to use. Name Manager isn’t going away anytime soon, but you’ll be able to use AFE instead. It’s currently in beta, so depending on what installation of Excel you have, you may or may not have access to it, yet.



Add a Comment

On Key

Related Posts

Get in touch