How to Find Microsoft Intelligent Services or Ideas in Excel
Question details
The user wants to locate the Excel feature formerly known as Ideas or Microsoft Intelligent Services and understand where the command appears in the ribbon.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is working in Excel and needs to find the intelligent analysis command that was previously labeled Ideas.
- Observed behavior
- The feature is now called Analyze Data and appears on the Home tab in supported versions; availability depends on the Excel version, Microsoft 365 plan, and organization settings.
Before you look for the command, open Excel and make sure your workbook contains a data range or Excel table. Then check that your Microsoft 365 subscription or Office edition is activated, because the feature is not available in all versions.
Find Analyze Data on the Home Tab in Excel
Use this method when your Excel version and Microsoft 365 plan include the feature, formerly named Ideas.
In supported Excel versions, the Ideas feature is now called Analyze Data. It is available from the Home tab and opens a task pane with suggestions, PivotTables, and charts based on the selected data.
Launch Excel and open the workbook that contains the data you want to analyze.
Click any cell inside the data range or Excel table that you want Analyze Data to examine.
On the ribbon, select the Home tab.
In the Analysis or Insights group, click Analyze Data. If prompted, confirm that you want to use the feature.
In the Analyze Data task pane, select a suggested question or scroll through the visual summaries and PivotTables.

Check Availability If Analyze Data Is Missing
Use this troubleshooting path when the Analyze Data command does not appear on the Home tab.
Use WPS Office Spreadsheets as a Free Alternative for Excel Data Analysis
When a Microsoft 365 plan or organization setting blocks the Excel Analyze Data feature, WPS Office Spreadsheets offers a free, lightweight way to work with .xlsx files. Its familiar ribbon and built-in data tools let you sort, filter, chart, and summarize data without a subscription.
- 1. Download WPS Office: Go to the official WPS Office download page and click Download WPS Office Free.
- 2. Open your Excel file: Launch WPS Spreadsheets and open the existing .xlsx workbook from your computer.
- 3. Use data tools: Select your data range, then use the Formulas, Data, or Insert tab to sort, filter, summarize, or create charts.

Frequently Asked Questions
Why can't I see Ideas or Analyze Data in my Excel ribbon?
The feature may not be included in your Excel version or Microsoft 365 plan, or your organization may have disabled connected experiences. In a supported copy, open the Home tab and click Analyze Data.
What replaced the Excel Ideas button?
Microsoft renamed Ideas to Analyze Data. In supported Excel versions, the button appears on the Home tab, usually in the Analysis or Insights group.
Does Analyze Data work in Excel for the web?
Yes, Analyze Data is available in Excel for the web for many Microsoft 365 users. Open the workbook in a browser, go to the Home tab, and select Analyze Data.
Can I use Analyze Data without a Microsoft 365 subscription?
Availability depends on the plan. Some one-time Office versions may not include Analyze Data; check File > Account or the Microsoft documentation to verify your edition.
What should I do if Analyze Data is blocked by my organization?
Contact your Microsoft 365 administrator and ask whether connected experiences or optional diagnostic data are enabled, because those settings can control the feature.




