Posted inLearn
How to Use Excel Formulas to Fetch the Last Month’s Value
To fetch the last month’s value using excel formula, you need to use a combination…
Posted inLearn
How to Delete Unwanted Data from a Filtered Table in Excel
In this article, we will show you how to delete specific items from a filtered…
Posted inLearn
Learn How to Calculate Hours, Minutes, and Seconds in Excel
Excel is a powerful tool for working with time values, such as hours, minutes, and…
Posted inPetroleum Engineering
Estimating Free Gas in Place (FGIP) using Excel
Free gas in place (FGIP) is the amount of gas that exists in a reservoir…
Posted inLearn
How to Look Up Next Travel Date for Staff Travel Schedule in Excel
If you are managing a team of staff who travel frequently for work, you may…
Posted inLearn
How to change or replace multiple cell name in Microsoft Excel chronologically?
In Microsoft Excel, you can use defined names to refer to cells, ranges, formulas, or constants. Defined names…
Posted inLearn
How to Auto Repeat Dates in Excel
In this article, you will learn how to auto repeat the dates in specific cells…
Posted inLearn
Counting Criteria in Filtered Data with Subtotal and Countifs in Excel
In this article, we will learn how to use Subtotal and Countifs together in formula…
Posted inLearn
How to Format and Display a Cell Value as Part of Text in Excel Formula
Sometimes, you may want to use a value in one cell as part of the…
Posted inLearn
Learn How to Sum Without Duplicates in Excel with These Simple Steps
Sometimes, you may want to sum a range of cells that contain some duplicate values,…
