Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

Google Sheets - Full Course for Beginners

via freeCodeCamp

Overview

Coursera Plus Monthly Sale:
All Certificates & Courses 40% Off!
Grab it
Master the fundamentals of spreadsheet management in this comprehensive video course designed for beginners. Navigate through essential features including interface navigation, sharing capabilities, and collaborative tools while building practical skills in formula creation and function implementation. Progress from basic operations to advanced concepts like conditional formatting, dropdown lists, and data validation. Explore powerful data visualization techniques through the creation of various chart types including pie, column, and line charts. Dive into advanced functionality with custom Apps Script functions and menu creation. Practice with a provided template spreadsheet while following along with structured modules covering everything from basic toolbar operations to sophisticated data analysis and visualization techniques. By the end of this 95-minute hands-on tutorial, gain the confidence to effectively manage, analyze, and present data using one of the most popular cloud-based spreadsheet applications.

Syllabus

⌨️ Course Overview
⌨️ Module 1 - Interface
⌨️ Navigation
⌨️ Toolbar
⌨️ Collaboration
⌨️ Module 2 - Categories Table
⌨️ Import Data
⌨️ Basic Functions
⌨️ Balance Formula
⌨️ Module 3 - Formatting
⌨️ Table Format
⌨️ Conditional Formatting
⌨️ Module 4 - Data Intro
⌨️ Dropdowns
⌨️ Module 5 - Advanced Functions
⌨️ Type Column
⌨️ Filtering
⌨️ Slicers
⌨️ Search Bar
⌨️ Module 6 - Data Visualization
⌨️ Balance IF Column Cleanup
⌨️ Pie Chart
⌨️ Column Chart
⌨️ Line Chart
⌨️ Module 7 - Apps Script
⌨️ Custom Functions
⌨️ Custom Menu
⌨️ Got Sheet

Taught by

freeCodeCamp.org

Reviews

Start your review of Google Sheets - Full Course for Beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.