The fourth part of audit training
The fourth part of audit training:
The fourth part of audit training. In this part, you will get to know the sources related to Benford’s Law in Accounting Monthly, Benford’s Law formulas in Excel, and an introduction to textual functions.
Sources related to Benford’s Law in Accounting Monthly:
Various articles have been published in the accounting monthly about the interface between Benford’s law and auditing.
On the website of this magazine, an article called Numerology for Accountants dated November 1998 has been presented, which discusses Benford’s Law and the issue of auditing.
Those interested can view the full version of this article by referring to the email address below.
http://www.journalofaccountancy.com/issues/1998/nov/audit
Figure number 9
Other articles related to Benford’s law and the subject of auditing have been presented on the website of this magazine, which are listed below along with the e-mail address of each one.
- Convert Excel to a financial auditor at:
http://www.journalofaccountancy.com/2003/aug/turnExcellntoAfinancial
Figure number 10
http://www.jounalofaccountancy.com/Issues/1999/may/nigrini/html
Figure number 11
- Show the high power of your financial inspection:
http://www.Journalofaccountancy.com/Issues/2007/Jun/FlexingYourSuperFinanciaISIeuthPower
Figure number 12
http://www.journalofaccountancy.com/Issues/2002/Apr/RootOutFinancialDeception
Figure number 13
Formulas of Benford’s law in Excel
The topic discussed in this section is how to use Excel software to analyze numerical data based on Benford’s law.
Calculating Benford’s law is a multi-step process that, at the beginning, it is a multi-step process that at the beginning of this process, a full understanding of the two key functions (Left) and countif () must be obtained.
In the following, each of these two functions as well as the formulas and capabilities related to them are described in detail.
Text functions
There are several functions in Excel software that are identified and classified as text functions.
Text functions are used to enter text in the desired cells.
Although the application and use of text functions to explore numerical values seems unreasonable at first, we will find out the use of these functions for the intended purposes.
Although it is enough to know the Left() function to use Benford’s law, other useful text functions are also discussed (as follows) during the description of this text function:
- Left()
- Right()
- Mid()
- Len()