# Linear Equation Computation and Graph in Excel

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!

# Merry Christmas in Random Font Colors

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

# CONDITIONALFORMATTING Custom Function using XLOOKUP & LAMBDA Functions

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!

# 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

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