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/Y...
Download Full Written Notes: https://people.highline.edu/mgirvin/Y...
Class web page link: https://people.highline.edu/mgirvin/A...
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

• #education
• #highline_college
• #busn_216
• #mike_girvin
• #michael_girvin
• #excelisfun
• #excel_basics
• #learn_excel
• #excel
• #excel_2016
• #learn_excel_for_free
• #learn_excel_online
• #complete_lesson_in_excel
• #basic_excel
• #pmt_function_for_loan_payment
• #median_to_calculate_median
• #search_for_excel_functions
• #get_help_with_function_arguments
• #insert_function_dialog_box
• #function_argument_dialog_box