# 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

# 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

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

# VLOOKUP with Array Constants

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

# DAX Calculated Column with IF Statement

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

# List and Hyperlink Sheets using VBA

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

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

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