Office 2016 23

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

DESCRIPTION

Topics in this video:
(00:01) Introduction
(01:19) Search for Excel Functions with Function Library
(03:05) Insert Function Dialog Box, Search for Excel Functions with Insert Function button or with Keyboard: Shift F3
(03:46) PMT Function for Loan Payment
(04:00) Function Argument dialog box
(04:54) Formulas to calculate Month Interest rate, Total Periods and Loan Amount
(11:29) Excel’s Golden Rule for analyzing Different Loans
(13:29) MEDIAN to Calculate Median
(16:15) Summary – Conclusion

NOTES

WORKBOOKS

Download “Office 2016 Video 23” EB11SearchForFunctions.xlsm – Downloaded 11 times – 793 KB







Be the first to comment

Leave a Reply