Next Live Training Date:

8-10 Dec (JHB)

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.

Excel Watch Window

Excel Watch Window
Watch this video

How to use the Excel watch window to see what is happening in key cells as you make changes to your spreadsheet.

  • 2:54
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Excel Watch Window for viewing cells

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

Handy Tips & Tricks

PowerPivot Format Percentage for DAX Measure

PowerPivot Format Percentage for DAX Measure One of the most useful features of the new DAX measures in PowerPivot is the ability to specify a set format for the measure so that every time you use it in a pivot … Continue reading

Excel Quiz Answers 26 Nov 2014

Excel Quiz Answers Answers for the quiz on our 26th Nov 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions from the Newsletter What is the easiest way to set up a range so that it … Continue reading

Practical examples of how the various tools & functions can be used in different contexts make it quite easy to grasp the concepts and see the benefits of using these functions. The course is very practical and allows you to engage with the various exercises, make mistakes and learn....

– Corporate financial modelling in excel Feedback

Video Library & Tutorials //

View Entire Video Gallery ››

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients