---
title: "Google Sheets Course: Practical Skills - Free Course by Layerpath"
h1: "Google Sheets 101 Course"
description: "Learn to organize, analyze, and visualize data with ease — from VLOOKUPs and pivot tables to charts, dropdowns, and automation tricks. Perfect for professionals, students, and teams ready to go beyond the basics."
route: "/learn/courses/google-sheets"
canonical: "https://www.layerpath.com/learn/courses/google-sheets"
---

# Google Sheets 101 Course

Learn to organize, analyze, and visualize data with ease. Perfect for professionals, students, and teams ready to go beyond the basics.

[Learn Google Sheets for FREE](./google-sheets#lesson1play)

> **"I used to just enter data and hope for the best, but this course completely changed how I use Google Sheets. I finally understand VLOOKUP, pivot tables, and all those features I used to avoid. The lessons are short, clear, and super useful. If you want to feel confident using Sheets at work or school, this is the course to take."**

## Lesson 1: How to Use VLOOKUP in Google Sheets

Master this powerful function to pull data from other tables — a must-know for managing large sheets or dashboards.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqohuku00010dkzg820dt4c/tour

Tour id: cmaqohuku00010dkzg820dt4c

[Next Lesson](./google-sheets#lesson2play)

## Lesson 2: How to Create a Pivot Table in Google Sheets

Turn rows of raw data into meaningful summaries with built-in pivot tables — no need for advanced formulas.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqokenl000i0dkz0ft6ak8t/tour

Tour id: cmaqokenl000i0dkz0ft6ak8t

[Next Lesson](./google-sheets#lesson3play)

## Lesson 3: How to Apply Conditional Formatting in Google Sheets

Automatically highlight key insights like overdue tasks, low values, or duplicates to make your sheets more visual and useful.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqomd71002j0dkzdaur8kgc/tour

Tour id: cmaqomd71002j0dkzdaur8kgc

[Next Lesson](./google-sheets#lesson4play)

## Lesson 4: How to Create a Drop-Down List in Google Sheets

Streamline data entry and minimize errors with selectable cell options — perfect for forms, checklists, and templates.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqooy24003c0dkzhah11th2/tour

Tour id: cmaqooy24003c0dkzhah11th2

[Next Lesson](./google-sheets#lesson5play)

## Lesson 5: How to Combine First and Last Name in Google Sheets

Learn quick formulas to merge names or any other text — useful for contact lists, mail merges, and reporting.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqorzb500450dkz5h2k2cnf/tour

Tour id: cmaqorzb500450dkz5h2k2cnf

[Next Lesson](./google-sheets#lesson6play)

## Lesson 6: How to Randomize a List in Google Sheets

Shuffle entries with ease — great for giveaways, sampling, seating plans, or task rotations.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqowhjq00000dl76dg4dafb/tour

Tour id: cmaqowhjq00000dl76dg4dafb

[Next Lesson](./google-sheets#lesson7play)

## Lesson 7: How to Create a Bar Graph in Google Sheets

Visualize your data fast with clear bar charts — essential for presentations and stakeholder updates.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqotkir004o0dkz2pef4qyp/tour

Tour id: cmaqotkir004o0dkz2pef4qyp

[Next Lesson](./google-sheets#lesson8play)

## Lesson 8: How to Highlight Duplicates in Google Sheets

Spot and clean up repeated entries using simple conditional formatting tricks.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cmaqoyt27005d0dkzgyq405nr/tour

Tour id: cmaqoyt27005d0dkzgyq405nr

[Explore Layerpath](https://layerpath.com/)