Tag Archives: Audit

Green Marks Part 5/5 (Background Error Checking in Excel)

Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity.
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
Green Marks Part 2: Formulas showing wrong results!
Green Marks Part 3: More error handling and Green Marks Part 4: Inconsistent Formulas

In this article, we cover the remaining three types of errors: Unprotected Formula, Formula refers to empty cells and Data Validation Error.

image

Continue reading Green Marks Part 5/5 (Background Error Checking in Excel)

Green Marks Part 4: Inconsistent Formulas

Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity.
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
Green Marks Part 2: Formulas showing wrong results!
Green Marks Part 3: More error handling

In this article, we will cover two more potential errors related to Inconsistent Formulas.

How to handle inconsistent formulas in Excel - Dr. Nitin Paranjape

Continue reading Green Marks Part 4: Inconsistent Formulas

Green Marks Part 3: More error handling

This is a continuation of the series on error handling – green marks. We will see how to handle Excel formula errors and two Text related (non-formula) errors in this article.

Please read these two articles before reading this article to maintain continuity.
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!Green Marks Part 2: Formulas showing wrong results!

Green marks in Excel - more error handling by Dr. Nitin Paranjape

Continue reading Green Marks Part 3: More error handling

Auditors, Risk Managers: Inquire- The ultimate Spreadsheet Comparison tool in Excel 2013

This is the third article in this series. Please read these articles as well:
Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool
Spreadsheet Analysis using Inquire – Relationship Diagrams

Spreadsheet Risk is very important for everyone – from a single user to a large organization. Because an interpretation mistake or a wrong value can be very costly indeed.

In this article we will see how to compare two spreadsheets. Using the old method and the new amazing tool which comes with Office 2013.

Inquire - Best spreadsheet comparison tool

Continue reading Auditors, Risk Managers: Inquire- The ultimate Spreadsheet Comparison tool in Excel 2013

Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool

These two roles require extensive work with complex workbooks. Auditors need to understand and validate large, complex workbooks in a time bound manner. Risk managers work with complex models with large data sets. They want to implement Spreadsheet Controls in place to reduce the operational risk originating from spreadsheet errors. In either case, you need to understand, validate and troubleshoot spreadsheets in a time bound manner.

In this article, I am not going to cover the regular features of native Excel which include GoTo Special, Trace Precedents, Watch Window, Evaluate Formulas and so on.

Since Office 2013, Microsoft introduced a new add-in called Inquire tool– which is very powerful. But still many people do not know about it. We will explore this tool in this article.

Inquire tool

Continue reading Auditors, Risk Managers: Excel spreadsheet analysis using the new Inquire tool