Yes, there is a shortcut key assigned to creating a pivot table in Microsoft Excel. Here are the steps to create a pivot table using the shortcut key:

1. Select the data range that you want to use for the pivot table.
2. Press the shortcut key "Alt + N + V" in sequence.
3. This will open the "Create PivotTable" dialog box.
4. In the dialog box, select the range of data that you want to use for the pivot table.
5. Choose where you want to place the pivot table (either in a new worksheet or in an existing worksheet).
6. Click "OK" to create the pivot table.

In addition to the shortcut key, here are some other helpful tips and tricks related to pivot tables:

1. Use the "PivotTable Fields" pane to easily add or remove fields from your pivot table.
2. Use the "Value Field Settings" dialog box to change the summary calculation for a field (such as sum, average, count, etc.).
3. Use the "PivotTable Options" dialog box to change the layout and formatting of your pivot table.
4. Use the "Refresh" button to update your pivot table with new data.
5. Use the "Slicer" feature to filter your pivot table by specific criteria.

I hope these tips and tricks help you get the most out of your pivot tables!