To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for ...

Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.

Click "Table" to select the entire table with headers, footers and labels. Click the cell inside the Excel spreadsheet where you want the first cell of data to be placed.