Welcome to Excel Jet Consult blog post. IN this blog post, we will learn how to perform COUNTIF and SUMIF operation using the SUMPRODUCT function. Let’s get started SAMPLE DATA In the screenshot below, we’ve got a sales table with six columns. In cells H5 to H8, we’ve got the unique list of the Products which we are going to […]

In this Microsoft SQL Server video tutorial, I demo how to write Inner Join Query in Azure Data Studio  

Welcome to Excel Jet Consult blog post. In this Excel and SQL Server video advanced video tutorial, I demo how we can create a custom and reusable function with Lambda function in Excel and how to create stored procedure in SQL Server that we can reuse multiple times.  

In this Excel and SQL Server video, I demo how to use the TEXTJOIN and the CONCAT_WS functions in Excel and SQL Server.

In this Excel video, we learn how to create Inner Join using Power Query.  

In this Microsoft Excel video, I demo how we can use the CHOOSE & XLOOKUP Function in a real business scenario.

In this Microsoft SQL Server video, I discussed the introduction to Azure Data Studio and how we can use the Having Clause to filter table  

In this video, I demo how to use the GroupBy Statement in Microsoft SQL Server and handling null values

In this Microsoft SQL Server tutorial, we learn how to download and restore AdventureWorks2019 Database to SQL Server Management Studio using Backup Technique.

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to create a Dynamic Report using SUMIFS Across Workbooks and Sparklines. Let’s get started Video Sample Dataset In the screenshots below, we have a sample dataset that is officially formatted an an Excel Table And below, we have the Sales Report worksheet where we want to write […]