Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you set some conditional formatting rules ...

If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...

The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The output of the above function will be 5, ...

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...