Skip to Main Content

The Library Collections Move to Milne is Complete! For more information, please visit our blog post.

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.

Regression

This video was produced by economistician.com.

Solver

This video is produced by Peter Duggan.

Creating Named ranges

This video is produced by HowTechOffice. 

Add-ins

This video is produced by FREE LEARNING.

 

Microsoft page about add-ins- this page contains explanations about how to add or remove add-ins