117 тысяч подписчиков
950 видео
Comprehensive Creation of Portfolio with Flexible Template and Macros
PDF to Database to Power BI vs Pivot Tables
Practically Apply Copy and Paste and UDF in Models
Part Three of User Defined Functions with Explanation of Multiple Outputs, IDC, Fees and DSRA
Finding Second value with UDF Match
Circular Reference in Simple Model with Iteration and Copy Paste Macros
Sculpting with Multiple Currencies and Multiple Debt Issues
Funding and Circular References in Project Finance Model
Table of contents macro
Table of Contents in Excel (See Generic Macros File)
Read SEC Format to Excel
Basic Goal Seek Macro in Context of WACC and Growth Problem
PDF to Excel and Reading from Word
Solar Resource Analysis Using EU Website
Improved Read PDF with Automated Reset
Sources and Uses in M&A Model
PDF to Excel Contrasting Word with Read PDF
Comprehensive Modelling Exam with Acquistion Price, Sculpting (error in toll rates)
Analysis of Historic Solar Production Data
Short Note on Copying VBA Code
Better Table of Contents in Excel
VBA Stuff in the context of creating more efficient data tables from a single range name definition
VBA Code to Mark and Color Cells with Formulas that are Transferred Outside of the Current Sheet
Making a Print Macro
Basic User Defined Function without Arrays and Loops
Project Finance Model for Interviews from Hell and A-Z Model
Country Risk Premium and Problems with Damodaram
Walk through simple macros through copy and paste
Heavy Model and Accumulation of Monthly to Semi-Annual Using SUM OFFSET versus SUMIF
Improved Read PDF to Excel
Finding External Links
Modelling Philosophy and FAST
Detailed Explanation of Dashboard with reset macro
