Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Google Sheets In 1 Day With Fascinating Projects
Rating: 4.3 out of 5(371 ratings)
16,928 students

Learn Google Sheets In 1 Day With Fascinating Projects

Learn Google Sheets (Google Spreadsheets) by doing real-world business projects that you can apply to your business
Created byAlex Genadinik's Teaching Assistant
Last updated 11/2025
English
English [Auto],

What you'll learn

  • Learn Google Sheets quickly
  • Use Pivot Tables
  • Use sorting and filters
  • See three practical examples as class projects

Course content

2 sections • 13 lectures • 1h 4m total length

  • Introduction to this Google Sheets course2:33

    Discover Google Sheets quickly through real-world projects that show data slicing, SEO management, and data-driven business decisions, using core features to power any business in 1–2 days.

  • Getting started with G Suite (now Google Workspace)2:05

    Sign in to drive.google.com with your Google account to access Google Drive. Explore My Drive and the core apps: Google Docs, Google Sheets, Google Slides, and Google Forms, plus connect apps.

  • Google Sheets introduction6:08

    Learn Google Sheets basics: create blank spreadsheets, organize sales and marketing data in sheets with columns and rows, color-code sheets for readability, and share, collaborate, and use version history.

  • SEO example for how to use Google Sheets to track and prioritize SEO efforts9:07

    Use Google Sheets to track SEO, apply the 80/20 rule to prioritize lucrative pages, and log actions like building links to boost rankings.

  • Freezing and styling3:28

    Apply freezing and styling to Google Sheets to keep headers visible and improve readability, then color column headings to distinguish revenue streams and priorities.

  • Introduction to formulas2:26

    Discover how to use Google Sheets formulas to sum a column, like C2:C12, so totals update automatically and reduce manual errors.

  • How to create charts and graphs from Google Sheets data2:26

    Learn to turn revenue data into clear charts and graphs in Google Sheets, choosing chart types like column or pie, customizing colors, and embedding visuals in presentations.

  • Merging cells4:07

    Learn how to merge cells in Google Sheets to visually group related data, create categories, and improve readability with alignment, color coding, and formatting.

  • Introduction to Pivot Tables14:18

    Discover how pivot tables in Google Sheets create concise data summaries, reveal revenue patterns across courses, licensing, and other streams, and support presentations with clear charts.

  • Using filters to aid your decision making9:24

    Use Google Sheets filters and filter views to slice data, sort by revenue, and apply the 80-20 rule to identify top revenue streams like Udemy courses, licensing, and coaching.

  • Looking at a bigger data set5:55

    Discover how to organize a growing course dataset in Google Sheets by sorting for priority and revenue potential, turning hundreds of rows into a focused, high impact plan.

Requirements

  • No requirements

Description

Learn Google Sheets in a fascinating way by doing real-world, highly-applicable projects.

As I walk you through every important feature of Google Sheets, I'll be showing you real-world examples of situations where you can use your new Google Sheets skills. This way the course will stay interesting and move along more quickly.

Our first example will be for how to manage your SEO marketing by tracking progress in a spreadsheet.

The second example will show how to analyze revenue streams and business strategies in a data-driven approach.

The third example will be on how to plan and strategize even deeper

All examples will be of real cases that occur in my business. They are not small examples or toy examples. These are things that a real business uses and your business will likely go through the same situations too, which will make this course extremely useful.

GOOGLE SHEETS OR SPREADSHEETS

This is the same tool that is called by two different names so don't get confused. Google Sheets or Spreadsheets is essentially Google's cloud-based competitor to Microsoft Excel. Excel is used by nearly all midsize and large companies in the world. But if you don't want to pay for Microsoft Excel, Google Sheets is a great place to begin learning most of the important tools in Excel.

Invest in your future. Enroll today.

Who this course is for:

  • Professionals and business owners who need to use Microsoft Excel or Google Sheets

Report abuse