--- title: Excel for Finance description: Excel for Finance focuses on using spreadsheet software to build financial models and analyze data. You will master formulas, financial functions, shortcuts, and data visualization techniques essential for corporate finance and investment analysis. category: finance-economics subcategory: corporate-finance difficulty: beginner, intermediate, advanced url: /subject/excel-for-finance --- # Excel for Finance Excel for Finance focuses on using spreadsheet software to build financial models and analyze data. You will master formulas, financial functions, shortcuts, and data visualization techniques essential for corporate finance and investment analysis. ## Available Resources 2 Videos • 2 Books • 4 Websites ## Websites ### 1. Simtools – Free Monte Carlo Simulation Add-in for Excel **Author:** Roger Myerson, University of Chicago Free Monte Carlo simulation and statistical functions Excel add-in created by Nobel laureate Roger Myerson at the University of Chicago Booth School of Business. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://home.uchicago.edu/rmyerson/addins.htm **Tags:** monte-carlo, excel, simulation, risk-analysis, add-in ### 2. A Simple Model – Free LBO Modeling Tutorials **Author:** A Simple Model Arguably the best free LBO tutorial series, with unedited walkthroughs and downloadable Excel files. Highly practical for learning LBO modeling from scratch. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://www.asimplemodel.com **Tags:** lbo, financial-modeling, excel, private-equity, valuation ### 3. Chandoo.org: Master Excel for Financial Applications A highly respected website offering extensive free tutorials, tips, and articles on advanced Excel techniques, charting, data analysis, and VBA, crucial for building robust financial models and dashboards. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://chandoo.org/ **Tags:** excel, dashboards, vba, data-analysis, charting ### 4. Edwardbodmer.com **Author:** Edward Bodmer An unmatched free ecosystem in structured finance education, hosting dozens of downloadable Excel models for project finance and corporate finance, with embedded YouTube video walkthroughs. Features User-Defined Function (UDF) approach to resolving circular references. The site is active and regularly updated as of early 2026, with models covering solar, wind, thermal, hydro, toll roads, ports, airports, hotels, mining, oil, agriculture, PPPs, and manufacturing. **Difficulty:** Advanced | **Language:** English | **Price:** Free **Link:** https://edbodmer.com **Tags:** project-finance, excel-models, financial-modeling, circular-references, free-templates ## Videos ### 1. Corporate Finance Institute (CFI) YouTube Channel: Excel for Finance Tutorials Official YouTube channel offering numerous free video tutorials, tips, and walk-throughs on using Excel for financial analysis, modeling, and various finance functions, from a leading financial training institution. **Difficulty:** Beginner | **Language:** English | **Price:** Free **Link:** https://www.youtube.com/@corporatefinanceinstitute **Tags:** excel, financial-analysis, financial-modeling, corporate-finance, tutorials ### 2. Edward Bodmer's YouTube Channel **Author:** Edward Bodmer Hosts hundreds of long-form screen recordings of Excel model-building with narration, covering complete models. The production quality is deliberately unprofessional, focusing on direct knowledge sharing. **Difficulty:** Advanced | **Language:** English | **Price:** Free **Link:** https://www.youtube.com/@EdwardBodmer **Tags:** excel-modeling, project-finance, financial-modeling, debt-sculpting, screencasts ## Books ### 1. Corporate and Project Finance Modeling **Author:** Edward Bodmer An Excel modeling manual covering debt sculpting, DSCR-driven sizing, cash flow waterfalls, Monte Carlo simulation without add-ins, and custom spreadsheet functions that resolve circular references without VBA macros. This is the 1st edition, published in 2014 and is 624 pages. Considered to unlock Bodmer's extensive free online ecosystem. **Difficulty:** Advanced | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/1118854365?tag=edmonddante07-20 **Tags:** project-finance, excel-modeling, debt-sculpting, monte-carlo, user-defined-functions ### 2. Financial Analysis and Modeling Using Excel and VBA **Author:** Chandan Sengupta An 800-page Wiley guide that reviews the underlying finance theory, then develops models in Excel and automates them with VBA across time value, bond pricing, portfolio, and simulation problems. Suited to readers wanting programming control over spreadsheets. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/047027560X?tag=edmonddante07-20 **Tags:** financial-modeling, excel, vba, bond-pricing, portfolio-optimization --- *This content is part of Dantes.io - Your Treasure Map to Knowledge* *Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).* View this page online: https://dantes.io/subject/excel-for-finance