Follow these steps to set up an analytics template in Excel:
Click the **Access** tab.
Click Access Analytics.
Select the relevant Data Connection
Click the three dots to select the starting cell.
Pick a cell and click the button within the choose starting cell window.
Choose Analysis type.
Select required columns.
Click next to add filters or insert to add data.