How to create a dynamic chart in Excel using Dynamic Arrays I've been increasingly interested in how we can use Dynamic Arrays in our models to achieve timeline flexibility. This is especially useful for charts.
Q&A: How to change import and export font colours. Hi, Kenny! First of all, thank you so much for all your resources, this is truly amazing! Now, I am struggling to edit the productivity pack excel - I honestly just want to change the import and export font color, but whatever I change in the file it won'
Productivity pack update Hi there. It's been a little while since I posted here. Life hey. We have been working hard to update the Productivity Pack macros. The latest version (34c) is available here. We are seeing more and more conflicts creeping up when the macros are used with different configurations
Timelines in Project Finance models This is a draft chapter from my forthcoming book - The Project Finance Modelling Handbook. I'm publishing drafts of every chapter online to get as much feedback and input from fellow professionals as possible. My goal is to publish the most useful book on Project Finance Modelling available.
Financial Modelling Handbook now available as an ebook I didn’t intend for the Financial Modelling Handbook to be available digitally. But having just this morning opened my 100th email requesting an ebook version, I changed my mind. I know that for many of you, cost is an issue, and also delivery times vary around the world. So
Introducing the Project Finance Modelling Handbook Friends, Thank you to those of you who have purchased the Financial Modelling Handbook since we published it on Friday. I'm also grateful for the many messages of support and encouragement. Having had such a positive response, I've started working on my next book, the Project
Stages of a Project Finance transaction A project finance model has to behave differently at different stages of a transaction. It's important to set our model up properly for this from the outset.
IT'S OUT! Finally. It's here. Thank you for all your support and encouragement. The handbook is now available to buy. We can ship anywhere in the world. Don't forget to use the code HANDBOOK10 to get 10% off before next Friday. I can't wait to hear
The handbook is out tomorrow! After over a year of writing and receiving reader feedback from many of you, the Financial Modelling Handbook will be available to purchase tomorrow.
Finally - a publication date! We finally have a publication date - the book will be out on September 22nd.