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 …
The Excel and SQL Server experts blog
What is the equivalent of the IF THEN function in SQL?
Andy McDonald - Aug 24, 2022Excel Linked Data Types: An Introduction
Andy McDonald - Aug 18, 2022There’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, 2022SQL 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”. …
How to Export Data from SQL Server to Excel
Andy McDonald - Jul 04, 2022In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management. For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel. The …
How to Use SQL with Excel for Data Analysis
Andy McDonald - Jun 08, 2022In a previous article, we talked about why most organizations should use both SQL Server and Excel for their data management needs. In this article, we’re going to look at an example of how to perform data analysis using SQL and Excel with an Excel Add-In, called SQL Spreads. You can use the Add-In to …
SQL Spreads release 6.2.1
Johannes Åkesson - May 23, 2022SQL Spreads 6.2.1 is now available for download. Support for connecting to Azure SQL using Azure AD Authentication. Support for using Multi-Factor Authentication when authenticating to Azure AD. Download the latest version of SQL Spreads »
Export Power BI to Excel: Solved
Andy McDonald - May 03, 2022Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn raw data into actionable information for their business. It’s normally the case that you want to import data from Excel to Power BI to create a dashboard or report, but there are …
Connect Power BI to SQL Server: Step-by-step Guide
Andy McDonald - Apr 23, 2022Power BI is a great way to visualize your data. In previous articles, we’ve introduced Power BI dashboards and gone through a step-by-step example to create a Power BI report using data from SQL and Excel. In this article, we’re going to look in more detail at the process for how to connect Power BI …
Power BI Fact and Dimension Tables
Andy McDonald - Apr 01, 2022In an earlier article, we looked at how to create a dashboard based on some sales data. The data source for that example was several tables in a SQL database. In this article, we’re going to look in more detail at the data model we built in that Power BI example, and specifically the use …
SQL Spreads release 6.1.32
Johannes Åkesson - Mar 29, 2022SQL Spreads 6.1.32 is now available for download. Improved deleting of rows in the database to align with Excel’s Delete rows. Added check if per-machine or per-user installer exists. Added a possibility to call Excel’s Refresh All command after data is saved to the database. Fixed bug so that commas can be used in Pivot …
