How AI can be used in Excel for your data?

How AI can be used in Excel for your data?
Last Updated on 09/11/2023
Reading time: 2 minutes

AI is everywhere in the Computer Industry, including Excel. This article will show you how to analyze your data with AI just by clicking on a tool in the ribbon. You will see, it's much better than Chat GPT 😉

Example of data

Let's start with this sample to present how AI can help us analyze our data in an Excel worksheet.

Sample to be analyzed with AI

This example is representative of any data analysis because we can build our analyze with

  • Dates
  • The hierarchy between the Categories, Sub-Categories, and Product Name
  • The hierarchy between the Countries and the Cities
  • Detail of each transaction with the Price, the Quantity and the Total

But for many people, the question is: "How can I use all this information to build my analyze?" 🤔

Let AI analyze your data

But before, we must insert our data into a table.

Menu Insert Table

Indeed, adding the data in a Table will allow artificial intelligence to know the name of our columns and the data type. Thus, the analysis will be more accurate.

In this example, we have named the Table tbl_SalesData

Table Name SalesData

Now, let's click on the tool Home > Analyse Data

Excel menu Analyse Data

Then, a new pane opens with a message telling us that the data are analyzed in the background. We will talk about that later.

Analyse of the data in the cloud

And after a few seconds, Excel presents a list of Pivot Tables or charts of interest. But not only that, you can visualize more results at the bottom of the list of reports.

First result of the Analyse

Improve the analyze

Now, if the different reports don't help you with your analysis, you can adjust the parameters.

Parameter of the AI analysis in Excel

Then, you can unselect the columns that are not useful for your analysis.

Selection of the column to improve AI in Excel

And then, new reports are generated.

How to import the result of the analysis?

If one of the reports generated by AI suits you, you have to click on the button +Insert Pivot Chart to create a worksheet with the result.

Insert the result of AI in your Excel worksheet

1 Comment

  1. Harish
    28/11/2023 @ 12:10

    Thank You..!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

How AI can be used in Excel for your data?

Reading time: 2 minutes
Last Updated on 09/11/2023

AI is everywhere in the Computer Industry, including Excel. This article will show you how to analyze your data with AI just by clicking on a tool in the ribbon. You will see, it's much better than Chat GPT 😉

Example of data

Let's start with this sample to present how AI can help us analyze our data in an Excel worksheet.

Sample to be analyzed with AI

This example is representative of any data analysis because we can build our analyze with

  • Dates
  • The hierarchy between the Categories, Sub-Categories, and Product Name
  • The hierarchy between the Countries and the Cities
  • Detail of each transaction with the Price, the Quantity and the Total

But for many people, the question is: "How can I use all this information to build my analyze?" 🤔

Let AI analyze your data

But before, we must insert our data into a table.

Menu Insert Table

Indeed, adding the data in a Table will allow artificial intelligence to know the name of our columns and the data type. Thus, the analysis will be more accurate.

In this example, we have named the Table tbl_SalesData

Table Name SalesData

Now, let's click on the tool Home > Analyse Data

Excel menu Analyse Data

Then, a new pane opens with a message telling us that the data are analyzed in the background. We will talk about that later.

Analyse of the data in the cloud

And after a few seconds, Excel presents a list of Pivot Tables or charts of interest. But not only that, you can visualize more results at the bottom of the list of reports.

First result of the Analyse

Improve the analyze

Now, if the different reports don't help you with your analysis, you can adjust the parameters.

Parameter of the AI analysis in Excel

Then, you can unselect the columns that are not useful for your analysis.

Selection of the column to improve AI in Excel

And then, new reports are generated.

How to import the result of the analysis?

If one of the reports generated by AI suits you, you have to click on the button +Insert Pivot Chart to create a worksheet with the result.

Insert the result of AI in your Excel worksheet

1 Comment

  1. Harish
    28/11/2023 @ 12:10

    Thank You..!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *