Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: http://ift.tt/2z7DmPp
Download Full Written Notes: http://ift.tt/2hqSqy5
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:19) Search for Excel Functions with Function Library
3. (03:05) Insert Function Dialog Box, Search for Excel Functions with Insert Function button or with Keyboard: Shift F3
4. (03:46) PMT Function for Loan Payment
5. (04:00) Function Argument dialog box
6. (04:54) Formulas to calculate Month Interest rate, Total Periods and Loan Amount
7. (11:29) Excel’s Golden Rule for analyzing Different Loans
8. (13:29) MEDIAN to Calculate Median
9. (16:15) Summary – Conclusion
Alternative Title:
Excel Basics 10: PMT Function for Loan Payment & MEDIAN to Calculate Median
Excel Basics 10: Insert Function Dialog Box to Search for Functions & get help with Function Arguments