Advanced Google Sheets Training

Live online, hands-on advanced Google Sheets training. Ideal for companies transitioning to Google Workspace. Duration: 3 hours, delivered in English.

See training content

Content Advanced Google Sheets Training

1. Pivot Tables & Data Aggregation

  • Use Pivot Tables to group and summarise data by category, time or region
  • Use slicers to filter Pivot Tables interactively

Key functions:

  • UNIQUE – Identify distinct values for grouping
  • SUMIF / SUMIFS – Summarise values with conditions
  • COUNTIF / COUNTIFS – Count occurrences with conditions

2. Advanced Formulas & Data Analysis

  • Use ARRAYFORMULA to automate calculations across ranges
  • Nest functions (IF, IFS, AND, OR) for complex logic
  • Apply FILTER to create real-time data subsets
  • Combine datasets using:
    VLOOKUP, XLOOKUP, INDEX / MATCH

3. Working with Structured Tables & Formatting

  • Apply advanced sorting and multi-criteria filtering
  • Use Filter Views for individualised analysis
  • Add Slicers to control data views without altering source
  • Format data visually using Conditional Formatting with custom rules

4. Data Linking & Importing

  • Connect multiple Sheets using IMPORTRANGE

5. Automation, Productivity & Best Practices

  • Introduction to Google Apps Script: automate repetitive tasks
  • Use Google Sheets shortcuts to boost speed and productivity
  • Apply best practices such as formatting data as structured tables

Your Google Sheets Trainer

Google Sheets Training with Joern Steinz

Master Google Sheets with confidence – with the advanced Google Sheets Training by SkillDay, led by Jörn Steinz (MBA), an experienced trainer, OKR consultant, and presentation coach. Mr. Steinz, a graduate of EADA Business School and former Accenture consultant, brings deep expertise and years of hands-on experience from his work in Corporate Development, where he worked extensively with Google Sheets. Since 2013, he has been successfully conducting workshops and confidently facilitating large groups.

With clearly structured content and interactive training, you and your team will master the key Google Sheets functions — supported by practical materials and, if desired, ongoing assistance directly from Mr. Steinz.

Get in touch

We look forward to receiving your inquiry and promise a prompt response within 24 hours. Explore how SkillDay can elevate your organization’s Google Sheets skills and drive success.