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

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 11: Search for Excel Functions & get help with Function Arguments

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

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

Full Transcript

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