Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!
How to use the Excel watch window to see what is happening in key cells as you make changes to your spreadsheet.
In this example we have a spreadsheet that has been built over two sheets. One sheet containing the inputs, and another sheet containing some calculations and the results. And on this sheet we have two cells which are very important to us, being this cell the IRR cell and this cell which is the Net Present Value cell.
We’d like to see what happens to these cells when changes are made to the input cells, but its always a bit tedious to jump between the sheet. So what you can use is the Excel WATCH WINDOW
So for example it tells you
Now when we go back to the input sheet you’ll see
If you want to add more cells to the WATCH WINDOW it’s simply a case of
If you want a name to appear here that describes the cell you’re looking at, it’s simply a case of naming the cells. So for example
It makes it a lot easier to understand what values we are looking at
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
As per our financial modelling course we highly recommend that negative numbers are clearly shown as such and we prefer brackets around a negative number and that the negative numbers are in red. There are several options to achieve this … Continue reading
One of the most common formatting requests is how to get Excel negative numbers in brackets (and red) instead of just a negative sign (-) in front of the number. The actual issue is not an Excel issue but rather at … Continue reading
...The course was so useful I learned a couple of tricks to aid me with my own work as well....They were able to ask a few specific questions...– Procter & Gamble