Office Settings & Configuration

How to Find Microsoft Intelligent Services or Ideas in Excel

Amos GikundaAmos Gikunda Nov 13, 2026 868 views

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.

How to Find Microsoft Intelligent Services or Ideas in Excel
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 start

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.

Solution 1Recommended

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.

1
Open your workbook

Launch Excel and open the workbook that contains the data you want to analyze.

2
Select a data range or table

Click any cell inside the data range or Excel table that you want Analyze Data to examine.

3
Go to the Home tab

On the ribbon, select the Home tab.

4
Select Analyze Data

In the Analysis or Insights group, click Analyze Data. If prompted, confirm that you want to use the feature.

5
Review the suggestions

In the Analyze Data task pane, select a suggested question or scroll through the visual summaries and PivotTables.

Find Analyze Data on the Home Tab in Excel
Feature renamed: The Analyze Data button replaces the previous Ideas entry in current Excel versions.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office download page and click Download WPS Office Free.
  2. 2. Open your Excel file: Launch WPS Spreadsheets and open the existing .xlsx workbook from your computer.
  3. 3. Use data tools: Select your data range, then use the Formulas, Data, or Insert tab to sort, filter, summarize, or create charts.
Free data analysis tools for sorting, filtering, and creating chartsOpens, edits, and saves Microsoft Excel .xlsx and .xls filesLightweight installation and familiar Office-style ribbonNo Microsoft 365 subscription or organization policy required
microsoft office alternative - wps office

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.