Download Excel File: https://excelisfun.net/files/20-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/20-M365ExcelClass.pdf
Learn how to build a Bank CD worksheet schedule to show monthly interest and final CD Value. Learn about the financial concepts behind CD value, and the more general investment future value. Learn about the math that makes compound interest so powerful. See two solutions: worksheet formula model and dynamic spilled array formula model.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:31) Worksheet Model and Excel’s Golden Rule
3. (01:44) Build Interest Schedule for CD Investment
4. (08:11) Look at Math Behind Compound Interest
5. (12:15) Calculate Future Value with single formula
6. (13:08) Calculate Effective Rate
7. (14:57) Create Dynamic Spilled Array Formula CD Interest Schedule. SEQUENCE and DROP Array Functions and other spilled formulas
8. (17:39) Video Summary and Conclusions
9. (17:59) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/
#finance #futurevalue #cds #sequence #dynamicarrays #drop #model #models #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp