Excel Labs -Advance formula editor

Have not used this new feature very much, it was on my system then it was gone for a long time, just now figured out how to get it back.  I'm trying to make some dynamic named ranges, using offset an...