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 is a section which is briefly covered in our Intermediate Excel course but 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 want help to understand it.

 

Watch Windows

Watch windows basically enable you to keep an eye on the value of a cell elsewhere 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

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 and how they can be beneficial for you in your day to day work.

Take a look below at the video 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 some previous ones too?

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