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

One tiny symbol, but an absurd amount of spreadsheet drama.

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it’s as easy as creating a table. In earlier versions, you’ll need the formula method.

In a nutshell: Formulas are a must for incorporating math into spreadsheets, but using them in Microsoft Excel involves a learning curve and can become tedious. This latest update adds a bit of ...