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

Column to multi-row combination using IF Excel Function

Introduction Welcome to Excel Jet Consult blog post. In this, we learn how to flatten our data from column to multiple rows combination using IF Excel Function. Video Do watch the tutorial video below Sample Data In the caption below, we have list of Countries, States/Provinces and Population The goal of this tutorial is to write an IF formula that […]

Import Dynamic Arrays Result to Power Query

Welcome to Excel Jet Consult blog post. In this video Excel tutorial, we learn how to use the From Sheet to import Dynamic Arrays Result to Power Query. This feature is currently available in the Beta Channel of Excel for M365 & Office365. Do watch the video in the link below and hit the subscribe button. Video Sample Data In […]

#MsSQLServer: Calculate Total Revenue by Brand

Welcome to this Microsoft SQL Server video tutorial, we will learn how to calculate Total Revenue by Brand. If you enjoy the video, like, comment, share and subscribe to the channel Video Dataset In the caption below, we wrote a simple select all statement that returned all the columns from the specified table Query to Retrieve Total Revenue by Brand […]

Track Forbes MPP Birthday Status using IFS Function in #Excel

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to track Forbes Most Powerful Person Birthday Status for 2021 using the new IFS Function. Remember to hit the subscribe and bell icon buttons because there is a lot to come. Video Sample File In the caption below, we have list of Forbes Most Power […]

MID and SEARCH Text Functions Inside SUMIFS plus List Data Validation

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we learn how to use MID & SEARCH Text Functions inside SUMIFS plus Data Validation to create a dynamic report. If you enjoy the video and tutorial, like, share, comment and subscribe to the YouTube channel. Video Sample Data In the caption below, we have Sales Data formatted as […]

Retrieve Single and Multiple Non contiguous columns in MS SQL Server

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to retrieve single and non-contiguous multiple columns in MS SQL Server Database Table. Enjoy the video

Connect and Import Data from Excel to SQL Server

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to connect and import data from Excel to SQL Server. Enjoy the video