Monday, February 15, 2021

Machine Learning with Google Sheets

Recently I published a book on Amazon about how to make use of no-code machine learning models: Mastering No-Code: No-Code AI Apps (Create Your Own Machine Learning Apps). Then a few days ago I realized I left out one of the most popular platforms that offers machine learning features - Google Sheets.

The "Explore" button (the star-shaped icon) in the lower right corner of Sheets is your key to unlocking the machine learning features in Google Sheets on the Web (Note: Explore is also available for iOS and Android versions of Googe Sheets). Using Explore lets you simply ask questions about your data rather than having to develop formulas to try to extract the information you want. For example, if you have a spreadsheet with fields for "Sales" and "Date of Sale" you could type "Total sales for February 2021" in the Answer box, hit Enter, and let Explore provide the answer.

There are also add-ons for Google Sheets, like the one from Aasaanai which lets you build, train, and use machine learning models inside Google Sheets without writing any code. Or the BigML add-on that allows you to integrate machine learning models on BigML with Google Sheets.

Considering the number of people who use Google Sheets every day, the ability to use machine learning with your Sheets is a major step forward and I'll post more about it in the future.

No comments:

Post a Comment