Главная
Study mode:
on
1
Introduction
2
Official Google Sheets training
3
What is Google Sheets
4
How to get Google Sheets
5
Start page
6
Top bar
7
Cells, columns, & rows
8
Zoom level
9
Enter data & smart fill
10
Format numbers
11
Adjust column widths & row heights
12
Move columns & rows
13
Alternating colors
14
Conditional formatting
15
Hide columns & rows
16
Insert columns & rows
17
Freeze columns & rows
18
Column stats
19
Explore
20
Addition
21
Subtraction
22
Multiplication
23
Division
24
Functions
25
SUM function
26
Relative & absolute references
27
Named ranges
28
VLOOKUP function
29
Multiple worksheets
30
Sort & filter
31
Filter views
32
Charts
33
Pivot tables
34
Create a new form
35
Share & collaborate with others
36
Version history
37
Publish, email, & print
38
Wrap up
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Master Google Sheets from scratch in this comprehensive 49-minute tutorial that progresses from basic spreadsheet operations to advanced data analysis features. Start with fundamental concepts like navigating the interface, working with cells, and entering data efficiently using smart fill. Learn essential formatting techniques including number formatting, column/row adjustments, and conditional formatting. Advance through mathematical operations and key functions like SUM and VLOOKUP while understanding crucial concepts such as relative/absolute references and named ranges. Explore data organization with multiple worksheets, sorting, and filtering capabilities. Create impactful visualizations using charts and pivot tables, integrate data collection through forms, and discover collaboration features including sharing, version history, and publishing options. Access additional free Google training resources and practice with provided sample workbooks to reinforce learning.

Google Sheets - From Basics to Advanced Features Tutorial

Kevin Stratvert
Add to list
0:00 / 0:00