Have you ever carefully crafted a formula in Excel, only to watch it unravel into chaos the moment you copy it across columns? It’s a maddening quirk of Excel tables—structured references that seem to ...

It is rare to find an implemented database devoid of reference tables. Reference tables provide valid values for drop-down lists and in a slightly obtuse way, also allow for expression of a domain or ...

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, ...