For better financial modelling in 2018, here is your Top 10 New Year’s Resolution list ready to print and pin up by your desk.
- I will keep my formulae short and sweet to bring happiness to my friends, family and model users
- I will never use the Border, Font colour or Fill buttons in Excel and instead consistently use pre-defined functional design Excel Styles
- I will press ALT to ‘Snap to Grid’ and make the world a more orderly place
- I will on one every calculation line include Row Description, Unit, Row Summary and Calculation (copied from left to right)
- I will not create excessive Worksheets which annoy typical model users
- I won’t use VBA for calculations, until I have exhausted every other way of solving the issue
- I will sell my Mac and buy a PC and get those Excel Shortcuts flying
- I will advocate within my organisation the adoption of one methodology for financial modelling and Excel development
- I will not remove Grid Lines in Calculation Worksheets
- I will use a Custom Date Format where the Month is in letters (“JAN”), to avoid confusion with international users
From all of us at Mazars & Corality Academy, to all of you, we wish you a transparent, flexible and well-presented year of financial modelling.
Did we miss anything…?