• The Excel and SQL Server experts blog

  • How a Business Analyst can help with data conversion projects

    Andy McDonald - Nov 25, 2022

    Businesses today are required to manage more data than ever before. Change is also occurring at a faster rate. Organizations therefore need to be agile with regard to data management and this means being able to move data around from one system to another or between parties with relative ease. In this article we’ll discuss …

  • Master Data Management Tools for Azure

    Andy McDonald - Nov 07, 2022

    Maintaining a “single source of truth” is critical for all organizations. The discipline of Master Data Management (MDM) is one of the means to achieve this. In this article, we’re going to look at some Master Data Management tools for Azure. Table of contents 1. Introduction 2. What is Master Data Management? 3. Microsoft Purview: an …

  • Master Data Management Tools for SQL Server

    Andy McDonald - Oct 21, 2022

    Maintaining a “single source of truth” is critical for all organizations. There are many Master Data Management (MDM) tools out there to help achieve this. In this article, we’re going to look at some Master Data Management tools for SQL Server. Table of contents 1. Introduction 2. What is Master Data Management? 3. What are …

  • SQL Union: How to Combine Result Sets

    Andy McDonald - Sep 02, 2022

    This is the sixth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to combine data from one or more data sets using the SQL UNION operator. UNION is one of a number of ‘set operators’ in SQL that are used to join the results …

  • What is the equivalent of the IF THEN function in SQL?

    Andy McDonald - Aug 24, 2022

    This is the fifth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to use the IF THEN function in SQL. If you’re interested in the other articles, check them out here: Introduction to SQL for Excel Users What is the equivalent to VLOOKUP in …

  • How to Use XMATCH: Guide and Examples

    Andy McDonald - Aug 18, 2022

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

  • Excel Linked Data Types: An Introduction

    Andy McDonald - Aug 18, 2022

    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 …

  • SQL Spreads release 6.2.8

    Johannes Åkesson - Aug 09, 2022

    SQL Spreads 6.2.8 is now available for download. Fixed issue with bigint numbers with more than 17 digits that were truncated. Fixed issue with commas in text key columns. Fixed issue with uninstalling when both the per-machine and the per-user versions was installed. Fixed issue with the database connection setting “Remember password on local machine”. …

  • What is the equivalent to VLOOKUP in SQL?

    Andy McDonald - Jul 14, 2022

    In this article, we’re going to show you how to perform the equivalent of Excel’s VLOOKUP in SQL.  This is the second of our articles aimed at teaching Excel users the basics of SQL. In our previous article “Introduction to SQL for Excel Users”, we introduced the JOIN statement, and here we’re going to expand …

  • Introduction to SQL for Excel Users

    Andy McDonald - Jul 04, 2022

    This is the first of several articles on SQL for Excel users.  The aim is to show you why it’s so useful for Excel users to be familiar with SQL and to introduce some basic concepts and queries. Table of contents 1. Why is it important to learn SQL? 2. What is SQL? 3. Getting …

  • Page 1 of 812345»...Last »