A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | This tool supports my talk at Women In Tech SEO Festival (#WTSfest) - by @hannahrampton | Slides here: | https://hanr.link/WTSfest-2020-Slides | |||||||
3 | ||||||||||
4 | FORMAT | CALCULATE | CONDITIONALS | QUERY | APPLICATION | |||||
5 | ||||||||||
6 | TRIM | SUM | SUMIF | IMPORTXML | Example: UTM Example | |||||
7 | LEN | MIN | SUMIFS | IMPORTRANGE | ||||||
8 | MID | MAX | MINIFS | VLOOKUP | Example: QUERY 'IF' CONDITIONAL | |||||
9 | SPLIT | AVG | MAXIFS | INDEX | ||||||
10 | CONCATENATE | COUNT | AVERAGEIF | MATCH | ||||||
11 | PROPER | COUNTA | AVERAGEIFS | FIND | ||||||
12 | UPPER | COUNTIF | SEARCH | |||||||
13 | LOWER | COUNTBLANK | COUNTIFS | REGEXMATCH | ||||||
14 | LEN | COUNTUNIQUES | COUNTUNIQUESIF | QUERY (FUNCTION) | ||||||
15 | ISBLANK | IF | ||||||||
16 | ISNUMBER | IFS | ||||||||
17 | ISURL | |||||||||
18 | ||||||||||
19 | ||||||||||
20 | ||||||||||
21 | ||||||||||
22 | ||||||||||
23 | ||||||||||
24 | ||||||||||
25 |