A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | |||||||||||
3 | Excel Cheatsheet for SEOs | ||||||||||
4 | Created by Fiona Soum, SEO Consultant at Builtvisible | ||||||||||
5 | For more explanation, visit the Builtvisible blog | ||||||||||
6 | |||||||||||
7 | # | Tab | Goal | ||||||||
8 | 1 | URL Manipulation | // Manipulate URLs to extract or remove a piece, whether it is related to the domain or to the URL path | ||||||||
9 | 2 | Data Manipulation | // Manipulate data to return the desired result - incl. vlookup, if, countif, ifs, index match | ||||||||
10 | 3 | Excel Shortcuts | // Use these Excel shortcuts to speed-up your work | ||||||||
11 | 4 | Excel File Manipulation | // Manipulate the Excel file format | ||||||||
12 | 5 | Useful Resources | // Useful Excel/Google Sheet resources seen on the Internet | ||||||||
13 | |||||||||||
14 | |||||||||||
15 | NOTES | ||||||||||
16 | |||||||||||
17 | |||||||||||
18 | |||||||||||
19 | |||||||||||
20 | |||||||||||
21 | |||||||||||
22 |