Custom formats

Of course Excel contains a range of standard cell formats that can be helpful in financial modelling. But there are other formats you often want to use in a model, and these are not part of Excel’s standard build.

Excel custom formats

Here are examples of four custom formats that may prove helpful in your financial modelling – none of which are part of Excel’s default settings. To apply these all you need to do is download the Excel custom formats spreadsheet and copy and paste the formatting into your own modelling.

Image showing how to apply custom number formatting in Excel

Editing and creating your own Excel custom formats in a financial model

If you want to edit or change the custom formats, download the custom formats spreadsheet and click on an Excel cell that contains the formatting you are interested in. On the “Home” tab, under “Number” click on the little down arrow at the bottom right-hand side – or use the “Ctrl” “1” keyboard shortcut to bring up the format cells dialog box. In the dialog box, you have “Custom” at the bottom of the list on the left-hand side. You can select the format you want and alter it by making careful changes to the existing custom formats.

Next in the Excel financial modelling course extract

In the next lesson we look at lookup functions such as Excel’s Index. These formulas, like Vlookup, can help us get data into the right place in a financial model.

About this online financial modelling course material

You’re looking at a free online financial modelling course extract covering Excel functions.



...join the conversation...

Your email address will not be published. Required fields are marked *