# TEXTSPLIT Custom Function using New LAMBDA Function

Welcome to Excel Jet Consult blog post. In this video tutorial, we take a look at the newly released LAMBDA Function that allows users to create and reuse function without coding. If you enjoy the video, remember to subscribe to the YouTube channel and comment in the section below. Enjoy

# Spearman’s Rank Correlation Coefficient in Excel with Geography Data Type

Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to calculate Spearman’s Rank Correlation Coeeficient in Excel using Geography Data Types. Enjoy and remember to subscribe to my YouTube channel.

# New Auto-expand Drop-down List Technique in Excel

Welcome to this Excel tutorial. In this blog, we are going to look at the old school and the new school techniques of create auto-expand drop-down list in Excel. Let’s get started. Tutorial Video Kindly watch the video below and subscribe to the YouTube channel   Sample Data We have a simple Covid-19 dataset in the caption below. The Data […]

# Stunning Stacked Column Chart with Heart

Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to create a stunning stacked column chat with heart shape in Excel. Enjoy the video

# Send Bulk Email in Excel using Power Automate

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to send bulk email in Excel using the Power Automate. Let’s get started. Tutorial Video Sample Data In the caption below, we have a sizeable list of HR Employee Records showing Emp ID, Name of Employee, Date Hire, Position, Bonus, Monthly Salary and very importantly, a […]

# Cross Tabular Report using VLOOKUP Function

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we looked at how to use VLOOKUP Function to create a cross tabular report. If you enjoy this video, do subscribe to my YouTube Channel. Enjoy

# 5 Keyboard Shortcuts To Format Data As Excel Tables

Welcome to Excel Jet Consult blog post. In this video tutorial, we learn about 5 unique keyboard shortcuts to format data as Excel Table. Enjoy the video and remember to subscribe to the YouTube channel

# Power Query Data Types [The Game Changer]

Welcome to Excel Jet Consult blog post. In this blog post, we will look at how to use the newly released Power Query Data Types. Note, as at the time of writing this post, the PQ Data Types is currently available to Excel for Microsoft 365 E3 and E5. Sample Data We have sales data in the notepad of the […]