Excel Mod - Free Excel Tutorial

How to Highlight Every Other Row or Every Nth Row in Excel?

August 23, 2020

Sometimes we may want to highlight every other row or every Nth row in a spreadsheet to make data in different rows looks more clearly. Though we can apply table styles to highlight table rows automatically, we can also highlight rows by excel ‘Conditional Formatting’ function. Actually, ‘Conditional Formatting’ has a powerful capability to highlight… read more »

How to Calculate Total Work Days or Hours Exclude Weekends/Holidays in Excel

May 3, 2020

In our daily work we often need to count the total working-days or working-hours for employees then we can pay for them the salary in some cases. But we have to count the total exclude weekends or holidays as we don’t work on these days. So, we need to know how can we calculate the… read more »

How to Stack Data from Multiple Columns into One Column in Excel

March 22, 2020

In previous article, I have shown you the method to split data from one long column to multiple columns by VBA and Index function. This time if we want to stack data from multiple columns to one column, how can we do? Actually, we can still use VBA script or formula of Index function to… read more »

How to Convert Julian Date to a Calendar date in Excel

February 1, 2019

This post will guide you how to convert Julian date to a calendar date in Excel. How do I convert a given Julian Date to a calendar date with a formula in Excel. What is Julian Date? Julian day number is the integer assigned to a whole solar day in the Julian day count starting… read more »

How to Highlight Every Other Row Using Conditional Formatting in Excel

January 4, 2019

This post will guide you how to highlight every other row in Excel. How do I shade every other row with conditional formatting in Excel. Highlight Every Other Row Video: Highlight Every Other Row Highlight Every Other Row Assuming that you have a list of data in range A1:C9, and you want to highlight every… read more »

Generate All Possible Combinations of Two Lists in Excel

February 18, 2019

This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »

Sum Every Nth Row or Column

September 5, 2018

This post will guide you how to sum every nth row or column with a formula in Excel. How do I sum every nth value in a same row or column in Excel. How to sum every nth cell in a column or in a row with an Excel Formula. How to sum every second,… read more »

Create a Five Star Rating System

July 18, 2018

This post will guide you how to create a five star rating system in your current worksheet in excel. How do I change the five points system to five star rating in excel. How to use the conditional formatting function to create a five star rating system in excel. Create a Five Star Rating System… read more »

Highlight Multiples of Specific Value

July 3, 2018

This post will guide you how to search and highlight multiple values of a apecific value in excel. How to check if a number is a multiple of a specific number and then highlight those searched values in excel. Highlight Multiples of Specific Value If you want to highlight numbers that are multiples of a… read more »

Delete Every Other Row

June 25, 2018

This post will guide you how to delete every other row by filter command in Excel. How do I delete every other row in a selected range on a worksheet by Excel VBA Macro. Delete Every Other Row with Filter command To delete every other row in Excel, you need to filter alternate rows, and… read more »

Transpose Multiple Columns into One Column

June 6, 2018

This post will guide you how to transpose multiple columns into a single columns with multiple rows in Excel. How do I put data from multiple columns into one column with Excel formula; How to transpose columns into single column with VBA macro in excel. Assuming that you have a data list in range B1:D4… read more »

Excel MOD Function

September 13, 2018

This post will guide you how to use Excel MOD function with syntax and examples in Microsoft excel. Description The Excel MOD function returns the remainder of two numbers after division. So you can use the MOD function to get the remainder after a number is divided by a divisor in Excel. And the returned… read more »

How to Calculate Days, Weeks, Months and Years between Two Dates

February 18, 2019

This post will teach you how to calculate days, weeks, months and years between two dates in excel. How do I count the number of days, weeks, months and years between 2 dates in excel. Calculate days between two dates If you want to calculate the difference in days between two dates, you can use… read more »