I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...

From spreadsheets to showdowns, the Excel World Championship turns number-crunching into a high-stakes spectacle.

To do that, open the Macros window, select the macro, and click Options. Under Shortcut key, press the key to use with Ctrl —I chose Ctrl + J —and click OK. When choosing the key, just make sure it ...