Excel Basics 11: Search for Excel Functions & get help with Function Arguments

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB11SearchForFunctions.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class23-ExcelBasics11-SearchForFunctions.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm 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