*Google Sheets 🗒 adds pivot tables, suggested formula tools 🔧 powered by machine learning*

Google's work with machine learning is impressive for a number of reasons, but its most practical uses often come in places you wouldn't expect. Spreadsheets are very powerful, but you can only access a fraction of that power if you don't know how to use the right formulas.

Now, Google Sheets is making it easier to pick the right formula by using machine learning to give a collection of suggested formulas based on the data being used. In the Explore pane, you can also ask questions of your data using everyday language (via natural language processing) and have the answer returned as a pivot table.

Along with that, Pivot Tables on Sheets are getting new machine learning tools. With a simple click, Sheets can automatically create a pivot table based on the data available, potentially saving a lot of time. In addition, if you want to create a pivot table from scratch, Sheets can suggest a number of relevant tables in the pivot table editor to help you summarize your data faster.