Advertisements

Google Sheets for Business: Gemini AI, Formulas, 70+ Tools

Advertisements
Turn messy spreadsheets into one system: XLOOKUP, QUERY, pivot tables, KPI dashboard, Apps Script, Forms and templates
1
1/5
(43) Ratings
393 students
Created by PapaHR ★ 180K students: Human Resources, HR Management, SHRM, AI Analytics, Recruitment, Payroll, Certification, CIPD, Claude
Advertisements

What you'll learn

  • Take away 70+ tools in 20 downloadable resources: lecture presentations plus 10 interactive HTML tools for your own Google Sheets
  • Get our top working files: Budget vs Actual Checker, Lookup Builder, KPI Dashboard Planner and Automation Pack Builder
  • Rebuild a messy shared spreadsheet into a clean table with column types, dropdowns, validation rules and saved filter views
  • Build a monthly budget vs actual report with SUMIFS, date criteria and Over / Under / On track flags set by thresholds
  • Match records across files with XLOOKUP and IMPORTRANGE and keep a “Not found” queue instead of hidden #N/A errors
  • Set up a report tab that updates itself with FILTER, SORT, UNIQUE, QUERY and ARRAYFORMULA when new rows arrive
  • Answer one business question with a pivot table and a chart, then build a one-page KPI dashboard with sparklines and a slicer
  • Share files safely with an access map, protected ranges and version history, and run requests from Google Forms into a log
  • Automate weekly routine with a recorded macro and copy-and-edit Apps Script, and write tested prompts for Gemini, ChatGPT and Claude
  • Learn with Mike (1,800,000+ enrollments, 170,000 students) through 190+ step-by-step demos of Sheets, Forms, Apps Script and Gemini
This course includes:
7.5 total hours on-demand video
0 articles
20 downloadable resources
10 lessons
Full lifetime access
Access on mobile and TV
Certificate of completion
Advertisements

Course content

Requirements

  • No formula experience needed: you only need to enter data and make simple sums and filters
  • A free Google account; Gemini in Sheets in the AI lesson needs a Google Workspace plan that includes it
  • A web browser to open the 10 HTML tools — each starts with a filled example and a blank version for your data
  • A spreadsheet from your own work to apply each lesson to; optional ChatGPT or Claude for the AI lesson

Description

This course contains the use of artificial intelligence

Most teams don’t have a spreadsheet problem. They have twenty-three tabs, three copies of the same list and a Friday report built by hand.

This course turns that file into one working system in Google Sheets, with 70+ ready tools and 190+ step-by-step screen demos.

Sound familiar?

  • Nobody knows which tab is true. Tasks, Tasks OLD and Tasks (copy) all disagree.
  • Formulas break when the list grows. A VLOOKUP returns the wrong client, a total quietly misses seven rows.
  • Every report is manual. Someone spends Friday afternoon copying numbers into a summary nobody trusts.
  • AI feels like a toy. Gemini is right there in the sheet, but nobody knows what to ask it.

What changes after this course

You open your sheet on Monday and the answer is already there. Late tasks light up by themselves. The budget shows which line is over. The director gets a one-page dashboard link instead of an email with numbers. Forms feed a request log, a small script sends the reminders, and Gemini fixes the formula you used to spend an hour on. Less copying, fewer errors, more time for the work that actually matters.

Why learn this from Mike

  • 1,800,000+ course enrollments and 170,000 students on Udemy, and about 200 books on Amazon.
  • Built working systems on spreadsheets for years: at Wargaming he processed an employee survey of about 2,000 people and 160 columns, at the STB TV channel he learned how a well-built table makes the same numbers readable at a glance.
  • Built the HR system of the unicorn Preply and runs every course on practical tools, not slides.

How the course works

You follow Dana, an operations manager at a nonprofit food bank network, through one realistic file. First you rebuild the sheet as a real database with tables, column types and dropdowns. Then you master the everyday formulas: SUMIFS, IFS, XLOOKUP, IMPORTRANGE, FILTER, UNIQUE and QUERY. Next you turn data into answers with pivot tables, charts and a one-page KPI dashboard. After that you share safely with protected ranges and version history and collect data with Google Forms. Finally you automate the routine with macros and copy-and-edit Apps Script, and put Gemini in Sheets, ChatGPT and Claude to work on formulas, cleanup and analysis.

What’s included

  • 10 interactive HTML tools with 41 working tabs: structure check, budget checker, lookup builder, report tab builder, dashboard planner, automation pack and more.
  • 190+ step-by-step demos of Google Sheets, Forms, Apps Script and Gemini screens, one action at a time.
  • 10 templates you build during the lessons: task tracker, budget vs actual, client CRM, monthly report, KPI dashboard and more.
  • Practical assignments on your own spreadsheets after every lesson.
  • Lifetime access to all materials and active instructor support in Q&A.
  • Udemy Certificate of Completion.

Every month you wait, the Friday report gets built by hand again. Your colleagues who learn these tools now will be the ones everyone sends the link to.

Enroll now and start your first lesson today.

Who this course is for:

  • Office managers, admins and coordinators who run team work in Google Sheets and want 70+ ready tools instead of copied tabs
  • Team leads and department managers who build the Friday report by hand and want a report tab that updates itself
  • Small business owners and nonprofit operations managers who track budgets, clients, donors, shifts and requests
  • Excel users moving to Google Workspace who need XLOOKUP, QUERY, pivot tables and sharing rules the Google way
  • Anyone who wants Gemini, ChatGPT or Claude to write and fix spreadsheet formulas without trusting them blindly
Advertisements
PAPAHR_NOV_827944
Advertisements
Advertisements
Free Online Courses with Certificates
Logo
Register New Account