All the ways to extract text and numbers in Google Sheets

1

How to use the FILTER function in Google Sheets (Single or Multiple Conditions)

Spreadsheet Class

2

5 formulas that combine columns in Google Sheets (Horizontal and Vertical)

Spreadsheet Class

▶

All the ways to extract text and numbers in Google Sheets

Spreadsheet Class

4

How to filter based on a list in Google Sheets

Spreadsheet Class

5

How to fix the "FILTER has mismatched range sizes" error in Google Sheets

Spreadsheet Class

6

How to color cells, and alternate row colors in Google Sheets

Spreadsheet Class

7

How to automatically create a series of values in Google Sheets

Spreadsheet Class

8

Google Sheets Beginner Tutorial

Spreadsheet Class

9

How to make a Dashboard in Google Sheets (Full Tutorial)

Spreadsheet Class

10

Using the SORT and FILTER function in the same formula in Google Sheets

Spreadsheet Class

11

ARRAYFORMULA function: Apply a formula to an entire column in Google Sheets

Spreadsheet Class

12

Automatically resize columns in Google Sheets with Fit to Data

Spreadsheet Class

13

How to import or convert a CSV file into Google Sheets

Spreadsheet Class

14

How to export / download a CSV from Google Sheets

Spreadsheet Class

15

How to change text case in Google Sheets with UPPER LOWER and PROPER

Spreadsheet Class

16

How to use the Calendar Template in Google Sheets

Spreadsheet Class

17

How to rotate text in Google Sheets

Spreadsheet Class

18

How to create charts in Google Sheets (And how to customize them too)

Spreadsheet Class

19

How to copy formulas, and lock cell references in Google Sheets (Relative & absolute references)

Spreadsheet Class

20

How to copy and paste values only in Google Sheets

Spreadsheet Class

21

How to fix the "Circular Dependency Detected" error in Google Sheets

Spreadsheet Class

22

Evenly space columns in Google Sheets (Make columns the same size quickly)

Spreadsheet Class

23

Doing math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root

Spreadsheet Class

24

How to filter horizontally in Google Sheets (Filter columns)

Spreadsheet Class

25

UNIQUE function: Removing duplicates with 2 methods in Google Sheets

Spreadsheet Class

26

Report Builder template for Google Sheets (Automatically organize / calculate your data)

Spreadsheet Class

27

Build a Google Sheets dashboard with Google Forms data (Automated)

Spreadsheet Class

28

Guitar tabs template for Google Sheets (& PDF) | Create your songs in a Google spreadsheet

Spreadsheet Class

29

Interactive Google Sheets dashboard with drop down menus tutorial

Spreadsheet Class

30

Student attendance dashboard tutorial in Google Sheets: Simple + advanced

Spreadsheet Class

31

SORT function in Google Sheets (Sort data vertically or horizontally)

Spreadsheet Class

32

How to use the SORT function in Google Sheets (Quick Version)

Spreadsheet Class

33

How to copy chart formatting and duplicate charts in Google Sheets

Spreadsheet Class

34

How to copy a tab to a new file / sheet in Google Sheets

Spreadsheet Class

35

How to duplicate tabs in Google Sheets

Spreadsheet Class

36

How to hide and unhide tabs in Google Sheets

Spreadsheet Class

37

How to make a copy of a file in Google Sheets

Spreadsheet Class

38

How to change tab color in Google Sheets

Spreadsheet Class

39

How to insert, delete, rename, and reorder tabs in Google Sheets

Spreadsheet Class

40

How to move a chart to another sheet in Google Sheets

Spreadsheet Class

41

How to wrap text, unwrap text, and clip text in Google Sheets

Spreadsheet Class

42

Switch columns and rows with the TRANSPOSE function in Google Sheets

Spreadsheet Class

43

Project management timeline template for Google Sheets (Gantt Chart)

Spreadsheet Class

44

Build a dashboard in 3 simple steps (Google Sheets)

Spreadsheet Class

45

Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)

Spreadsheet Class

46

(Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping

Spreadsheet Class

47

Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices

Spreadsheet Class

48

Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)

Spreadsheet Class

49

How to create drop-down lists in Google Sheets (Data validation)

Spreadsheet Class

50

The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)

Spreadsheet Class

51

3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA

Spreadsheet Class

52

Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)

Spreadsheet Class

53

How to indent in Google Sheets (5 Methods)

Spreadsheet Class

54

Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)

Spreadsheet Class

55

How to create and customize charts in Google Sheets (Quick version)

Spreadsheet Class

56

Apply a formula to an entire column in Google Sheets with the ARRAYFORMULA function | Quick Version

Spreadsheet Class

57

How to insert a new line in a cell (or formula) in Google Sheets

Spreadsheet Class

58

How to freeze rows & columns (& How to unfreeze) in Google Sheets

Spreadsheet Class

59

How to add and sum in Google Sheets (Addition and SUM function)

Spreadsheet Class

60

How to average in Google Sheets (Using the AVERAGE function)

Spreadsheet Class