Microsoft
Microsoft
Microsoft> But can individual feature be added directly in the menu so that we can easily navigate from any feature to any other feature?
No, not right now. But that is good feedback, thank you. We'll continue to think about the Excel Labs integration into the ribbon.
> My Question is now then: should i use Functions, formulas or Modules, what are the differencese between these, do they have different capabilities, what is considered best practices. Which of these can be viewer within the name manager, is there some of them that cannot be viewed in the name manager ? do there excist some guidlines and learning material that i have failed to find?
Functions and Formulas can be considered the same (if you write a LAMBDA in the Formula section we'll automatically move it over to Functions). The Names tab is designed to be a traditional interface (or improvement) over the Name Manager; I prefer to use it for writing standalone functions or formulas. The Names tab is also synchronized with the Name Manager (so if you edit a name directly in the Excel Name Manager, it will get updated in AFE)
The Modules tab is designed for writing collections of related definitions, and is the format we support importing from GitHub gists. Names that are defined in the Modules tab will appear in the name manager, but the 'truth' is stored in the files - editing the names directly in the manager will cause them to get out of sync.
> Is there a way to point the function at internal data so that it could return something like?:
If the data is in the sheet you can convert the data to a text representation of a table and include that in the prompt you pass to the language model.