If you've ever tried building a product catalog in Excel, you know the headache — images float over cells, they don't move ...

As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

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