Displaying Formula Syntax in Excel 2007

To display and print the formula in a file, we can use the Ctrl+`, (`) the sign is located to the left ofthe number 1 on your keyboard. Let’s tak...

Finding the Last Day of a Given Month in Excel

While preparing tax reports, you may be required to find out the last day of a given month. Excel has a very useful built in function called EOMONT...

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...

Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters in Microsoft Excel 2010

In this article we will learn how to subdivide a mixed string into separate cells which contain only numbers or characters,we can use the "TRIM", "LEF...

Searching a String for a Specific Substring in Excel

In this article we will learn how to search a string for a Excel Substring in Excel. To search a string for a specific substring, we will use the I...

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...

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