# Power Query: Top 3 Customer Type in a cell

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we saw how to use the Power Query to achieve Top 3 Customer Type in a single cell

# Power Query: Combine Multiple Tables from Multi Sheets + SUMIFS & PivotTables

Welcome to Excel Jet Consult blog post. In this Excel video, we learn how to use the Power Query to combine multiple tables from multiple sheets and using SUMIFS & PivotTables to create sales report by country!

# Remove Line Breaks using Power Query

In the previous video and blog post, we considered how to use FILTERXML combined with arrays of functions to remove line breaks. In this tutorial, we shall learn how to perform the same operation using the Power Query. Let’s get started. Video Do take time to watch the tutorial video and subscribe to the YouTube Channel Sample Data In the […]

# Remove Link Breaks using FILTERXML Function

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn about how to remove line breaks in Excel using FILTERXML function   Video Sample Data We have in the caption below, a sales record showing line break Our goal is to write a long formula using the FILTERXML and other functions to remove the line […]

# MS SQL Server: An Introduction to Azure Data Studio

Welcome to Excel Jet Consult blog post. In this MS SQL Server video tutorial, we learn how to use the Azure Data Studio to query our database. If you enjoy this video, like, share, comment and subscribe to the channel

# Sort Data using INDEX and Other Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to sort our data in multiple columns using INDEX and other functions. Video Sample Data The sample data below shows List of Countries, Country Code and Population. We have the same data in both sheet. Note, the data is officially formatted as an Excel Table In […]

# Import Exchange Rates from the Web to Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to import exchange rates from web to Excel. Let’s get started. Video Data to Import We have long list of Exchange rates to import in the following url: U.S. Dollar (USD) latest exchange rates (floatrates.com) as we can see below Open Excel Workbook Next, we open […]

# Shuffle Data using Dynamic Arrays

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Sortby and Randarray Dynamic Arrays to shuffle dataset in Microsoft Excel. Let’s get started. Video Do watch the video below. Share, like, comment and subscribe Sample Data In the caption below, we have the sample data showing records for Order Date all through […]