SheetPointers Logo

Our Free Google Sheets Beginner Course

A beginner’s guide to Google Sheets for students, small business owners, teachers, data scientists and everyone in between. By the end of these 10 lessons, you will be more than capable to create your own beautiful spreadsheets for business, personal, and other uses. Not to mention as a job skill.

Unlike other courses, ours is free, and also includes commentated videos at the end of all articles, and exercises for most, so that you can test your knowledge.

This Course Was super helpful for my new job, I wouldn't have been able to receive it without the awesome help of Nikhil and Andrew at SheetPointers (Demo Review)
John Doe
Designer
This free course is better than any paid course out there. go take this course now! I is super cool and I'm just filling in text to make it longer (Demo Review)
John Doe
Designer

Lesson One

Basic Mathematical Operations

  • Addition + Subtraction
  • Multiplication + Division
  • Equations

Lesson Two

Basic Spreadsheet Structure

  • Cells
  • Spreadsheet Coordinates
  • Resizing Rows + Columns

Lesson Three

Dragging Formulas and Absolutes

  • Relative Dragging
  • Absolute Dragging
  • Formulas Altering During Dragging

Lesson Four

Conditional Formatting Basics

  • Color Coding
  • Reading the “Conditional Formatting Toolbox”
  • Understanding Conditional Formatting Equations

Lesson Five

Top 10 Formulas To Know For Beginners

  • Mathematical Formulas
  • Statistical Analysis Equations
  • Miscellaneous Useful Equations

Lesson Six

Quick and Easy Data Validation

  • Drop Down Lists
  • Preventing Fatal Data Errors
  • Lists Based on Ranges

Lesson Seven

Dragging Formulas and Absolutes

  • Relative Dragging
  • Absolute Dragging
  • Formulas Altering During Dragging

Lesson Eight

Make a Graph

  • How To Make and Edit a Graph
  • Learn to Add a Trend Line
  • Go Through Different Chart Types

Lesson Nine

Spreadsheet Formatting

  • Text Formatting
  • Background Colors
  • Cell Borders

Lesson Ten

If-Statements

  • Formula Structure
  • Countif, Averageif, etc.
  • Automating Decisions with If-Statements