Q. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

Last time I showed you how to set up a reasonably complex design in a spreadsheet: a common emitter bipolar transistor amplifier. Having the design in a spreadsheet makes it easy to do “what if” ...

Excel has been around for decades, but most users barely scratch the surface of what it can do. I've spent my fair share of time building complex spreadsheets for project management and data analysis, ...

I learned, belatedly, that last October 17 was Spreadsheet Day, marking the 35th anniversary of VisiCalc, the Apple II program that started it all. This moved me to republish a long piece I wrote 30 ...

In the early days of the personal computer, we were going to be freed from routine data-handling tasks in science, industry, and engineering, with heady promises of vast new efficiencies. We would ...