Not sure which of these videos to watch? Try out our 'Which Excel Formula to Use' App to get guidance. NOTE: All these free Excel video tutorials are streamed via YouTube. If your network does not allow YouTube videos, you can access the video via your smartphone or from a different network.
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
Excel not equal sign If you are using certain formula you may require the Excel not equal sign. In maths the symbol is an equal sign crossed out (≠) but this is not available in Excel. So for example you are … Continue reading
[h]:mm for Powerpivot A useful custom format capability in Excel is the [h]:mm:ss which allows you to see how many hours in total have elapsed between two dates by showing hours bigger than 24 (most time formats automatically change back … Continue reading
...A key feature was their ability to understand the problem first time and work on the correct solution. These timely responses enabled us to make decisions quickly...– Rental investment spreadsheets- JHC