Video Lesson: Formula Auditing & Evaluation

Formula Auditing and Formula Evaluation are powerful components in Excel, and today’s video lesson goes over the following uses of the Formula Auditing features:

Show Formulas:  How to change view to show formulas instead of cell results.

Formula Evaluation:  See how Excel views the formula as you walk your way through the calculations.

Trace Precedents / Trace Dependents:  Helps finding out where your data is coming from and/or going to.

Watch Window:  Allows for user to set certain cells into a window that can be viewed as you switched sheets.

Make sure to download the most recent Master Workbook to follow along.

This entry was posted in Workbook/Reference Lessons and tagged , , , , , , , , , . Bookmark the permalink.

5 Responses to Video Lesson: Formula Auditing & Evaluation

  1. Rahul Modi says:

    Dear Sir,
    First of all very thankful for such a wonderful video and your guide. I have one query generally i take multiple data from multiple sheet. When i check whether i take all the relevant data i used F2 show fromula and not down the cell no of different sheet from which i take date. Please suggest me excel tool so it can highlight all the cell of different sheet so i am able to see which cells has taken from the different sheet.

  2. RAVI says:

    BECAUSE SINCE LONG LONG TIME I AM SEARCHING FOR A MASTER AND THERE IS AN END.
    WITH THE EXCEL LIKE HOW OR WHAT ABOUT DATABASE WITH THE COMBINATION OF EXCEL AND ACCESS OR VBA BECAUSE I AM NOT TOO GOOD AT PROGRAMMING. HELP ME BEN SIR.

  3. RAVI says:

    HI BEN FIRST ALL I WOULD LIKE TO KNOW WHAT ARE THE COURSE DURATION OF TYPES OF COURSES YOU OFFER BECAUSE I WANT TO ESTABLISH MY SELF AS A MIS EXECUTIVE WHICH I AM NOT I AM WITHIN THE PROCESS I NEED INFO WITH THE FEE OF COURSES OR AFTER COMPLETING THE COURSE DO YOU GIVE ANY CERTIFICATE AS WELL OR ANY EXAMINATION SO THAT I CAN ACCESS MY SELF

  4. Chris Marsh says:

    Very useful videos, I love how concise they are!

    Please keep up the good work.

    PS found you via reddit 🙂

  5. Anonymous says:

    Awesome! thank you

Comments are closed.