Spreadsheet Transformation: Excel incorporates AI technology

I. An overview of Excel's AI features

Many AI-like functions in Excel employ machine learning algorithms to automate repetitive operations and natural language processing to look up information on the internet pertaining to the data you have chosen. For further information, see the following features with examples.

II. Data extraction

Data conversion from one format to another is known as Data extraction. Excel users can extract data from sources like photos, PDFs, and websites with the use of AI.

In Excel, data extraction is accomplished by two primary features:

Insert Data from Picture:

This feature saves a ton of time. To access the Get and Transform Data options, click the Data ribbon menu, followed by the Picture button as shown below:

The picture is processed, the data is extracted and inserted into excel sheet when you click OK.

Import Data from Web:

One more option under Get and Transform Data on the Excel Data menu ribbon is the Import Data from Web tool. Excel will handle all the work if you just provide it the URL of a web page with the necessary data in an HTML table.

https://www.wcrf.org/cancer-trends/worldwide-cancer-data/

Before loading the data, you have the option to transform it. To do this, launch the Power Query editor and begin performing transformations.

Removed top 2 rows as it required transformation.

After that the data is loaded into Excel by clicking on close & Load option in File menu.

III. Analyze Data

To get ideas for how to question the data, use the Analyze Data feature. This feature offers questions you might want to ask your data and generates ideas for summaries you might want to use, both tabular and graphic.

You can ask your own questions such as “Top 3 ‘Cancer’ by total ‘ASR’” then it will create Pivot table for it as follows:

One more question like “Total new cases by cancer”

IV. Predictive modelling

With Microsoft Excel, users may make predictive forecasts using the Forecast Sheet tool, which is based on previous data. This option is available on Data ribbon. When predicting trends or patterns across time, this feature might be helpful. It does this by using time-series data to provide projections for future values.

Conclusion

This blog has demonstrated the built-in AI capabilities of Excel through a variety of examples and screenshots. By employing machine learning algorithms to assist in the automation of specific operations, Excel incorporates intelligent features and automation that may be regarded as AI-related.

About CloudThat