Data Analysis with Excel 📈📉📊✅ - IRR with Data Tables - Excel Financial Analysis Lesson

4.0 (1)

11 learners

What you'll learn

This course includes

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

Summary

Keywords

chandoo chandoo.org Excel spreadsheets IRR explanations XIRR in Excel two way data tables in excel how to model IRR scenarios financial analysis IRR IRR and data tables XIRR and data tables XIRR scenarios

Full Transcript

#FinancialAnalysis #IRR #DataTables #Scenarios Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this video is for you. Learn how to, * Introduction to IRR & XIRR functions * Calculate rate of return from a set of cash-flows with XIRR * Simulating purchase or terminal value changes with data tables * Apply conditional formatting to visualize the outputs * Common issues and challenges faced when using XIRR Example Workbook and More Details: ============================== https://chandoo.org/wp/using-irr-with-data-tables/ Recommended Course =================== https://chandoo.org/wp/resources/50-ways-to-analyze-data/

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome