Share via

There are no Excel analysis tools.

안재현 안재현 1 Reputation point
2021-10-18T07:09:48.857+00:00

I'm going to add an Excel analysis tool, but there's no analysis tool. How do I solve this problem?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,284 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,914 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,715 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Thomas Grubbe Møller 6 Reputation points
    2021-10-21T06:29:42.613+00:00

    Dear @안재현 안재현 ,

    Excel has a great feature called "Analyze Data".
    You can find further detailed information: https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4

    You can save time and get a more focused analysis by selecting only the fields you want to see. When you choose fields and how to summarize them, Analyze Data excludes other available data - speeding up the process and presenting fewer, more targeted suggestions. For example, you might only want to see the sum of sales by year.

    142362-image.png

    1 person found this answer helpful.
    0 comments
  2. Emily Hua-MSFT 27,641 Reputation points
    2021-10-19T02:33:29.42+00:00

    @안재현 안재현

    What version of Excel are you using now?
    Please go to Excel > Account > Product Information, check the version and version number.

    It‘s recommended to click File > Options > Add-Ins > Manage Excel Add-ins > Go > check the boxes of Analysis ToolPak and Analysis ToolPak - VBA > OK.
    Then the Data Analysis function should appear on the far right of the Data tab.

    If the step you have done, but still could not find Data Analysis, I would suggest you uncheck Analysis ToolPak and Analysis ToolPak - VBA, click OK, close Excel.
    Then re-opne Excel, please re-check these 2 boxes, check whether it appears under the Data tab.

    Any issues, you could post back.

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.