Welcome to Excel Jet Consult blog post. This tutorial focused on how to List and Hyperlink Sheets in Excel using VBA. Question to Solve In the caption below, we have several sheet tabs. What we want to do is essentially to write VBA code that will list and hyperlink all the sheet tabs in the Home Page sheet Solution On the […]
Continue reading
Lookup Values in VBA Userform using XLOOKUP Function
Welcome to Excel Jet Consult blog post. In this tutorial, we learn about looking up values in Excel VBA Userform text boxes using the new XLOOKUP Function. Video The video of this blog post is available to watch and share Sample Data In the caption below, we have sample data that spans from columns A to H. This is a […]
Continue reading
Dynamically Append Tables Across Sheets using FILTERXLM
Welcome to Excel Jet Consult blog post. We previously learn how to split values into multiple columns using FILTERXLM Function. In this tutorial, we will consider how we can write a robust and easily understandable formula that will dynamically append tables across sheet sheets using the FILTERXML Function. Let’s get started Video Sample Data In the caption below, we have […]
Continue reading
SUM & COUNT Cell Color using SUMPRODUCT Function
Welcome to Excel Jet Consult blog post. In this blog post, we learn how to use the elegant SUMPRODUCT Excel Function to SUM & COUNT based on cell color. Sample Data We have a sample dataset that spans from columns A to C. In Columns B and C respectively, we have Account Manager name and the corresponding Sales Amount color-coded with unique cell color. […]
Continue reading
Converts Text to Numbers in Excel (8 Different Ways)
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn about 8 different methods to convert numbers stored as text to actual numbers in Excel. Let’s get started. Sample Data We have a size-able sample data in the caption below. In column B, there is Sales Amount stored as text. Essentially, we want to use […]
Continue reading
Sum of Digits Across Multiple Columns using LET Function
Welcome to Excel Jet Consult blog post, In this blog post, we learn how to use the LET Function in collaboration with other functions to sum digits across multiple columns. Enjoy and also watch the video Sample Data In the caption below, we have List of Fruits & Vegetables in column A. In columns B to E, we have the Quantity Sold […]
Continue reading
Rearrange Slides using Slide Sorter
Welcome to Excel Jet Consult blog post. In this short video PowerPoint tutorial, we learn how to easily rearrange slides in our presentation using Slide Sorter. If you enjoy the video, be kind to give some likes and subscribe to my YouTube channel. Cheers!
Continue reading
Search for Records in Excel VBA Userform
Welcome to Excel Jet Consult blog post. Building a robust and responsive database system in Excel VBA requires technical know-how is writing appropriates codes. In this video, I show us how to write VBA codes that enables searching of records in VBA userform.
Continue reading
VLOOKUP & INDEX/MATCH Inside Conditional Formatting
Welcome to Excel Jet Consult. In this blog post, we will learn how to use VLOOKUP & INDEX/MATCH Inside Conditional Formatting. Let’s get started Video You can watch the video of this tutorial below. Do subscribe to my YouTube channel for more videos Sample Data In the caption below, we have Date, Items, States and Actual from columns A to […]
Continue reading
Generate Random List using RANDBETWEEN & FILTER Functions in Excel
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we learn about how to generate random number using the RANDBETWEEN & FILTER Functions in Excel. Let’s get started Tutorial Video You can watch the video below for more in-depth explanation. Remeber to subscribe to my YouTube channel for more videos Sample Data In the caption below, we have […]
Continue reading