Library Website : Excel for Business Majors: Intermediate Skills

Intermediate Excel Functions

IF- returns different values depending on whether a condition is true or false
SUMIF- adds numbers within a range if they fit certain criteria
COUNTIF- counts the number of cells that fit certain criteria
COUNTIFS- counts the number of cells that fit multiple criteria
VLOOKUP- finds data in a specified column, based on the information entered
HLOOKUP- finds data in a specified row, based on the information entered
Financial functions- this video covers, in-depth, some of the basic financial functions. While it is a long video, it does have a table of contents in the description so you can jump to the parts that you are interested in learning. It covers functions such as PMT, RATE, CUMIPMT, NPER, and FV.