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

=VLOOKUP(*CELL of what you want to search for*,*RANGE of where you want to look for it*,*COLUMN NUMBER the data is in you want to extract*,*TRUE (1) or FALSE (0) but 99% will be FALSE*)

 

Len - Count character length of a cell

=LEN(*CELL to count*)

 

Trim - Remove spaces before & after a cell

=TRIM(*CELL to trim*)

 

Sum - Add all numbers in a range together

=SUM(*RANGE to add together*)

 

Count - Display a count of cells with numbers in them

=COUNT(*RANGE to count for numbers*)

 

CountA - Display a count of cells with numbers and letters in them (so not empty)

=COUNTA(*RANGE to count for numbers*)

 

CountIF - Count all the cells when a specific criteria is met

=COUNTIF(*RANGE to count for numbers*,*CRITERIA for when to count*)

 

Proper - Capitalise the first letter of every word in a cell

=PROPER(*CELL to capitalise first letters*)

 

Upper - Capitalise every letter of every word in a cell

=UPPER(*CELL to capitalise everything*)

 

Lower - Make every letter of every word in a cell lowercase

=LOWER(*CELL to lowercase*)

 

IF - Only do something when a certain condition is met

=IF(*The condition to run*,*What to do if it's true,*What to do if it's false*)

 

2 Comments

  1. Love your videos. We all do many of the same things in Excel daily but I really enjoy seeing how others meet their end goal. Thanks

    Reply
    • Hey Adam,

      Great to know you’re doing similar things and that you enjoyed the videos 🙂

      Thanks,
      Sam.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.
Download the Google Analytics Dashboard
  You will receive a download link via email. We hate spam and never share your details.
Download the Excel Reporting Templates
  You will receive a download link via email. We hate spam and never share your details.