Google has enhanced its Gemini assistant for Google Sheets, introducing multi-table analysis capabilities. This upgrade allows users to analyze multiple tables simultaneously, utilizing natural language queries that span across different data sets. Now, instead of working on single data ranges, users can select specific columns or cells to streamline complex queries, such as forecasting revenue or assessing operational metrics.
Gemini automatically generates formulas, charts, and employs functions like QUERY or VLOOKUP—significantly reducing manual work. This feature is especially beneficial for organizations, as it ensures formula accuracy and respects data permissions, bolstering productivity and collaboration.
Available to Google Workspace customers with specific account tiers, users can quickly access multi-table functionalities through the Admin Console. By integrating Gemini more deeply into Sheets’ native functions, Google positions itself competitively against tools like Microsoft Excel’s Copilot. This move promises to enhance the data analysis experience, making it easier and faster for teams to derive actionable insights from their spreadsheets.
Source link
