Exceljet

Quick, clean, and to the point

Create pivot chart on new worksheet

Windows shortcut

F11

Mac shortcut

FnF11

This shortcut will create a pivot chart on a new worksheet. Select a cell in the pivot table first.

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