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.
SUNY Geneseo Fraser Hall Library Subject Guides


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