To setup analytics template In Excel, please follow these steps:
Go to 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.