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
Continue reading
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.
Continue reading
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 […]
Continue reading
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
Continue reading
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 […]
Continue reading
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
Continue reading
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
Continue reading
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 […]
Continue reading
VLOOKUP with Array Constants
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to deploy Array Constants with VLOOKUP to handle the table array argument. Let’s get started Tutorial Video You can watch the tutorial video below Sample Data We have a sample data below showing transaction records. VLOOKUP Without Array Constants Based on the caption above, we […]
Continue reading
DAX Calculated Column with IF Statement
Welcome to Excel Jet Consult blog post. In this tutorial, we will look at writing IF Statement to create DAX Calculated Column in Excel. Let’s get started Video You can watch the video below. Subscribe, comment and give likes Sample Data In the caption below, we have our data formatted as an Excel Table using CTRL + T and already […]
Continue reading