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.

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

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

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

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

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

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