Insert Pivot Table Shortcut using Old Excel Shortcut (Alt > D > P) Now just follow the above procedure to create a pivot table in excel. Create a Pivot Table option box will open. This is a sequential keyboard shortcut is to open the Create Pivot Table option box. Insert Pivot Table Shortcut (Alt > N > V) In this excel pivot table tutorial, you will learn more than you expect. We will see how we create a summary of data using the pivot table but first let's get the basics clear. You will have your pivot table in a new sheet. Now if you are done with the settings, hit the OK button. Just define the location in the Location box.ħ. I recommend using the new worksheet but you can also use the current worksheet. Next, you can select where you want your pivot table. If you think that this is not the range you want to select, directly resize your range from here, instead of going back and selecting data again.Ħ. Here, you can see the data range that you selected. Create a Pivot Table option box will appear.ĥ. To insert a pivot table from the menu, follow these steps:Ĥ. Once you have it, you can insert the pivot table. You should have your data organised with proper heading. Requirement 1: All columns should have a heading to get started with Pivot Tables in Excel If any column heading is left blank, the pivot table will not be created and will go through an error message. Before you create a pivot table, ensure that all columns have a heading. Click on the Pivot Table and it's done.īut wait. I don’t want to bore you, so let's jump into it and explore. Analyse your clean data easily and if the data is not clean, it can help you to clean your data. Pivot Table can help you make reports in minutes. Even if you are a newbie, you can crunch large amounts of data into useful information. Pivot Tables are one of the most powerful features in excel.