Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to create Linear Equation computation and graph in Excel. Enjoy

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to connect to data stored in Google Sheets and Microsoft Access to create a refreshable PivotTable Report! If you like this video, subscribe to the Channel, Share with friends and give thumps up because there is more to come!

Welcome to Excel Jet Consult blog post. In this last tutorial of 2020, I show you how to apply random font colors using Word VBA. There is so much more to come in 2021. See you there  

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!  

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

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

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