Google Sheets Tutorial for Beginners | Free Online Course — CourseBond

coursebond Insights Teach on CourseBond Log in Sign up

Course content

Section 1: Introduction

0 / 8 9 min
- Introduction Preview 1:00
- Official Google Sheets training 1:00
- What is Google Sheets 1:00
- How to get Google Sheets 1:06
- Start page 1:00
- Top bar 1:56
- Cells, columns, & rows 1:04
- Zoom level 1:00
Section 2: Part 2: Enter data & smart fill

0 / 8 10 min
- Enter data & smart fill 2:18
- Format numbers 1:00
- Adjust column widths & row heights 1:23
- Move columns & rows 1:00
- Alternating colors 1:00
- Conditional formatting 1:25
- Hide columns & rows 1:00
- Insert columns & rows 1:00
Section 3: Part 3: Freeze columns & rows

0 / 8 9 min
- Freeze columns & rows 1:00
- Column stats 1:19
- Explore 1:00
- Addition 1:58
- Subtraction 1:00
- Multiplication 1:00
- Division 1:00
- Functions 1:00
Section 4: Part 4: SUM function

0 / 8 15 min
- SUM function 2:13
- Relative & absolute references 2:27
- Named ranges 1:12
- VLOOKUP function 2:25
- Multiple worksheets 2:00
- Sort & filter 1:33
- Filter views 1:09
- Charts 2:30
Section 5: Advanced Topics

0 / 6 11 min
- Pivot tables 3:40
- Create a new form 1:34
- Share & collaborate with others 3:01
- Version history 1:00
- Publish, email, & print 1:00
- Wrap up 1:00

Enroll to watch this lesson

Get full lifetime access to all course material.