Excel is a powerful tool for data analysis, but did you know that there is a new function that provides the power of generative AI in Excel. The experimental LABS.GENERATIVEAI function allows you to send prompts from within Excel to a generative AI model and then return the results from the model back to your …
The Excel and SQL Server experts blog
AI in Excel: the LABS.GENERATIVEAI function
Andy McDonald - Aug 30, 2023How to Use XMATCH: Guide and Examples
Andy McDonald - Aug 18, 2022In a previous post, we looked at XLOOKUP, which is the new and improved replacement for one of Excel’s most popular functions, VLOOKUP. In this article, we’re going to look at XMATCH, which (you’ve guessed it) is a replacement for the MATCH function. As you’ll see, XMATCH doesn’t enhance the old MATCH function particularly – …
Excel Linked Data Types: An Introduction
Andy McDonald -There’s a cool feature in Excel for Microsoft 365 that not many people know about. Linked Data Types allow you to access data from a range of subject areas such as finance, geography, nutrition, and media directly in Excel. Do you need to include the latest exchange rates, company stock prices, or city population figures …
Excel Power Query: What is it? Why use it?
Andy McDonald - Jul 01, 2022With Excel Power Query you can connect to data sources, import data, clean and shape it and then load it into Excel or a data model so that you can create charts and reports. In this article, we’re going to look at some examples of where you’d use Power Query and give a quick overview …
How to use XLOOKUP: Guide and Examples
Andy McDonald - Mar 02, 2022If you’ve been using Excel for a while, you’ll undoubtedly have used one of its most useful functions – VLOOKUP. This lookup function is invaluable when manipulating data or preparing reports in Excel. If you’re already familiar with VLOOKUP, then you’ll love the new XLOOKUP function that Microsoft released in late 2019. It overcomes some …
