Discover how to detect fraud, biases, or errors in your data using Access or Excel
With over 300 images, Forensic Analytics reviews and shows how twenty substantive and rigorous tests can be used to detect fraud, errors, estimates, or biases in your data. For each test, the original data is shown with the steps needed to get to the final result. The tests range from high-level data overviews to assess the reasonableness of data, to highly focused tests that give small samples of highly suspicious transactions. These tests are relevant to your organization, whether small or large, for profit, nonprofit, or government-related.
Demonstrates how to use Access, Excel, and PowerPoint in a forensic setting
Explores use of statistical techniques such as Benford's Law, descriptive statistics, correlation, and time-series analysis to detect fraud and errors
Discusses the detection of financial statement fraud using various statistical approaches
Explains how to score locations, agents, customers, or employees for fraud risk
Shows you how to become the data analytics expert in your organization
Forensic Analytics shows how you can use Microsoft Access and Excel as your primary data interrogation tools to find exceptional, irregular, and anomalous records.
Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.
MARK J. NIGRINI, PHD, is an Associate Professor at The College of New Jersey, where he teaches auditing and forensic accounting. His current research addresses forensic and continuous monitoring techniques and advanced theoretical work on Benford's Law. Dr. Nigrini has published his Benford's Law and forensic accounting research in academic journals and in professional accounting and auditing publications. He has been interviewed on radio and television and his work has been discussed in publications including the Wall Street Journal and the New York Times.
Discover how to detect fraud, biases, or errors in your data using Access or Excel
Every fraud or error changes your data in some way or another. The challenge is to find those needles in the haystack. Forensic Analytics shows how you can use Microsoft Access and Excel as your primary interrogation tools to find exceptional, irregular, and anomalous transactions.
Forensic Analytics reveals how you can:
With over 300 images, Forensic Analytics reviews and shows how twenty tests can be used to detect fraud, errors, or biases in your data. For each test, the original data is shown together with the steps needed to get to the final result. The tests range from thorough overviews to assess the reasonableness of data, to highly focused tests that give small samples of highly suspicious transactions. Some tests incorporate time and changes over time while other tests look for irregular patterns, excessively large amounts, or excessive duplications. The tests are relevant to any kind or size organization, whether small or large, nonprofit, or government-related.
FORENSIC ANALYTICS
Methods and Techniques for Forensic Accounting Investigations
Forensic analytics is the use of electronic data to reconstruct or detect financial fraud. The process of forensic analytics is made up of data collection and preparation, data analysis, and the preparation of a fraud report and the possible presentation of the results.
In Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations, author Mark Nigrini reviews the use of Microsoft Access and Excel in a forensic setting, together with many rigorous analytical procedures to detect employee fraud, biases, and other irregularities including errors. The book includes a comprehensive chapter on financial statement fraud, and the concluding chapter on credit/debit purchasing card fraud shows an authentic dashboard used by a Fortune 100 company.
Nigrini devotes three chapters to a review of the use of Access, Excel, and PowerPoint in a forensic setting. The next eleven chapters discuss data interrogation tests that could be used in a forensic setting to detect employee fraud, biases, and errors. In each chapter, the tests are discussed in general terms and are then demonstrated using case studies with real data. In addition, the steps needed to run the tests are illustrated with screenshots from Access and Excel. Two chapters review, with examples, a risk-scoring technique that can be used to score divisions, agents, or locations for fraud risk.
A full chapter presents various tests, along with real-world examples and case studies, to detect financial statement fraud. The concluding chapter is a case study showing an analysis of purchasing card data using selected tests from the prior chapters, and a presentation of the findings.
The companion website (www.nigrini.com/ForensicAnalytics.htm) has all the data tables used in the book, available for download. Along with notes and updates related to the book, the website also includes end-of-chapter problems and assignments for use by instructors, together with PowerPoint slides for presentations.
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.
Anbieter: HPB-Red, Dallas, TX, USA
Hardcover. Zustand: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Bestandsnummer des Verkäufers S_421201867
Anzahl: 1 verfügbar
Anbieter: Greenworld Books, Arlington, TX, USA
Zustand: good. Fast Free Shipping â" Good condition book with a firm cover and clean, readable pages. Shows normal use, including some light wear or limited notes highlighting, yet remains a dependable copy overall. Supplemental items like CDs or access codes may not be included. Bestandsnummer des Verkäufers GWV.0470890460.G
Anzahl: 1 verfügbar
Anbieter: One Planet Books, Columbia, MO, USA
hardcover. Zustand: Good. 1st Edition. Ships in a BOX from Central Missouri! May not include working access code. Will not include dust jacket. Has used sticker(s) and some writing and/or highlighting. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Bestandsnummer des Verkäufers 001147456U
Anzahl: 7 verfügbar
Anbieter: Better World Books, Mishawaka, IN, USA
Zustand: Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects. Bestandsnummer des Verkäufers 16450932-6
Anzahl: 1 verfügbar
Anbieter: Goodbooks Company, Springdale, AR, USA
Zustand: acceptable. This copy may contain significant wear, including bending, heavy writing, tears, and or water damage. This book is a functional copy, not necessarily a beautiful copy. Copy may have loose pages. May not include access codes or CDs. May be an Ex library book with stickers and stamps. Dustjacket may be missing. Bestandsnummer des Verkäufers GBV.0470890460.A
Anzahl: 1 verfügbar
Anbieter: BookHolders, Towson, MD, USA
Zustand: Very Good. [ No Hassle 30 Day Returns ][ Ships Daily ] [ Underlining/Highlighting: NONE ] [ Writing: NONE ] [ Edition: first ] Publisher: Wiley Pub Date: 6/7/2011 Binding: Hardcover Pages: 480 first edition. Bestandsnummer des Verkäufers 6954716
Anzahl: 1 verfügbar
Anbieter: Textbooks_Source, Columbia, MO, USA
hardcover. Zustand: Good. 1st Edition. Ships same day or next business day! UPS shipping available (Priority Mail for AK/HI/APO/PO Boxes). Used sticker and some writing and/or highlighting. Used books may not include working access code. Used books will not include dust jackets. Bestandsnummer des Verkäufers 001147456U
Anzahl: 8 verfügbar
Anbieter: GreatBookPrices, Columbia, MD, USA
Zustand: good. May show signs of wear, highlighting, writing, and previous use. This item may be a former library book with typical markings. No guarantee on products that contain supplements Your satisfaction is 100% guaranteed. Twenty-five year bookseller with shipments to over fifty million happy customers. Bestandsnummer des Verkäufers 9093978-5
Anzahl: 2 verfügbar
Anbieter: J. Wyatt Books, Ottawa, ON, Kanada
Hardcover. Zustand: Fine. Zustand des Schutzumschlags: Near Fine. 463 pages in excellent condition. Blue hardcovers with gilt spine titles. Corners not bumped. Blue, illustrated DJ with yellow titles. Very light wear. FINE/NEAR FINE. Book. Bestandsnummer des Verkäufers 216243
Anzahl: 1 verfügbar
Anbieter: Toscana Books, AUSTIN, TX, USA
Hardcover. Zustand: new. Excellent Condition.Excels in customer satisfaction, prompt replies, and quality checks. Bestandsnummer des Verkäufers Scanned0470890460
Anzahl: 1 verfügbar