Excel Labs is a new Excel add-in built to house experimental Excel features. Right now it contains just two features - the Advanced Formula Environment and the Generative AI Function. The Advanced Formula Environment is a side pane to view your custom LAMBDA formulas and make it easier to reuse them across workbooks. The Generative AI function is a partnership with OpenAI that gives you access to OpenAI's Chat GPT-4 large language model (LLM) right in Excel. It's a handy tool to have while you wait for access to Microsoft's full CoPilot in 365 tool.
Follow these step by step instructions and you'll have Excel Labs installed in just a few minutes.
Don't see your new add in in the Home ribbon? Try switching your active user account in the upper right by the Comments and Share buttons. If that doesn't work try installing Excel Labs directly from the Microsoft website using this link.
Excel Labs is compatible with both the Desktop version of Excel (Windows and Mac) and Excel online. You do need Excel 2016 or later for this to work.
Note - if you already have the Advanced Formula Environment it will no longer be available in your Formulas ribbon. You'll have to access it via Excel Labs.
To use the LABS.GENERATIVEAI() function (wow that's a long one, thank goodness for auto complete of function names in Excel), you'll need a free OpenAI account. You can sign up for one on their website here. After that you'll need to go to create a secret API key in OpenAI here and paste it into the Excel Labs pane. This links Excel to your ChatGPT account and enables the function in Excel.
With that done, it's time to create your first query. Here are some examples, remember to wrap your query in quotes.
=LABS.GENERATIVEAI("is VLOOKUP superior to INDEX MATCH?")
=LABS.GENERATIVEAI("how do I write a LAMDBA function in Excel?")
=LABS.GENERATIVEAI("Perform a sentiment analysis on this email from my boss" & A1)
And here's a sample query from Microsoft that's really interesting, along with it's output:
=TEXTSPLIT(LABS.GENERATIVEAI("Return a table of helpful Excel functions, with 3 columns: name, category, and an example", 0, 1000), "|", UNICHAR(10), TRUE, , "")
Lastly, here are two things to consider when using the new LABS.GENERATIVEAI function:
Happy experimenting in Excel!