How-To Geek via MSN

How to use Excel tables to automate formulas and prevent broken ranges

Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.