Many Excel spreadsheets use the IFERROR function to handle errors, but this masks critical structural and data issues.

Coding is the act of translating a logical solution into a computer-readable form. This involves writing instructions using a ...

The presentation of an Excel document can be extremely important, especially if that document will be seen by business partners or clients. If you have a long list of numbers on your spreadsheet, but ...

Q. Thanks for your tip on teaching Excel to speak the numbers in a spreadsheet ( JofA , Dec.03, page 91). It really was keen. However, how do you turn the darn thing off? I keep clicking on the off ...

In Microsoft Excel, turning Scroll Lock on allows you to use the arrow keys to navigate your business spreadsheet without moving the cell that you have selected. The current state of Scroll Lock is ...

A Microsoft announcement that the company would be disabling macros as a default feature in Excel 4.0 has been greeted as a step that "would really help defenders". British security expert Kevin ...