Bard AI was recently rebranded to Gemini AI, but it was not a simple name change. The latest version of Google’s AI model has more advanced capabilities and is integrated with other Google services, including Gmail, Docs, Slides, and Sheets.
You can create tables and insert formulas in applications such as Google Sheets using Gemini’s prompts. This guide will show you how to use Gemini in Sheets.
You will need a Google account and a Google One AI Premium Plan to begin using Google One AI. Launch Google Sheets and create a new or open an existing spreadsheet once you’ve signed in.
Contents
Generating Data Using Gemini
1. Gemini can be accessed via the ‘Help Me Organize’ button on the toolbar. Start by clicking on it.
2. The ‘Help Me Organize’ panel will appear on the right after clicking the button.
3. Click on the ‘Create’ button or press ‘Enter’ to create a marketing campaign material tracker for a new product launch.
4. Depending on your needs, Gemini will provide you with the desired output.
Summarizing Spreadsheets Using Gemini
You can also use Gemini to summarize your sheet’s data easily.
1. You can type in a prompt like summarize this spreadsheet in the ‘Help Me Organize’ panel.
2. Gemini will summarize the information from your sheet in a few seconds, depending on how much data you have.
Creating Tables Using Gemini
Gemini also allows you to create tables using prompts to save time and effort. Once again, click on the ‘Help Me Organize’ button to reveal the panel.
To create a table, type a prompt like “create a table for a team event” and click ‘Create’ or press ‘Enter’.
You can easily create custom tables by providing Gemini with specific data.
Generating Formulas Using Gemini
Click the ‘Help Me Organize’ button on the Gemini side panel to generate a formula.
Enter a prompt such as create a formula that finds cell C1 in range D: G and outputs a value in column G, then click the ‘Create’ button.
Upon clicking the ‘Create’ button or pressing the ‘Enter’ key, Gemini will provide an output.
You will see an option to insert or discard a cell when you click on it. To insert, click the ‘Insert’ button.
When using Google Sheets, Gemini can save you a great deal of time and effort by allowing you to generate and edit data in various forms through prompts. As a result, a wide range of use cases can be addressed and significant efficiencies can be gained. In order for Gemini to function properly, it needs accurate data, just like any other AI model. To ensure your data is accurate, always use Gemini in Google Sheets after verifying your data.
