It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

10 ways to format Excel data so that people can actually understand it Your email has been sent Tell the truth, now. When you see a new worksheet arrive in your Inbox, your pulse doesn’t exactly ...

Turn generic columns into custom visuals by adding floating totals, nesting series, and layering simultaneous data labels.

If you work with data much, you don’t need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of ...

The Chart Wizard of earlier versions may be gone in Excel 2007, but creating charts is still as easy as ever. Beyond building basic charts there are various techniques you can use to make your charts ...

These four overlooked Excel features completely changed how I design spreadsheets.