#Office – Ideas Tool for Microsoft Excel powered by AI (#Excel, #AI)

Hi !

Today I’ll switch to Excel to share some of the other amazing AI features embedded in Microsoft Office: Excel Ideas.

Excel Ideas is this new tool we have in Excel which will allow us to get some insights about the selected information in a worksheet. In order to use this tool, we need to select a set of data and click the [Ideas] button in the Ribbon.

Microsoft Excel Ideas.jpg

In order to write this post, I downloaded a sample set of spatial data from SpatialKey (see references). The sample insurance file contains 36,634 records in Florida for 2012 from a sample company that implemented an agressive growth plan in 2012. There are total insured value (TIV) columns containing TIV from 2011 and 2012, so this dataset is great for testing out the comparison feature. This file has address information that you can choose to geocode, or you can use the existing latitude/longitude in the file.

Once I selected the full set of Data, is nice to see the following insights

If you are a PowerBI user, this type of information and analysis will be familiar. To me is nice to see that we have this capabilities in a single click in a popular tool like Excel.

There are over +40 insights and it’s nice to browse them and find that in Miami Dade County, the site deductible is higher for Steel Frame and Reinforced Concrete constructions.

Microsoft Excel Ideas Sample 03

With 2 click we can analyze some Open Data related to traffic on Ontario and see how the traffic slowly increases in Hwy 69.

Microsoft Excel Ideas Sample 04

An amazing tool inside Excel to quickly get insights on our data.

Happy coding!

Greetings @ Toronto

El Bruno


My posts



Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: