Shortcutdrill

Level 7: Alt ribbon sequences Drill 58 of 80 Pro

Insert a pivot

An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.

The task

From inside the table, start a pivot table on a new sheet.

What this drill teaches

Alt, N, V inserts a PivotTable from the current region. The new sheet is where you drop the fields.

A hint if you get stuck

Windows: Alt, N, V. The drill allows 1 key press.

This drill is part of Pro

Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.

14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.

Start with the free drills

More drills in Alt ribbon sequences