Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Sheets Data Analysis: Pivot Tables and Gemini AI
New
1 students

Google Sheets Data Analysis: Pivot Tables and Gemini AI

Analyze data in Google Sheets: calculate business metrics, build pivot tables and validate results with Gemini.
Created byACHRAF ER-RAYA
Last updated 10/2026
English

What you'll learn

  • Summarize and analyze raw data in Google Sheets using dynamic conditional aggregation formulas like SUMIFS and COUNTIFS.
  • Build dynamic interactive Pivot Tables to group, filter, and segment business data for executive-level reporting.
  • Incorporate Gemini AI inside Google Sheets to quickly audit complex formulas, check errors, and generate summaries.
  • Transform messy datasets into clean, presentation-ready business metrics and dashboards without manual work.

Course content

5 sections • 7 lectures • 1h 2m total length
  • Calculating Key Business KPIs & Revenue Metrics11:04
  • Calculating Key Business KPIs & Revenue Metrics (PART2)10:00

Requirements

  • A free Google account and basic familiarity with opening spreadsheets and typing cell values—no prior advanced math or coding experience required.

Description

This course contains the use of artificial intelligence.

Transform raw rows of data into high-impact executive summaries. Mastering Google Sheets is no longer about remembering formulas; it is about knowing how to structure data, calculate business metrics quickly, and use AI to audit your calculations.

Whether you are managing sales reports, tracking operational costs, or presenting quarterly outcomes, this course provides a clear, step-by-step path to analyzing spreadsheets with confidence.

Who this course is for:

  • Business analysts looking to automate their daily spreadsheet reporting workflows.

  • Marketing managers needing to calculate ROI, CAC, and conversion metrics across campaigns.

  • Small business owners seeking clear financial visibility using free Google tools.

  • Operations coordinators managing inventory, tracking logistics, and cleaning raw sales data.

  • Beginners and intermediate spreadsheet users wanting to master Pivot Tables and AI integration.

What you will learn:

  • Clean raw datasets and prepare them for formula-driven aggregation

  • Write conditional functions including SUMIFS, COUNTIFS, and AVERAGEIFS

  • Build dynamic Pivot Tables with custom calculations and custom grouping

  • Validate complex calculations and audit formula errors using Gemini AI

  • Summarize key business KPIs like customer acquisition cost and gross margins

  • Build dynamic summary dashboards that update automatically when raw data changes

  • Generate automated executive commentary using natural language AI prompts

  • Apply conditional formatting to highlight critical financial trends instantly

Requirements:

  • A free Google account to access Google Sheets and Gemini.

  • Basic familiarity with opening spreadsheets and entering data into cells.

Final Project Description: For your capstone project, you will act as a Lead Business Analyst for a multi-channel retail brand. You will be given a raw dataset containing over 5,000 transaction rows with missing values, inconsistent dates, and mixed categories.

You will clean the dataset, write SUMIFS formulas to summarize sales performance by region, construct an interactive Pivot Table to break down quarterly profitability, and run Gemini AI prompts to audit your figures and draft a 1-page executive summary for leadership.

Who this course is for:

  • Business analysts, marketers, operations managers, and spreadsheet users who want to master data analysis, Pivot Tables, and Gemini AI in Google Sheets.