From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using auditing to diagram

Using auditing to diagram - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Using auditing to diagram

“

After a while, you might find you're spending a lot of your time in Excel not creating worksheets but auditing sheets that have already been created. So I want to show you tools that Excel has to help you along. Well, if you take a look at this worksheet here, we have a couple of groups of products and we have a total for the first group and average for the first group, you might need to scroll down, and we have total and average for the second group and then grand total and grand average for this. And what's happening is you have your data, one cell is feeding into another one. So like January is feeding into here and feeding it to there and then it's also feeding down here on the bottom. This is what auditing is going to help us with. So, let's go into the Formulas tab and you see over here we have the Formula Auditing section. There's some terminology that you need to know first is precedents and dependents and a dependent is a formula that a cell feeds into and a precedent is data…

Contents