# Calculate Hours Worked and Gross Pay using MOD Function and Formula in Excel

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

# Calculate Employees Years Spent using YEARFRAC Function

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

# Data Transformation with Advanced Formula

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

# Generate Sales Summary in Pivot table using Brand New Built-in Office Script in Desktop Excel

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

# Load Excel Data To Oracle SQL Developer Database

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

# Extract and List All Sundays from 2015 to 2022 at Once

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

# Add Line Breaks using Find and Replace in Excel

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

# Why I love XLOOKUP than VLOOKUP

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