Exceljet

Quick, clean, and to the point

Open pivot table wizard

Windows shortcut

AltDP

Mac shortcut

⌘⌥P

This shortcut will launch the PivotTable Wizard dialog box.

Note: In Mac 2016, the Pivot Table Wizard appears to be gone. If you find a workaround, let us know.

222 Excel Shortcuts for Windows and Mac

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Thank you for your clear explanation on the sumifs function. It was exactly what I needed to simplify a massive spreadsheet where I need to summarize a range of amounts from over 70 sheets in a workbook. The previous person would manually update the formulas each year but now the "sumifs between dates" formula will automate this. Huge Thanks!! -Sarah

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables