If 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 …
The Excel and SQL Server experts blog
-
How to use XLOOKUP: Guide and Examples
Andy McDonald - Mar 02, 2022 -
What is Power Apps? Quick Start Guide
Andy McDonald - Feb 18, 2022More and more people are using no-code technologies to create mobile apps, and there are a growing number of vendors in this area. In this article, we’ll be focusing on Microsoft’s no-code platform, Power Apps. Because it’s a no-code platform it should be easy to create apps, right?! Well, yes, it is easy to use …
-
Creating Reports with Power BI, SQL and Excel
Andy McDonald - Feb 09, 2022In an earlier post, we introduced Power BI and looked at what makes a good dashboard. In this article, we’re going to go through the steps for creating reports with Power BI, SQL, and Excel. How Does Power BI Work? A Brief Overview Power BI is a Business Intelligence (BI) platform. With Power BI, …
-
CSV to SQL: How to Convert, Open & Import
Andy McDonald - Jan 31, 2022In this article, we’re going to look at 3 ways to convert a CSV file to SQL. This is a common use case, so hopefully, you’ll find the following information useful in your day-to-day work. Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another. The …
-
SQL Spreads release 6.1.15
Johannes Åkesson - Dec 09, 2021SQL Spreads 6.1.15 is now available for download. Added support for the new pricing model with Basic, Pro and Premium plans and separate Editor licenses. Added a checkbox to the Table Creator to decide if columns in a new table should be nullable. Added a field to set the name of the Identity column in …
-
Master Data Management: What is it and Why is it Important?
Andy McDonald - Dec 02, 2021Master Data Management (MDM) is an information management discipline focusing on data quality and data governance. Its goal is to mitigate problems caused when Master Data is inconsistent, fragmented, or out of date. In this article, we’re going to explain what MDM is and provide some tips on how to start an MDM journey. What …
-
SQL Spreads release 6.0.44
Johannes Åkesson - Oct 29, 2021SQL Spreads 6.0.44 is now available for download. This new release focus on stability improvements – we have made a number of stability improvements and fixes in the areas around Excel table formatting, detection of changes in SQL Server etc. Added the possibility to set a Default value for a column to use when a …
-
Simple Data Validation in SQL
Andy McDonald - Oct 24, 2021What is data validation in SQL and why is it important? Data validation is a method for checking the accuracy and quality of data. Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …
-
How to create Pivot Tables in SQL Server
Andy McDonald - Oct 10, 2021In this article, we’re going to show you how to create pivot tables in SQL Server. This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …
-
SQL Spreads release 6.0.30
Johannes Åkesson - Jun 17, 2021SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×
×