Google Sheets: Pivot Tables + Data Insights For Beginners!

Learn to explore data & uncover insights with Google Sheets pivot tables! Course taught by fmr Google Analytical Lead.
Rating: 4.1 out of 5 (425 ratings)
19,165 students
English
English [Auto]
Google Sheets: Pivot Tables + Data Insights For Beginners!
Rating: 4.1 out of 5 (425 ratings)
19,165 students
Gain proficiency exploring data & uncovering insights with Google Sheets pivot tables.
Learn to frame data analysis investigation questions and use Sheets pivot tables to find answers.
Get comfortable using a data insights + pivot tables process that will enable you to do data analysis on your own.
Save time using pivot tables for data analysis vs doing manual data calculations.
Get basic understanding of how pivot tables can be used to power advanced data visualizations and dashboards.

Requirements

  • Basic understanding of Google Sheets (if needed, you could learn along the way)
  • High school math concepts (if needed, you could do a quick refresh during the course)

Description

  • Do you have data in Google Sheets and not sure how to make it useful? Then this course is for you!

  • Do you want to get on the path to being Data-Savvy? Then this course is for you!

  • Do you want to grow your Google Sheets data skills? Then this course is for you!

This course has been *designed by a former Google Analytical Lead* so that you can get comfortable going from rows and columns of data in a Google Sheet to useful insights via pivot tables.

This course includes numerous hands-on examples and practice exercises that will get you feeling data-savvy.

As a bonus, practice exercises and lecture examples are included in a spreadsheet that you can keep as part of the course.

This course is broken out into 8 key sections:

  • Section 1: Introduction (what are pivot tables and how they are used in the real-world to surface data insights)

  • Section 2: An Overview of the Data Insights Pivot Table Process

  • Section 3: Applying the Data Insights Pivot Table Process

  • Section 4: Practice Exercises: Set 1 (Titanic Dataset)

  • Section 5: Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)

  • Section 6: Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 7: Solution Videos for Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 8: Course Wrap + Bonus Content

The content has intentionally been curated for practitioners who want to apply learnings right away.

This is NOT a long drawn out course that goes deep in the weeds on academic theory.

Make the transition from decisions based on gut feel to data informed decision making!

Use this efficiently designed course to level up your data skills. Get started today! 

#AlwaysBeLearning

Who this course is for:

  • Data insights beginner who wants to learn to further explore data and surface insights that can inform business decisions.
  • Anyone not comfortable extracting insights from data using Google Sheets.
  • Professionals who are not satisfied with their job and who want to get on the path to building a data analytics career.
  • Any students in college who want to get started learning data skills.
  • This course is not for those who are already doing advanced data analysis with Google Sheets pivot tables.

Course content

8 sections • 43 lectures • 2h 55m total length
  • Course Promo Video!
    01:46
  • What You Can Expect To Get Out Of This Course
    04:51
  • Meet The Instructor (Former Googler; Now Data Skills Bootcamp Founder)
    05:01
  • Why I’m Confident You’ll Enjoy This Course
    03:00
  • Real World Examples Using Pivot Tables To Surface Data Insights
    08:51
  • Glossary Of Data Terms We'll Be Using In The Course
    00:05
  • What Is A Pivot Table?
    2 questions
  • Questions? Feedback? => Message me or see the the course Q&A
    00:06

Instructor

Helping Companies Use Data Insights To Decision Making
Brian Moore
  • 4.1 Instructor Rating
  • 425 Reviews
  • 19,165 Students
  • 1 Course

Hello, my name is Brian Moore, welcome to my Udemy course page!

I enjoy using analytics/data insights to inform strategic business/product decisions. I’m an expert in generating and sharing data insights with senior technical and non-technical stakeholders.

I’m a practitioner of an apprenticeship + continuous learning approach. At Google, I worked with and studied under leading experts in data science and business. In addition to continuous learning from experts in the field, I strengthen my knowledge by applying skills on real-world projects and adhere to an ongoing self-study routine (using online resources, learning platforms, books, podcasts, YouTube channels, conferences, etc.).

More on my background and learning approach can be found on via my LinkedIn or website.

Feel free to send me a message for questions and/or feedback!

#AlwaysBeLearning

– Brian Moore