Using auditing to diagram


show more Using auditing to diagram provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 ...

Using auditing to diagram
Video duration: 6m 3s 6h 21m Beginner

Viewers:

Using auditing to diagram provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...