Check out the full course at knowledgecity.com/en/library/10665/computer/course/excel-2016-advanced/. Calculating the interest rate of a loan can give you valuable information about the loan. This video will show you how easy it is as long as you have the long amount, the term/period of the loan and the monthly payment amount.

Course Lessons

Welcome
Introduction
Overview
Working with Functions
Overview
Using Statistical Functions
Calculating Loan Payments
Calculating Present Value
Calculating Loan Payoff
Calculating Interest Rate
Calculating Principle & Interest
Work with Logical Functions
Work with Text Functions
Work with Ranges
Using Date and Time Functions
Controlling Automatic Calculations
Copying Formula Values
IF, VLOOKUP, and Power Functions
Overview
Testing Conditions with IF
Using IF functions with relational operators
Using the IFS function
Using VLOOKUP
Getting approximate table data with VLOOKUP
Getting exact table data with VLOOKUP
Using INDEX/MATCH functions
Using the COUNTIF family of functions
Data Analysis Tools
Overview
Using Goal Seek
Using Solver
Using Scenario Manager
Using data tables
Data Management Features
Overview
Sorting data
Using filters
Splitting data into multiple columns
Using Flash Fill
Removing duplicate records
Using validation tools
Working with Lists
Overview
Query Data with Database Functions
Outline and Subtotal Data
Pivot Tables
Overview
Creating PivotTables
Manipulating PivotTable data
Grouping by date and time
Grouping by other factors
Using slicers to clarify and manipulate fields
Using PivotCharts
Introduction to Macros
Overview
Understanding and creating Macros
Running and editing a macro
Security and Sharing
Overview
Unlocking cells and protecting worksheets
Protecting workbooks
Assigning passwords to workbooks
Sharing workbooks
Tracking changes
Conclusion

knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance.

Subscribe to our YouTube Channel: youtube.com/user/knowledgeocity?sub_confirmation=1

Check our Blog: goo.gl/q47XKK

Connect with KnowledgeCity!
Twitter: goo.gl/wToC6s
Facebook: goo.gl/3eMEq9
LinkedIn: goo.gl/vg1aXt
Google+: goo.gl/Gjkffm

• Calculating Interest Rate in Excel 2016 | Knowledgecity.com ( Download)
• How to Calculate Loan Payments in Excel 2016 | Knowledgecity.com ( Download)
• How to Use the IF Function in Excel 2016 | Knowledgecity.com ( Download)
• How to Calculate the Interest Rate (=RATE) in MS Excel ( Download)
• Calculating Present Value in Excel 2016 ( Download)
• Excel Tips # Rate of interest calculation @ BSingh ( Download)
• How To Calculate Loan Payments Using The PMT Function In Excel ( Download)
• Calculating Interest In Excel - Simple Interest Calculator Excel ( Download)
• How To Calculate Interest Rate In Excel - How To Calculate Interest Rate In Excel Formula ( Download)
• Calculating Interest Rate for LUMP SUM Amount Using Excel ( Download)
• Microsoft Excel 2016 Advanced | Knowledgecity.com ( Download)
• Excel - Calculating Effective and Nominal Interest Rates using EFFECT and NOMINAL ( Download)
• Easy way to calculate Interest Rate in #excel #excelhacks #viralshorts #tricks #shorts ( Download)
• Calculating Loan Payoff in Excel | Knowledgecity.com ( Download)
• calculate loan payment due date in excel #short #shorts #Excel #exceltips #excelworld ( Download)