Google Sheets for Data Analysis and Workflow Automation

Learn Google Sheets for data prep, analysis & visualization, and build spreadsheet skills with fun, real-world projects!

Created by: Maven Analytics
Empowering everyday people with life-changing data skills

Created by: Enrique Ruiz
Certified Microsoft Excel Expert

What Will I Learn?

• Learn how to create and manage worksheets and navigate the Google Sheets interface
• Build foundational data literacy skills, including managing, exploring, analyzing and visualizing data
• Write spreadsheet formulas and functions to aggregate values, create logical tests, join data, and manipulate text and dates
• Use Pivot Tables to explore and analyze data, including grouping, sorting, filtering and more
• Learn data visualization and storytelling best practices, and bring data to life using common charts and graphs
• Apply sharing and collaboration tools like notes, comments, timelines, protection, and web publishing

Requirements

• We'll be using Google Sheets for course demos (free, in-browser)
• No experience required – we'll start with the absolute basics!

Target audience

• Spreadsheet users who want to build job-ready data prep, data analysis, visualization and collaboration skills
• Data professionals looking for an intuitive, comprehensive introduction to Google Sheets
• Students looking to learn practical skills with unique, hands-on projects and demos
• Anyone looking to develop core data literacy and analytical thinking skills