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
Books about Add-ons
The Basics of Financial Modeling by Publication Date: 2015
Applied Statistics for Business and Management Using Microsoft Excel by Publication Date: 2013
Beginning Excel What-if Data Analysis Tools by Publication Date: 2006
Excel 2013 for Business Statistics by Publication Date: 2014
