video
Professional Financial Functions
Simon Sez IT
Updated Jul 13, 2025
What you'll learn
- Calculate monthly payments using PMT function.
- Calculate principal payments using PPMT function.
- Calculate interest payments using IPMT function.
- Apply financial functions to asset depreciation.
- Familiarize with specialized financial functions.
Course DescriptionThis video is part of the Introduction to Financial & Statistical Functions in Excel course and is aimed at individuals who want to learn advanced financial functions in Excel 2019. The instructor demonstrates how to split payments on a loan between principal and interest repayments using the PMT, PPMT, and IPMT functions. The video also covers the use of financial functions in asset depreciation and encourages viewers to familiarize themselves with the list of financial functions available in Excel.
