7 Days of Financial Modelling – Day 5

Welcome back to 7 Days of Financial Modelling! (Day 5)

An important principle to follow in Financial Modelling is to have Consistent Formulas in a block of data.

Learning how to use absolute referencing (eg. =$A$1) will help you to achieve this, and I’ll show you exactly step by step how to do this today!

Unable to watch the above video.  Watch it here on YouTube.

Download the Excel file used in the video

Dummies Book coverIn 2022, wrote the book “Financial Modeling in Excel for Dummies“.  All Dummies books include cheat sheets which summarise important themes or content from the book into a single place. The cheat sheet is publicly available on the Dummies site, and you can access it here.

A copy of this book is included when you purchase the “Financial Modelling Bundle (with books)” which you can start straight away.
PS – don’t forget your $50 voucher code when you sign up!  It’s PLUM_5E12.