Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MASTERING GOOGLE SHEETS
SETTING IT UP
USE TEMPLATES (1:18)
USE THEMES (3:31)
WORK OFFLINE (1:11)
LOCK THE HEADER (2:22)
COMMENT (1:20)
SHARING (1:47)
VERSION CONTROL AND EDIT HISTORY (1:50)
FORMATTING
PASTE SPECIAL VALUES (0:40)
ADD BORDERS (2:48)
DATA VALIDATION (8:14)
INSERT CHECKBOXES (2:17)
NAMED RANGES AND PROTECTION (2:41)
CONDITIONAL FORMATTING (10:56)
UNICHAR EMOJIS (3:20)
TEXT CLEANING (5:30)
FORMULAS
SHORTCUTS AND SEARCH OPTION (2:22)
FUNCTION HELP (2:57)
UNIQUE() (1:45)
ISEMAIL() AND HYPERLINK() (1:58)
GOOGLETRANSLATE() AND GOOGLEFINANCE() (2:16)
IMPORTRANGE(), IMPORTHTML(), IMPORTFEED() (7:15)
SPARKLINE() (2:13)
IMAGE() (2:53)
ARRAYFORMULA() (2:36)
ANALYSIS
INSERT SLICER (3:11)
PIVOT TABLES (5:29)
EXPLORE AND QUERY (AI FEATURE) (1:57)
SHOW FORMULAS INSTEAD OF RESULTS (0:43)
EXTERNAL
CONNECT TO FORM FOR SURVEYS (2:32)
CONNECT TO DOC AND SLIDES (0:54)
ADVANCED
SCRIPT EDITOR, MACROS AND ADD-ONS (18:36)
Get Your Certificate
ISEMAIL() AND HYPERLINK()
Complete and Continue