It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
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.