Welcome to Excel Jet Consult blog post. In this video, I demo how to Calculate Hours Worked and Gross Pay using MOD Function and Formula in Excel. If you like the video, give it a thump up and share with your friends Video  

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to calculate the years spent by each employees based on the Hire Date using the YEARFRAC function in Excel. Let’s get started SAMPLE DATA The screenshot below shows the HR dataset we wanna work with YEARFRAC Function The YEARFRAC function calculates the fraction of the […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to transform dataset from rows to columns using combination of advanced functions. Let’s get started.   SAMPLE DATASET The screenshot below shows the sample dataset in two columns.   DATA TRANSFORMATION We want to write a single formula that will split all the values […]

Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to Generate Sales Summary Report in PivotTable without dataset using the built-in Office Script in the brand new Automate tab. Enjoy             

Welcome to Excel Jet Consult blog post. In this tutorial, I demo how to Load Excel Data to Oracle SQL Developer Database. Enjoy    

Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to extract and list all the first Sundays in 2015 to 2022 at once. Enjoy    

Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to Easily add line breaks using Find & Replace in Excel. Enjoy    

Welcome to Excel Jet Consult blog post. In this video, I demo why I Love the XLOOKUP Function than the old VLOOKUP to handle multiple column array operation at once. Enjoy    

Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to create 3D Cross Tab Search using XLOOKUP function. Let’s get started   Video   Sample Data In the screenshot below, we’ve got a sales data that contains Total by Account Manager and Month. XLOOKUP Formula Our goal is to group all the […]

Welcome to Excel Jet Consult blog post. In this blog post, we will learn 5 ways to combine text string in Excel Worksheet. Let’s get started SAMPLE DATA For this exercise, we shall be using the dataset below which is designed as an HR Data FLASH FILL Our first method is to use the flash fill feature in Excel. Succinctly, […]