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

Welcome to Excel Jet Consult blog post. In this Microsoft SQL Server tutorial, we learn how to download and restore AdventureWorks2019 Database to SQL Server Managment Studio using Backup Technique. If you enjoy this video, give it a thumps up and consider subscribing to this channel if you have not done so Video

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn a supercool tricks to apply bulk Comments or Notes to Top 5 Total Sales in Two Steps. Let’s get started.   Video Sample Dataset In the screenshot below, we have a dataset that has 5 columns. In M365 for Excel, Microsoft has replaced Comments with […]

Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to use the new Get Data From Picture which is available in M365 for Excel, Mac for Excel and Excel on the Web versions to Get Data from Multiple Pictures and Analyze with PivotTable. Let’s get started   Video Sample Dataset In the […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to connect to dataset stored in text using Power Query for Mac. Let’s get started The Excel for the Mac, just like Windows enable importing, refreshing and authenticating data sources, managing Power Query sources, clearing credentials, changing file-based data sources location, and shaping data […]

Welcome to Excel Jet Consult blog post. In this video tutorial, we will learn how to Import & Append Tables From Excel & PDF To Dataverse using Power Query Online Editor. If you enjoy this video, Like, Share, Comment and Subscribe to this channel. #Excel #PowerQueryOnlineEditor #Dataverse #PDF Video