This resource has been developed as an activity for learners who have been introduced to Pivot Tables in Excel.
This resource contains a worksheet that can be printed out. It has a list of short cut keys pertaining to pivot tables and data management in Excel. The activity is a mix and match. Students are required to match the shortcut with the Description. The answer page is included as well as a blank sheet for further shortcut keys to be added.
I generally use this at the beginning of a lesson, once I’ve covered off a bit of general knowledge around pivot tables. I then encourage students to put these short cuts into practice during the session.
Included is a word document and a pdf file, so further editing is permitted. This activity can be carried out individually, in pairs, or groups to add a competitive edge.