What you'll learn

Raw spreadsheets rarely answer business questions on their own. In this course, Summarize and Analyze Data in Google Sheets, you’ll learn to turn a cereal company’s sales and product data into decision-ready insights. First, you’ll calculate totals, conditional metrics, derived measures, and descriptive statistics. Next, you’ll build and refine pivot tables to compare products, categories, regions, and time periods. Finally, you’ll investigate patterns and outliers, develop follow-up questions, and use Gemini to generate observations that you validate against the underlying results. When you’re finished with this course, you’ll have the Google Sheets analysis skills needed to respond to stakeholder questions with accurate, defensible findings.