Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to create 3D Cross Tab Search using XLOOKUP function. Let’s get started   Video   Sample Data In the screenshot below, we’ve got a sales data that contains Total by Account Manager and Month. XLOOKUP Formula Our goal is to group all the […]

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 […]