Formula Auditing in Excel: two ways in which you can use it for checking formulas in your worksheets

This week’s hint and tip is on Formula Auditing in Excel. This section is covered briefly in our Intermediate Excel course. ItFormula Auditing: Excel icon​ isn’t covered in a lot of detail as it is a smaller section on our course. There are several features in this area but we’re focussing on just two in this hint and tip. These are:

  1. Watch Windows
  2. Trace Precedents

In the video below you will see how they both work. Excel is such a sophisticated package that sometimes a little help is required in order to understand what is going on. This is especially true if someone else has constructed a formula on a sheet and you need help to understand it.

 

Watch Windows

Firstly we will look at watch windows. Watch windows enable you to keep an eye on the value of a cell in a spreadsheet when you change a cell in an entirely different place on the workbook. This can be especially useful if you have very large workbooks with lots of rows of data in it.

 

Trace Precedents

Secondly we will look at race precedents. Trace Precedents allows you to see which cell precedents are used in the making up of a formula cell. Again, this works across worksheets and even across workbooks if they are open.

 

Both of these are covered in our Excel training courses which we run in Worcestershire, Herefordshire, across the Midlands and throughout the UK.

The video below shows you how to use these two options in the Formula Auditing part in Excel. It also shows how they can be beneficial for you in your day to day work.

Watch the video below to find out more and then try it out on your own computer!

We hope you have enjoyed this hint and tip, why not take a look at our previous one on Inserting Pictures in Publisher?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy