Welcome to Excel Jet Consult blog post. In this third video on LAMBDA Function, we created CONDITIONALFORMATTING Custom Function using XLOOKUP & LAMBDA Functions! Do enjoy the video, share, comment and give likes. The best is yet to come!
Continue reading
SUMBETWEENMONTH Custom Function using SUMIFS | LET | LAMBDA Functions
Welcome to Excel Jet Consult blog post. In this video tutorial, we looked at how to create and reuse SUMBETWEENMONTH Custom Function using SUMIFS | LET | LAMBDA Function. Enjoy the video and remember to subscribe to the YouTube Channel for more videos
Continue reading
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
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