Stop treating PivotTables as the finish line—add Slicers and Timelines to turn your spreadsheet into an interactive dashboard.

Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.

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.