# Knowledge Sharing This Section is full of Free Resources on Microsoft Excel. It is very useful if someone wants to learn MS Excel online.

Don’t forget to put your comments at the end of the post, if any.

All your questions are welcome. We will revert back shortly with answer to your questions.
(You can ask your questions in comment section at the bottom of post).

## Do print settings for multiple worksheets in one go

At times there is a need to do the print settings of multiple worksheets in one go. It is time consuming to do it manually for each sheet. There is a trick to do it at once for all the… Read More ›

## Last Working Day of the Month

Excel Formula to calculate Last Working Day of the Month: It is simple in Excel to calculate Last Day of the Month with the help of EOMONTH Formula. However, it is slightly tricky to figure out Last WORKING Day of… Read More ›

## Case-Insensitive Match

Excel Exact Formula is Case-Sensitive. Learn how to do Case-Insensitive Match. Exact Function is one of the Case-Sensitive Formulas in Excel. In this Post we will see how we can do case-Insensitive match between two text strings. Case-Insensitive Match is… Read More ›

## Excel Mid Formula

Learn How to use Excel Mid Formula: As name depicts, Mid Function is used to extract the characters from middle of the formula. Excel Mid Formula extracts the specified number of characters from specified position. Mid Function Syntax: Mid(text, start_num,… Read More ›

## Excel Left Formula

Learn How to use Excel Left Formula: Excel Left Formula extracts the specified number of characters from the left hand side of a cell. It is used to remove unwanted characters from Right Side of a cell. Left Function Syntax:… Read More ›

## Excel Right Formula

Learn How to use Excel Right Formula: Excel Right Formula extracts the specified number of characters from right hand side of a cell. In other words, it extract data from the the end of a text string. It is used… Read More ›

## Excel Exact Formula

Learn How to use Excel Exact Formula: Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences. Exact Function works with Text… Read More ›

## Excel Hlookup Formula

Learn How to use Excel Hlookup Formula: In Excel HLOOKUP formula, H stands for Horizontal and LOOKUP means lookup. Hlookup is used to lookup values in a data table where lookup_value resides. Lets see Hlookup syntax and an example to… Read More ›

## Excel Vlookup Formula

Learn How to use Excel Vlookup Formula: In Excel VLOOKUP formula, V stands for Vertical and LOOKUP means lookup. Vlookup is used to lookup values in a data table where lookup_value resides. Lets see Vlookup syntax and an example to… Read More ›

## Excel Averageifs Formula

Learn how to use Excel Averageifs Formulas: Excel Averageifs Formula averages a Set of values IF(S) a single or multiple conditions are met. In other words, averageifs function averages the number of cells that met one or more than one… Read More ›