Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...

The FORMULATEXT function is often dismissed because it merely transforms a formula into text. However, that raw text is exactly what makes it so valuable. So, stop thinking of it as a one-trick ...

Most people don't know Excel has a voice, but it's the best hidden auditing tool in the software. Instead of the error-prone back-and-forth between a paper invoice and my monitor, the Speak Cells ...