Learn what resources you can use to build your skills and improve your cash flow analysis using Microsoft Excel.
- [Instructor] Thanks again for working through this course with me. I hope you've gotten a lot out of it. And before I let you go, I wanted to direct you to a number of other courses that you can use to further your learning in this area. One very good course is Excel 2016: Financial Functions in Depth. I used a number of financial functions in this course. If you want a more comprehensive overview of what's available, then that is the course for you. Waterfall charts are very useful for visualizing your data, but there are quite a few other chart types that you can use.
In that case, I recommend the course Excel 2016: Charts in Depth. And finally, if you're working with data in tables and want to analyze it using either pivot tables or pivot charts, then I highly recommend Excel 2016: Pivot Tables in Depth. In my opinion, pivot tables are one of the most useful features in Microsoft Excel. And when you combine pivot tables with pivot charts which allow you to manipulate your visualizations as you go, you get a terrific set of tools that are included in the program.
Once again, thank you for working through the course, and I wish you the best of luck.
- Calculating the effect of interest rates and inflation
- Finding the arithmetic and geometric means of growth rates
- Calculating the future and present value of an investment
- Calculating loan payments for a fully amortized loan
- Calculating the effect of paying extra principal with each payment
- Finding the number of periods required to meet an investment goal
- Calculating net present value and internal rate of return
- Building a cash tracking worksheet
- Visualizing cash flows using a waterfall chart