Learn Financial Modelling For Free in 31 Days

DAY 1    INTRODUCTION 

DAY 2    EXCEL PRODUCTIVITY

DAY 3    COLUMN STRUCTURE

DAY 4    FORMULA CONSTRUCTION

DAY 5    ROW TOTALS

DAY 6    FORMULA CONSISTENCY

DAY 7    F11 QUICK CHART

DAY 8    CUSTOMISING THE F11 QUICK CHART

DAY 9   HEADING COLUMNS

DAY 10  INPUTS

DAY 11  FAST FORMAT MACROS

DAY 12  ASSIGNMENT PART 1

DAY 13  ASSIGNMENT PART 2

DAY 14  ERRORS IN FINANCIAL MODELLING

DAY 15  CALCULATION BLOCKS

DAY 16  NAVIGATING USING LINKS

DAY 17  DAISY CHAINS

DAY 18  COPYING LINKS

DAY 19  ASSIGNMENT REVISITED

DAY 20  COPYING CALCULATION BLOCKS

DAY 21  ROW ANCHORING IN CALCULATION BLOCKS

DAY 22  PLACEHOLDERS

DAY 23  LISTING PLACEHOLDERS

DAY 24  TIMING FLAGS

DAY 25  CROSS WORKSHEET LINKS

DAY 26  PASTE LINK

DAY 27  ADVANCED PRODUCTIVITY

DAY 28  ADVANCED PRODUCTIVITY SHORTCUT MACROS

DAY 29  MODELLING BALANCES

DAY 30  TEMPLATE SHEET

IT'S DAY 31 . . . BUT IT'S NOT THE END

Read more ...