Tom’s Tutorials For Excel: Using The Legacy PivotTable Wizard in Versions 2007 and After
Are you using Excel version 2007, 2010, or 2013? Are you a pivottable builder who misses the legacy PivotTable and PivotChart Wizard? Instead of going the Ribbon’s route of clicking the PivotTable icon on the Insert tab, press
Alt+D+P on your keyboard to build your pivottable from the familiar-looking Wizard, as pictured below.