Basic Excel Formulas
Learn the basic Excel formulas all SEOs need to know before you are able to actually begin working with Excel properly.
I run through Vlookups, IF statements, LEN, TRIM, PROPER / UPPER / LOWER, COUNTIFs & SUMs and show you some basic usage examples.
Knowing these will already heighten your Excel ability, as they will open up what you can do and how you begin to interpret data. And more than that, you will begin to see how much time you can save by using Excel.
No more manually copying and pasting data, these will help you format your data as required.
Vlookup - Find data for a value, within a range
Len - Count character length of a cell
Trim - Remove spaces before & after a cell
Sum - Add all numbers in a range together
Count - Display a count of cells with numbers in them
CountA - Display a count of cells with numbers and letters in them (so not empty)
CountIF - Count all the cells when a specific criteria is met
Proper - Capitalise the first letter of every word in a cell
Upper - Capitalise every letter of every word in a cell
Lower - Make every letter of every word in a cell lowercase
IF - Only do something when a certain condition is met