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 – which is very powerful. But still many people do not know about it. We will explore this tool in this article.