Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2z7DmPp
\nDownload Full Written Notes: http:\/\/ift.tt\/2hqSqy5
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (01:19) Search for Excel Functions with Function Library
\n3. (03:05) Insert Function Dialog Box, Search for Excel Functions with Insert Function button or with Keyboard: Shift F3
\n4. (03:46) PMT Function for Loan Payment
\n5. (04:00) Function Argument dialog box
\n6. (04:54) Formulas to calculate Month Interest rate, Total Periods and Loan Amount
\n7. (11:29) Excel\u2019s Golden Rule for analyzing Different Loans
\n8. (13:29) MEDIAN to Calculate Median
\n9. (16:15) Summary – Conclusion
\nAlternative Title:
\nExcel Basics 10: PMT Function for Loan Payment & MEDIAN to Calculate Median
\nExcel Basics 10: Insert Function Dialog Box to Search for Functions & get help with Function Arguments<\/p>\n