Excel

HLOOKUP Per the website, "HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row." Below, I wanted to return the number of Basis invoices paid on week 1, week 2, week 3, etc. I used the right formula here because the row index number is always one more than the week. Alternatively, on another sheet, I also just used an array constant that allowed me to use just one single formula to output the same result.

RIGHT  &  SUMIF As a Finance & Accounting Specialist, I need to report he unbilled media actual or the final numbers after billing is sent out to the client. I use the RIGHT function to return the first 2 letters of the invoice number because that represents the media type. Then, I can use the SUMIF function to return the net, commission, and gross for GENERAL media types, Out of Home (OH) media type, and Digital (DG) media type. Finally, everyone reports their numbers on an excel file to track the company's gross profit.                                  

LEFT, RIGHT, MID, LEN, FIND To find the whole number: 1) Use LEFT function because whole number is left of the decimal 2) FIND position of decimal and then subtract 1 (this will allow user to return everything before the decimal) To find the first name: 1) Use LEFT function because first name is left of the space 2) FIND position of space and then subtract 1 (this will allow user to return everything before the space) To find the last name: 1) Use the RIGHT function because last name is right of the space 2) Find the length of the full name using LEN function 3) FIND position of space 4) Subtract and get difference between length of full name and position of space (the full length minus characters spots the first name and space is using will result in the number of spots the last name is using)

Left, Right, & Mid Extract characters using the left, right, and mid function.  It was super useful to use the mid function to extract the area code and landline number (the 7 numbers after the area code). There is more to learn such as using FIND and LEN functions and combining them together.