Hello @Amber Lomas
Welcome to Q&A forum!
Thank you for such detailed information.
I have checked my Excel and can confirm that this option is available under the Data tab, as shown in the image. You may double-check it on your side using both the Excel desktop app and the Excel web version.
Additionally, I found some related articles that may be helpful. I’ve reviewed a few key points to assist you in verifying the issue.
Analyze Data in Excel - Microsoft Support
make sure you have the latest version of Office
Besides, you can also double check this tool in Customize Ribbon as this image:
I’d appreciate it if you could review the information and share your feedback.
Our first response may not fully resolve the issue, but with your input and detailed answers to follow-up questions, we can work together to find the root cause and a solution.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in "our documentation" to enable e-mail notifications if you want to receive the related email notification for this thread.