Share via

Using Data Analysis on an Excel Table

Anonymous
2023-06-14T13:30:04+00:00

How can I use Data Analysis on an Excel Table? (from the Data ribbon, not Analyze Data on the Home ribbon)

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-06-15T14:17:42+00:00

    You are welcome. You may also give feedback on it.

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2023-06-15T13:44:55+00:00

    You may try with name range

    1 person found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-15T01:34:06+00:00

    You can manually input the table name in Input Range.

    0 comments
  2. Anonymous
    2023-06-14T23:09:00+00:00

    Yes, I understand that, but instead of using absolute cell references, I want to use structured references to fields in an Excel table.

    0 comments
  3. Anonymous
    2023-06-14T13:54:50+00:00

    Data Analysis>Input range>choose the data in your table.

    0 comments