We’re excited to announce the release of SQL Spreads 7.5.4, which focuses on improving the Tree Filters and Intro dialogs, as well as addressing various bug fixes. New Features and Enhancements Redesigned Introductory Dialogues: We have redesigned the introductory dialogues to provide a more intuitive user experience. This includes a new option to restart the …
The Excel and SQL Server experts blog
-
SQL Spreads release 7.5.4
Johannes Åkesson - Sep 03, 2024 -
Power BI Dashboards: Examples & Use Cases
Andy McDonald - Aug 30, 2024Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn data into actionable information for their business. In this article, we’re going to look at creating Power BI dashboards and reports, and give some examples of how and when to use them. …
-
How to Update an SQL Table from Excel
Johannes Åkesson - Aug 06, 2024SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives you the control you need to manage data entered by various users on a collaborative team. End users love working in Excel End users love …
-
How to perform an INSERT in SQL Server
Johannes Åkesson - Aug 01, 2024Inserting data into SQL Server is a fundamental operation for business users who need to add new records to their databases. This guide will walk you through the process of using the INSERT statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding the …
-
How to perform a DELETE in SQL Server
Johannes Åkesson - Aug 01, 2024Deleting data in SQL Server is a critical operation for business users who need to remove obsolete or incorrect records from their databases. This guide will walk you through the process of using the DELETE statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). …
-
How to create a database in Excel
Johannes Åkesson - Aug 01, 2024Creating 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 …
-
How to perform a SELECT INTO in SQL Server
Johannes Åkesson - Aug 01, 2024The SELECT INTO statement in SQL Server is a powerful tool for creating new tables and copying data from existing tables or queries. This guide will walk you through the process of using the SELECT INTO statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio …
-
How to perform an UPDATE in SQL Server
Johannes Åkesson - Jun 28, 2024Updating data in SQL Server is a common task for business users who need to ensure their data remains accurate and up-to-date. This guide will walk you through the process of using the ‘UPDATE’ statement in SQL Server, providing easy-to-follow steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding …
-
How to insert data from Excel to SQL Server
Johannes Åkesson - Jun 04, 2024Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know. -
How to Build a KPI Dashboard with Power BI
Andy McDonald - May 21, 2024In this article, we’re going to show you how to build a KPI dashboard in Power BI for managers. The example we’ll work through uses our KPI data collection template, used by operational level administrators to collect KPI metrics. This template was built with SQL Server, Excel and the SQL Spreads Excel Add which is …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×