Similar Posts

File Manager Tool
File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.

Turn Off Scroll Lock in Excel – 4 Easiest and Quick Ways
Scroll Lock in Excel can make scrolling, selecting cells, checking formulas, entering data, and recording macros harder. So, you might need to turn it off to work normally. In this article, we’ll show you how…

How to Calculate Weighted Average in Excel?
Microsoft Excel is a useful tool for analyzing data and conducting statistical research. The program includes numerous functions for performing various statistical calculations. One of the essential measures Excel supports is the weighted average.

How to Subtract in Excel – with easy 5 examples
To subtract numbers in Excel, follow these steps:
Start by typing an equal sign (=) in the cell where you want the result.
Enter the first number or cell reference you want to subtract from.
Type a minus sign (-).
Enter the second number or cell reference you want to subtract.

EXCEL FUNCTION – TRIM
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.

EXCEL FUNCTION – AVERAGEIF
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.