The Excel and SQL Server experts blog

Are you looking for a more streamlined FP&A and financial forecasting solution than Vena Solutions? In this article, we’ll show you five top Vena alternatives that can help your finance team budget and plan more effectively – and reveal how SQL Spreads not only makes the switch straightforward, but also offers the flexibility and value your …

Microsoft recently released two new aggregation functions in Excel – GROUPBY and PIVOTBY. Both these functions are useful when you want to quickly summarize data in your Excel spreadsheet. In this article we’re going to look at how to use the GROUPBY function, and in the next article we’ll cover the more powerful PIVOTBY function. …

Creating a database in Excel is a straightforward process that can help you manage and analyze your data efficiently. Whether you need to keep track of personal information, business records, or project details, Excel offers powerful tools to build and maintain a database. Follow these steps to create a database in Excel: 5 steps on …

In 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 – …

With 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 …