Sum total stock value for any part in Excel 2010

To calculate the total stock value for any part, we use the SUM function along with the IF function in Excel 2010. SUM: - This function is used to ...

Selecting/Formatting Cells Containing Errors in Microsoft Excel 2010

In this article we will learn how to select the cells that contain only errors, we will use the "Go-To" option. And if we need to format the cells con...

Selecting Cells That Contain Formulas

To select the cells which contain only formulas, we can use the Go-To option in Microsoft Excel. Go To Special: - This option is used to quickly re-d...

Address Function in Microsoft Excel

To return the cell reference as text, we will use the Address Function in Microsoft Excel. ADDRESS:- This function is used to creates a cell referenc...

How to change column number with letter in Microsoft Excel

To change in Excel column number to a letter, we need to use the "IF", "AND", "CHAR", "INT" and "MOD" functions in Microsoft Excel 2010. Before con...

Format Cells Contains Formula in Microsoft Excel

In this article we will learn how to format the cells which is containing the formulas in Microsoft Excel. To format the cells which contain formulas...

Random name selector

In this article we will learn how to pick the name randomly  from a list, so we will use the INDEX formula along with the ROUND, RAND and COUNTA form...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube