Ctrl + Shift + ; Enter the current time Ctrl + ; Enter the current date Alt + Shift +F1 Insert new worksheet Shift + F3 ...

Select the cells you want to create the PivotTable from Select Insert>Pivot Table 3. Once you click this, it will create a PivotTable...