Investment Banking Nerd

COUNT :  Counts the number of cells within a range that contains number .  COUNTA :  Counts the number of cells within a range that don't contains number .  COUNTIF :  Count things that satisfy one or more conditions . That is select the range, then write the criteria and we are good to go. COUNTIFS :  Count things that satisfy one or more conditions and criteria . That is select the range, then write the criteria, repeat then again as many times as you want and we are good to go. --------------------------------------------------------------------------------- Learn THE Most important excel tips to be a pro : Click Click !! ------------------------------------------------------------------------------------------- AVERAGE :  Simply having a average of the selected range of a row or coloumn.  AVERAGEIF :  It's a average of numbers which satisfy a certian criteria, select the range, write the criteria and then select the numbers whose range i...

1. How to create dynamic names in Excel? What if I want to write P&L : Company name and when I change the company name the P&L : remains same but th company name changes ? This is required because we use a single model for many companies and situation so rather than manually doing this everytime, why not create a automatic formula.  The formula is ="P&L:"&"cell reference of the company name". 2. What are the Custom formatting means ? 1. Positive Numbers  2. Negative Numbers  3. How to display 0s 4. How to display text  For example : # #; [Red](# #); - So in this what will happen the positive number will be having space in thousands, then the second which we separated by ";" will show in red and brackets with space in thousands, then the third in place of 0 "-" will show and for the last we left it as nothing because we were working on numbers.  3. Creating a Dropdown or List in excel ! Creating a dropdown is easy just go on Data t...

Half Mapped  What's better than understanding the real concepts of Financial Modelling from someone who has actual real time experience. Blog Dedicated to Ritik Prasad , thanks for teaching this.  Concept 1 Can you find out the Repayment amount ?  The first thing I learned is you have to create a system rather than just a working financials which needs to be manually changed by going on different cells. To do that we have to create a system of things here's the Example :  So the Given data as a excercise was that we have a Loan of ₹ 500 and Interest of 10% where we have to repay ₹ 40 per year , as calculated 500/40=12.5, and moratorium is of 2 years.  But we will calculate first without moratorium.  After the 2nd year I have just dragged the formula, if you have question why I have taken 15 yrs ? Because 12.5 yrs was coming as per my calculation above + 2yrs of Moratorium comes 14.5 = ~15.  Now with Moratorium :  Calculation :  I have dragge...