Google Sheets analysis

How to analyze data in Google Sheets with Gemini and verify every result?

  • Gemini
  • Google Sheets

1250 € per session, excl. VAT

In short

Accelerate your data analysis and improve report reliability using Gemini in Google Sheets. This course guides you in using the AI assistant to generate formulas, tables, and summaries. You will learn to structure your prompts and implement systematic verification procedures to ensure accuracy.

Why this training?

AI assistants like Gemini are integrating directly into our work tools, including spreadsheets. They can accelerate tasks that previously took significant time, such as writing formulas or creating summary tables. However, trust in these tools depends on our ability to control and validate their outputs. This course focuses on a pragmatic approach: how to leverage the speed of AI while maintaining rigorous human oversight on the quality and accuracy of data analyses performed in Google Sheets. Participants will work with fictional business datasets. They will be required to use Gemini to clean data, generate KPI calculation formulas, create summary dashboards, and then apply a multi-step verification method. Each step of the process, from the initial prompt to the final validation, will be documented within the spreadsheet itself, creating a clear audit trail of the interaction with the AI. Deliverables: A prompt library for data analysis in Google Sheets.; A spreadsheet template with built-in verification procedures.; An action plan for deploying these techniques within the team.. Gemini's effectiveness depends on prompt quality and data structure. The features presented are subject to change by Google, and their availability depends on the Google Workspace edition and settings defined by your organization's administrator. The tool may produce incorrect outputs. The workshop is delivered in person as a private session for up to 12 participants, in one language chosen from French, Dutch and English. All exercise data is fictional or anonymised, and every result produced with AI is reviewed and validated by a responsible person. The aim is a bounded result the team can reuse, not a promise of deployment.

Objectives of this training

  • Use the Gemini side panel to generate complex formulas.
  • Create data tables and summaries from prompts.
  • Develop methods to verify formulas suggested by the AI.
  • Implement checks to reconcile totals and document verifications.
  • Isolate source data from AI-generated tables to maintain integrity.

Who is it for and what are the prerequisites?

Roles and tasks concerned

  • Data analysts and finance professionals.
  • Project managers and team leaders looking to optimize their reports.
  • Anyone who regularly uses Google Sheets for data analysis.

Prior skills

  • This course requires completion of the 'AI Fundamentals' and 'AI Prompting' courses or equivalent experience. Participants must have a paid Google Workspace subscription that includes Gemini for Google Sheets, with their organization's authorization to use these third-party tools, as well as their own accounts and access rights. Exercises use fictional or anonymized data.
  • A paid subscription to an AI solution offering the features used, the organisation’s authorisation for third-party tools, and the actual accounts and access rights.

What you will work on

  1. Introduction to Gemini in Google Sheets

  2. Generating Formulas and Tables

  3. Controlling and Verifying AI Results

  4. Integration and Best Practices

What you take away

  • A prompt library for data analysis in Google Sheets.
  • A spreadsheet template with built-in verification procedures.
  • An action plan for deploying these techniques within the team.

Method and assessment

  • Theoretical presentations and live demonstrations.
  • Practical workshops based on business use cases.
  • Q&A sessions and group prompt reviews.

Evaluation is conducted through the completion of a final summary exercise that combines AI data generation with the application of a documented verification protocol.

Frequently asked questions

What concrete result does this course deliver?

This course enables teams to use Gemini in Google Sheets effectively and safely for data analysis by establishing a discipline of systematic verification. Deliverables: a prompt library for data analysis in google sheets., a spreadsheet template with built-in verification procedures., an action plan for deploying these techniques within the team..

Who is this course for and what are the prerequisites?

It is designed for: data analysts and finance professionals., project managers and team leaders looking to optimize their reports., anyone who regularly uses google sheets for data analysis.. This course requires completion of the 'AI Fundamentals' and 'AI Prompting' courses or equivalent experience. Participants must have a paid Google Workspace subscription that includes Gemini for Google Sheets, with their organization's authorization to use these third-party tools, as well as their own accounts and access rights. Exercises use fictional or anonymized data.

What data and access need to be arranged?

Please prepare an anonymized dataset relevant to your business or use the provided fictional data, and ensure all participants have functional access to Gemini in their Google Sheets account. Required tools and licences are checked before the session; no subscription is included in the price.

What practical exercise is completed?

Participants will work with fictional business datasets. They will be required to use Gemini to clean data, generate KPI calculation formulas, create summary dashboards, and then apply a multi-step verification method. Each step of the process, from the initial prompt to the final validation, will be documented within the spreadsheet itself, creating a clear audit trail of the interaction with the AI.

What are the limits and who validates the results?

Gemini's effectiveness depends on prompt quality and data structure. The features presented are subject to change by Google, and their availability depends on the Google Workspace edition and settings defined by your organization's administrator. The tool may produce incorrect outputs.

Can the course be adapted to our line of work?

The course content can be adapted to focus on use cases specific to your industry, such as financial analysis, sales tracking, or project management, by using relevant data examples for the exercises.

How is the session organised and what does it cost?

Half-day, private in-person session for up to 12 participants. The fee is €1,250 excluding VAT per session. Date and location are agreed during scoping; each session runs in a single language: French, Dutch or English.

Related courses

Last updated: