\n<\/p>\n
Google is giving Sheets a Gemini-powered upgrade that is designed to help users analyze data faster and turn spreadsheets into charts using AI.<\/p>\n
With this update, users can access Gemini\u2019s capabilities to generate insights from their data, such as correlations, trends, outliers, and more. Users now can also generate advanced visualizations, like heatmaps, that they can insert as static images over cells in spreadsheets.<\/p>\n
While the company announced<\/a> the update last month, Google said on Friday<\/a> that it\u2019s now available to all Workspace business users.<\/p>\n To get started, you need to click the Gemini icon on the top right-hand side of your spreadsheet. From there, you can ask things like \u201cpredict my net income for the next quarter based on historical data\u201d or \u201ccreate a simple heatmap of support cases by category and device.\u201d<\/p>\n Other examples include a marketing manager asking Gemini to \u201cProvide some insights on my top 3 performing channels by conversion rate\u201d\u00a0or a financial analyst asking Gemini to \u201cIdentify any anomalies in inventory levels for Product X.\u201d<\/p>\n Gemini is able to do all this by creating and running Python code and then analyzing the results to perform multi-layered analysis, Google says. For simpler requests, Gemini might still provide answers using formulas instead of Python code.<\/p>\n The company notes that data should be in a consistent format with clear headers and no missing values to allow for accurate results.<\/p>\n<\/div>\n