Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...

Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains. Excel sheets grow — sometimes by adding new functionality, ...