Google Sheets users can harness the power of Gemini AI to access a wealth of formulas and functions to solve data challenges. This integration is slowly being rolled out, but it promises to enhance efficiency for maximum productivity across fields.
Here’s your step-by-step guide on how to make Sheets work for you.
Step 1: Accessing Gemini AI
Open Google Sheets and navigate to the top right corner. A diamond-shaped button will appear immediately to the left of your profile picture. Click this to collaborate with Gemini AI and a windowpane will appear on the right-hand side summarizing your spreadsheet and providing suggestions.
Step 2: Create custom formulas
Users can now create custom formulas using natural language. The AI technology understands the dataset and adapts the formula to your prompt. EX: Write a formula that finds the account number with the highest number of infractions.
Step 3: Inserting formulas
Found a formula that suits your dataset? You can add it to your Sheet by copying and pasting it anywhere you want. Or you can select and empty cell, click insert, and let Gemini do the work by inserting the formula for you.
Step 4: Data explanation
Confused by complicated data? Google Sheets’ integration with Gemini AI can now explain the data to you as well. This is particularly helpful for data analysis novices or when you receive an uncleaned dataset. Simply write a prompt to ask Gemini AI to explain the data to you. EX: Explain this data to me like I’m a child.
Step 5: Tables
Another powerful tool in the Gemini AI toolkit is its ability to create tables from scratch. Users can describe the kind of table needed and Gemini will generate it. Once Gemini has customized the table to your specs, just hit insert to add it to your spreadsheet.
With the integration of Gemini AI, Google Sheets has become even more user friendly. Now users can use simple and conversational language to process data. Say goodbye to memorizing and looking up complicated formulas.