Free demo · Google Sheets · Lesson 10 · Enrol

Enrol in the full Google Sheets course

Enrollment is simply a phone call or WhatsApp away. Call or WhatsApp +91 90510 42886 and tell us which programme interests you.

The full Google Sheets with Gemini AI course

157slides
17quizzes
20assignments
  • ✓ Four levels: Introduction, Basics, Intermediate and Advanced
  • ✓ Cells, formatting, core functions, sorting, filtering and charts
  • ✓ IF, text, dates, lookups, arrays, pivot tables, QUERY, macros and Apps Script
  • ✓ Gemini AI in every level: formulas from a prompt, analysis, the AI function, checking the numbers
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

MAVI Foundation teaches Google Sheets at its head office at 11/A Jora Pukur Square Lane, near Girish Park Metro Station (Gate No. 3), Kolkata 700006. Google Sheets from your first cell to pivot tables, QUERY and automation: formatting, formulas, lookups, charts, data tools and teamwork, with Gemini AI for formulas and analysis at every level. To enrol, call or WhatsApp +91 90510 42886 and tell us which programme interests you, or visit the contact page at mavifoundation.org/contact.

Key points

  • Four levels: Introduction, Basics, Intermediate and Advanced
  • Cells, formatting, core functions, sorting, filtering and charts
  • IF, text, dates, lookups, arrays, pivot tables, QUERY, macros and Apps Script
  • Gemini AI in every level: formulas from a prompt, analysis, the AI function, checking the numbers