Master Gemini in Google Sheets: The 16-Hour AI Spreadsheet Revolution
Stop battling complex formulas, messy data dumps, and tedious formatting,Transform how you work with data in just 8 transformative sessions.
Master Gemini in Google Sheets: The 16-Hour AI Spreadsheet Revolution
Start Date
10 May 2026
Lessons
8 Sessions
Duration
16 Total Hours
Schedule
Sunday & Tuesday 7-9 PM Cairo Time
Are you still Analyzing Data the hard way?
If you spend hours cleaning up CSV files, Googling complex nested formulas, or manually
building pivot tables and charts for executive meetings, you are losing valuable time.
The future of spreadsheet management is here. Gemini in Google Sheets acts as your
personal AI data analyst, capable of building complex tracking systems, predicting trends, writing formulas, and cleaning thousands of rows of data—all from simple text prompts.
Join our 8-Session, Intensive Training Course (2 hours per session) and learn how to turn
hours of manual spreadsheet labor into seconds of AI-powered efficiency.
What You Will Achieve
By the end of this 16-hour masterclass, you will be able to:
- Generate comprehensive project trackers and tables in seconds
- Command AI to write complex, error-free formulas instantly.
- Uncover predictive insights and hidden trends in massive datasets.
- Automate tedious formatting, data cleanup, and visual reporting.
Course Syllabus: 8 Sessions to AI Mastery
Module 1: The AI Workspace Foundation (2 Hours)
Master the Gemini Interface & Prompting Basics
Learn how to communicate effectively with Gemini to set yourself up for success. We’ll cover
the core interface, how to preview and undo actions safely, and how to isolate AI analysis using
Tab Focusing so it only reads the data you want.
● Real-World Skill: Learn how to create and chat with a custom “Gem” (like a Resume
Parsing Gem) to automate repetitive prompting tasks
Module 2: Instant Data Formatting & Cleanup (2 Hours)
From Messy Data Dumps to Professional Ledgers
Stop manually inserting columns and copying data. Learn to command Gemini to instantly
Format as a Table, Set Number Formats (like localizing global currencies), Freeze
Dimensions, and Fill Ranges.
● Real-World Skill: Transform a raw, unformatted client CSV into a beautiful, client-facing
table with banded rows and frozen headers with a single prompt.
Module 3: Automating Checkboxes, Dropdowns & UI Elements (2 Hours)
Building Interactive Trackers & Enforcing Data Integrity
Move beyond static numbers. Learn how to instantly insert Checkboxes, convert messy
manual entries into strict Dropdown lists, and execute massive Find and Replace operations
across historical databases.
● Real-World Skill: Act like a Data Compliance Officer by converting thousands of
misspelled country names into a standardized, error-free dropdown menu instantly
Module 4: Advanced Filtering, Sorting & Conditional Logic (2 Hours)
Finding the Needle in the Data Haystack
Learn how to manipulate thousands of rows instantly. Command Gemini to apply advanced
Filters, Sort Data using multiple criteria, and instantly apply Conditional Formatting to
highlight critical anomalies.
● Real-World Skill: Survive live executive meetings by instantly prompting Gemini to “Filter
for deals lost to competitors in EMEA over $50k,” or automatically highlight urgent
stockout risks in red.
Module 5: AI-Powered Formulas & Pivot Tables (2 Hours)
Bypass the Complex Syntax
Never struggle with VLOOKUP, INDEX/MATCH, or DATEDIF again. Learn how to describe the
calculation you need in plain English and let Gemini Create the Formula. Plus, learn to instantly
generate multi-variable Pivot Tables.
● Real-World Skill: Calculate exact employee tenure down to the day accounting for leap
years, or instantly generate an e-commerce revenue pivot table broken down by
category and region—no manual building required.
Module 6: Rapid Content & Structure Generation (2 Hours)
Creating Frameworks from Scratch
Don’t stare at a blank sheet. Learn how to ask Gemini to Create Tables from thin air and even
Generate Images for placeholders. We will also cover how to instantly Summarize Data to
find the signal in the noise.
● Real-World Skill: Take two years of unstructured customer feedback and have Gemini
instantly summarize the top three product feature requests and complaints
Module 7: Deep Data Analysis & Predictive Insights (2 Hours)
From Data Entry to Strategic Analyst
Unlock the most powerful features of Gemini. We will cover how to Generate Data Analysis &
Insights and ask Gemini to Solve Optimization Tasks.
● Real-World Skill: Upload regional sales data and ask Gemini to identify seasonality
trends and predict next quarter’s underperformers, or optimize logistics delivery routes
to minimize fuel usage.
Module 8: Visualizations, Reporting & Multi-Step Macros (2 Hours)
Presenting to the Board & Automating Workflows
Bring it all together. Learn to Build Charts & Graphs (like complex waterfall charts) directly
alongside your data. We’ll also teach you how to execute Multi-step Tasks in one prompt, view
underlying Code, and seamlessly Export to Docs for executive summaries.
● Real-World Skill: Command Gemini to execute a 4-step formatting macro in one
sentence, generate a board-ready chart, and export the written statistical analysis
directly to a Google Doc.
Q: “Is this course for me?”
This program is FOR you if…
- Project Managers & Operations: Automate tracking and streamline task management
- Financial & Data Analysts: Speed up complex analysis, formula generation, and
- Marketing & Sales Leaders: Instantly summarize campaign data and predict sales
- HR & Administrative Professionals: Clean up massive employee rosters, format data, and automate repetitive organizational tasks.
This program is NOT for you if…
- You want a "Data Analyst" title: This is for business pros boosting their current roles, not a career-change bootcamp.
- You want to be a programmer: We focus on practical business results, not deep-level software engineering or Python.
- You prefer the "Old Way": If you aren't interested in using AI or automation to speed up your workflow, this isn't for you.
- You’re already an expert coder: If you’re a pro at writing complex SQL or Apps Script from scratch, this will be too basic.
- You just want theory: This is a hands-on course for people who intend to apply these skills to real business data immediately
Learn With DR. Ashraf Al Shafaki
- Started computer programming since I was a child at primary school 40 years ago
- Delivered programming training at IBM Authorized Training Centers in multiple programming languages including C, Java and many others 25 years ago
- Started learning AI algorithms, machine learning and neural network programming 29 years ago
- Conducted 69 training sessions on 69 different AI topics to members of the AI Community Plus
- Conducted AI training for managers and employees at the Egyptian Banking Institute, Mideast Communication Services and other corporate clients
- Currently Applied AI Track Head at the Ministry of Communication & Information Technology’s Digital Egypt Builders Initiative
Master Gemini in Google Sheets
10000 EGP
12500 EGP
Live, interactive virtual workshops
8 Sessions (2 hours per session / 16 total hours)
Access to session recordings and a master "Prompt Library" cheat sheet.
Basic familiarity with Google Sheets. No coding or advanced formula knowledge required!
Limited Capacity
Frequently Asked Questions
Q : Is this course held in person or online?
A: The course is conducted entirely online via Zoom. This allows you to participate from anywhere while following along on your own screen.
Q: Do I need to be a math expert or a coder to take this course?
A: Not at all. This course is designed specifically for business professionals, starting from “very beginner” fundamentals in Session 1. While we do cover advanced topics like Apps Script and complex formulas, we teach you how to use AI to do the heavy lifting for you.
Q: What are the prerequisites for joining?
A: There are no advanced technical prerequisites. You only need a Google account to access Google Sheets and a willingness to explore AI tools. The course builds from the ground up, covering interface navigation and basic operations before moving into advanced automation.
Q: Will I receive a certificate upon completion?
A: Yes. To earn your certificate, you must complete the Capstone Project in Session 8. This involves demonstrating your skills by cleaning a dataset of 500+ rows, using at least 5 different formula types, and building a full interactive dashboard with 6+ visualizations.
Q: How is this different from a Data Analyst bootcamp?
A: Most data analyst courses focus on career switching, deep statistics, and heavy programming (like Python or SQL). This course is different. It is built for professionals—Marketers, HR Managers, Accountants, and Ops Leads—who want to stay in their current field but use AI to increase their productivity and advance their careers.
Q: Can I apply these skills to my specific industry?
A: Absolutely. The course uses diverse practice datasets, including E-commerce sales, Customer feedback/reviews, Financial transactions, HR/employee data, and Marketing campaign results. The techniques you learn are designed to be “plug-and-play” for any business environment.