
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.