Tag Archives: Audit

Data Audit using Pivot tables

I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look:

How to perform Data Audit using Pivot

Raw data can contain many columns and thousands of rows. Checking the consistency and accuracy of data cannot be done by simply scrolling and eyeballing the data. Too time-consuming.

Continue reading Data Audit using Pivot tables

How to use FormulaText function in Excel

FormulaText function in Excel was introduced in version 2013. It requires just one parameter – the cell from which you want to display the formula.  Even if you select a range, it will return the formula in the top left cell.

image

Detailed syntax.

When to use the FormulaText function in Excel

Here are three practical scenarios.

  1. It is very helpful in documenting important formulas.
  2. It can also be used as a part of an audit process.
  3. Trainers can use it to teach formulas more effectively.
  4. I find it useful for creating more readable screenshots while creating learning content for Excel.

Knowledge Pack: Green Marks in Excel

These marks indicate some potential error. Outdated formulas, numbers stored as text and so on. If you ignore these errors, you are at a significant risk of viewing and using wrong data for your decision making. Here is a set of articles which explain exactly how to utilize these green marks to your advantage. These are your best friend.

Never interpret anything in any Excel file unless you are sure that all the green marks are handled (all potential errors are corrected!).

  1. Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
  2. Green Marks Part 2: Formulas showing wrong results!
  3. Green Marks Part 3: More error handling
  4. Green Marks Part 4: Inconsistent Formulas
  5. Green Marks Part 5/5 (Background Error Checking in Excel)

Share this critical information with your boss, colleagues, subordinates and loved ones. Everyone needs to know this!