Skip to main content

Set up an Analytics template

You can set up an Analytics template in Excel using the steps below.

  1. Go to the **Access** tab.

  2. Click **Access Analytics**.

  3. Select the relevant **Data Connection**.

  4. Click the **three dots** to select the starting cell.

  5. Pick a cell and click the button in the 'Choose starting cell' window.

  6. Choose the **Analysis type**.

  7. Select the required columns.

  8. Click **Next** to add filters, or **Insert** to add data.

Did this answer your question?