Microsoft Excel's new AI formula feature is called "Analyze Data".
(Previously Microsoft named this feature ‘Ideas’ and many support sites cause confusion by still referring to it by its previous name.)
It is a powerful tool that uses artificial intelligence to suggest formulas, charts, and other ways to visualise and analyze your data.
It empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. Analyze Data also provides high-level visual summaries, trends, and patterns.
Follow these simple steps get started
Open Microsoft Excel and create a new worksheet or open an existing one that contains your data (or you can download ours - click here)
Click on the "Analyze Data" button in the "Home" tab of the Excel ribbon. (If you can't see the " Analyze Data" button, you may need to update your version of Excel to the latest version.)
Once you click on the "Analyze Data " button, a panel will appear on the right side of your Excel window, sugestingg formulas and charts that may be useful for your data. You can scroll through the list of suggestions or use the search bar to find specific suggestions.
Would you like to try 'Analyze Data' on your computer?
To use a suggestion, click on it in the panel. Excel will automatically insert the formula or chart into your worksheet, and you can adjust it as needed.
Go ahead, ask me anything!
If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter.
Analyze Data will provide answers with visuals such as tables, charts or PivotTables that can then be inserted into the workbook.
If you are interested in exploring your data, or just want to know what is possible, Analyze Data also provides personalised suggested questions which you can access by selecting on the query box.
Here are some examples of how to use 'Analyze Data' in Excel
Find trends in your data
Suppose you have a worksheet that contains sales data for the past year. You want to find out if there are any trends in the data that can help you make business decisions. To use Ideas, click on the "Analyze Data" button in the "Home" tab of the Excel ribbon. In the right hand side panel, you may see suggestions for charts that show trends over time, such as a line chart or a scatter chart. You can select the suggestion that you like, and Excel will create the chart for you. You can then use the chart to identify trends in your data.
Summarise data in a pivot table
Suppose you have a large data set that contains sales data for different regions and products. You want to summarise the data in a pivot table to help you analyze it. To use Ideas, click on the "Analyze Data" button in the "Home" tab of the Excel ribbon. In the right hand side panel, you may see a suggestion to create a pivot table. You can select the suggestion, and Excel will create a pivot table for you. You can then use the pivot table to summarise your data by region, product, or any other category you choose.
Calculate percentage change
Suppose you have a worksheet that contains sales data for the past two years. You want to calculate the percentage change in sales between the two years. To use Ideas, click on the "Analyze Data" button in the "Home" tab of the Excel ribbon. In the Analyze Data panel, you may see a suggestion to calculate the percentage change. You can select the suggestion, and Excel will create a formula that calculates the percentage change for you. You can then use the formula to analyze your data!
'Analyze Data' in Excel is a powerful tool that can help you save time and work more efficiently with your data. By using its suggestions, you can quickly create formulas and charts that can help you analyze your data and make better business decisions.
Comdex Training News & Blogs 2023
Comments