How to Use Artificial Intelligence in Excel (4 Easy Examples)

Example 1 – Evaluating Intelligence Suggestions with Analysis

When you are working with a large dataset and want to insert a chart, the Analyze Data option has made it easier. It automatically gives you some suggestions.

Steps:

  • Select the entire data range and move to the Analyze Data from the Analysis section.

Evaluating Intelligence Suggestions with Analysis for artificial intelligence in Excel

  • The Analyze Data panel appears. You can choose different charts according to your preference. It also shows some intelligent suggestions for choosing your decision towards your company or product-related information.
Analyze Data GIF for artificial intelligence in Excel
  • You can insert any of the charts at your preference that is relevant to your dataset. We have inserted a chart for better visualization.

Read More: How to Make a Decision Tree Algorithm in Excel


Example 2 – Showing Real-Time Stock Prices

Steps:

  • Write down some stock’s short codes like the image below:

Showing Real-Time Stock Price for artificial intelligence in Excel

  • Select the entire data range.
  • Go to the Insert tab.
  • Choose Table from the Tables group.

Making a table

  • The Create Table window appears. Check the My table has headers box and hit OK.

  • Select the range of the data table and hover over the Data tab.
  • Pick Stocks from the Data Types section.

Using Stocks for artificial intelligence in Excel

  • The short code will turn into the stock names.
  • You can add a column from the Add Column command which is in the right top corner of your data table.

  • We chose 52 weeks high and Currency from the column section. There are a lot of options available in the Add Column section.

  • You can see the column has been added to your stock section.

Adding Column for stocks

  • You can click on the stock sign and get important information about the related stocks.

Read More: How to Perform Machine Learning in Excel


Example 3 – Using Geography in Excel

Steps:

  • Write country or region names and make a table with the data as mentioned before.
  • Navigate to the Data tab and pick Geography from the Data Types group.

Using Geography in Excel for artificial intelligence in Excel

  • Add columns from the Add Column section from the upper right corner of the data table.

  • Pick some columns to your preference.

Adding Column for artificial intelligence in excel

If you click on the geographic sign, you can find the available information on the internet about that specific region.

Geography GIF for artificial intelligence in Excel

Example 4 – Employing Dynamic Array Functions

Steps:

  • Go to cell C5 and insert the formula:

=SORT(B5:B11)

This function will sort the data of B5:B11 alphabetically as you can see in the image.

SORT function

  • If you have duplicates in your dataset then you can use the UNIQUE function to remove the duplicates:

=UNIQUE(B5:B13)

The above syntax will remove the duplicate values from the range of B5:B13.

UNIQUE function

If you want to choose specific data based on your criteria. In the below dataset, you want to filter the data to know the USA citizen.

  • Go to cell D5 and insert this formula:

=FILTER(B5:B11,C5:C11="USA")

The function will filter the data in the B5:B11 in the criteria_range C5:C11 for the criteria of USA.

FILTER function

You can also use SORTBY and SEQUENCE functions.


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Related Articles


<< Go Back to Algorithm in Excel Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

2 Comments
  1. exceldemy you guys made my excel practice so easy with zero cost. You are doing good thing. keep uploading sheet with solutions. sending you wishes for your site growth.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo