Want to use Excel to reference cell in another sheet based on cell value? In this tutorial, I will explain the whole process step by step. I will show basically two ways of doing so. But before ...

In this article, I will show you how to calculate the weighted average in Excel with percentages. The weighted average is the average where some numbers are taken into consideration as the weighted ...

In this article, we will see the formula to calculate the percentage difference between two Numbers in Excel. There is basically one formula to calculate this which is, % of Difference = (New ...

In this article, I will show you the Excel formula to calculate hours worked minus lunch. The lunchtime can be in hours or it can be expressed as in starting and ending time. Based on different ...

In this short article, I will show how to calculate periodic interest rate in Excel. I will show 4 methods of calculating the periodic interest rate.
1) Calculate periodic interest rate when ...

Suppose you have an employee name who recently resigned from your company. You want to calculate his/her years of services at your company. There are many ways to calculate that. We can use many ...

Sometimes it is often required to round numbers to its nearest hundreds or thousands. In this article, we will see how Excel round to nearest 1000. There are many formulas for doing that. Besides ...

While working with a big range of data it is often required to find the number of specific text. In this article, we will count cells that contain specific text. In Excel, counting cells that contain ...

In this article, we will see how VLOOKUP and HLOOKUP Combined functions work together in Excel formulas. Here we will use VLOOKUP and HLOOKUP combinedly to solve a problem. The basics of VLOOKUP and ...

In this article, I will show you how to calculate monthly payment in Excel with some examples and criteria. Here are the criteria: You have got $50,000 loan on June 05, 2018
Yearly ...

In Excel, a lot of things are done using the functions that together make formulas. In this article, we are going to show you some tips on "How to Show Formula in Excel Cells Instead of Value". ...

In this article, I will show you how to use Excel to lookup for partial text match. For this, we can use VLOOKUP or INDEX MATCH functions combo. In the following image, you are seeing some company ...

Separating words are important in Excel to extract information from your worksheet. There are many methods of doing that. Here, in this article, we will see “How to Separate Words in Excel Using ...

Sometimes while working with multiple columns you often need to match your two columns to return the third value. In this article, we will see how to match two columns in Excel and return a third. In ...

If you have two big columns and you want to compare them, you can use Excel’s VLOOKUP function. In this article, I will show how you can use VLOOKUP formula to compare two columns in different ...