Workshops & trainings
>
Google Workspace Enablement
>
Data Pro

Analyses & dashboards in sheets — Become a data expert.

Tables can do much more than just keep lists. In this advanced training, you'll learn how to tame complex amounts of data, create automated dashboards, and take full advantage of Google Sheets' unique cloud capabilities. We'll show you how to generate valuable insights with intelligent functions and AI support and take your reports to the next level.
Request training now
English
English
No items found.
perpetuity
approx. 3.5 - 4 hours
Level
For advanced users
subscriber
Up to 20 participants
format
Online via Google Meet (interactive training) or on site
This training is aimed at
Power users and employees who want to use sheets professionally for analyses and reporting.

prerequisites

  • Active Google Workspace account
  • Solid basic knowledge of Google Sheets or Excel

That's what you'll learn

  • The top class of functions: Master XREFERENCE (XLOOKUP), FILTER And the powerful query function (SQL for sheets) to evaluate data dynamically and at lightning speed.
  • Pivot tables & data modeling: Analyze huge amounts of data, create calculated fields, and use groupings to make complex relationships visible.
  • Interactive dashboards 2.0: Build visual reports with controls such as advanced dropdowns, checkboxes, and conditional formatting that update automatically.
  • Cloud power & data synchronization: Use IMPORT RANGEto securely mirror data between different tables, and learn how to connect external sources live.
  • AI assistant Gemini: Let AI write complex formulas, clean up data structures, and analyze trends in your spreadsheets at the push of a button.
  • Data security & monitoring: Use cell protection professionally and learn how to use the Version history and secure automatic notifications of changes in critical areas.
Summit participants
You and your team will take that with you

Your benefits

Learning together as a team not only provides exciting impulses, but also strengthens team spirit and increases acceptance of new implementations!

automation

Replace manual data maintenance with dynamic workflows and save hours of time every week.

‍

Error-free reports

Professional validation and protection features make “shattered” formulas a thing of the past.

Real-Time Insights

Your dashboards always show the current status — no matter who is currently entering data.

Advantage through AI

You use Gemini to solve tasks that would have required studying computer science or hours of research in the past.

Price options for our trainings

Starting at 690€
plus VAT
For on-site training, we charge a fee of 600€ plus VAT.

From 10+ trainings

from our entire range
690, - €
per training plus VAT
Request training now

From 3+ trainings

from our entire range
800, - €
per training plus VAT
Request training now

1 workout

from our entire range
950, - €
per training plus VAT
Request training now
FAQ

Frequently asked questions

Everything you need to know and more.
Do the training courses only take place online or on site?
We are flexible and adapt to your wishes. By default, our interactive trainings take place live via Google Meet. We present you with real practice cases so that it doesn't get boring.
How many participants can take place at the same time?
Our trainings are aimed at small to medium-sized groups of 10 - 20 participants. In this way, we guarantee the best learning success and interactivity within training.
Do I need to be able to program?
No Our trainings are designed to empower professional users. We use low-code tools (AppSheet) and intuitive AI interfaces (Gemini) that promote logical understanding instead of requiring code knowledge.
Can we use our own data?
Yes, absolutely. Workouts get the biggest ROI when they take place in your own environment. We carry out training securely in your tenant so that the results obtained flow directly into your productive workflows.
How practical is the content?
100% hands-on We don't work with abstract slides, but on real use cases from your everyday business life and are always up-to-date. The goal is for participants to have a solution in their hands at the end of the day that they can use immediately.

Get in touch with us.

Get advice! Book an initial consultation here without obligation and we will plan the training together with your team.
Thank you so much! We have received your message and will get back to you as soon as possible.
Oops! Something went wrong while submitting the form.