Category: Excel best practices

  There are few things that a modeler should know before building the financial model. We will try to keep this post as short as possible and most importantly to the point, which will help you to build the model with much more ease. Start with determining the number of tabs or worksheets to be…

  As a Financial Analyst, your key goal, while building a financial model, is to improve its transparency and audibility. Below are some of the Excel best practices while preparing financial models and list of important MS-Excel shortcuts 1. Color Coding: There are no hard and fast rules in assigning color codes to various inputs,…