Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to Generate Sales Summary Report in PivotTable without dataset using the built-in Office Script in the brand new Automate tab. Enjoy             

Welcome to Excel Jet Consult blog post. In this tutorial, I demo how to Load Excel Data to Oracle SQL Developer Database. Enjoy    

Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to extract and list all the first Sundays in 2015 to 2022 at once. Enjoy    

Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to Easily add line breaks using Find & Replace in Excel. Enjoy    

Welcome to Excel Jet Consult blog post. In this video, I demo why I Love the XLOOKUP Function than the old VLOOKUP to handle multiple column array operation at once. Enjoy    

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.