Skip to Main Content
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.
- Codification- available to School of Business students
- Some large accounting firms may post their interpretations of sections of the codification online.
Useful 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
- LEFT and RIGHT and MID- choose part of a string in a cell to put in new cell
- WORKDAY- returns a date a certain number of working days away from a date 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. Other financial functions not covered in this video, such as PV, may also be useful to you.
Research Instruction Librarians