Excel for Auditors - Bill Jelen, Dwayne K. Dowell

Excel for Auditors

Audit Spreadsheets Using Excel 97 through Excel 2007
Buch | Softcover
212 Seiten
2006
Holy Macro! Books (Verlag)
978-1-932802-16-0 (ISBN)
27,35 inkl. MwSt
  • Titel nicht im Sortiment
  • Artikel merken
"Excel for Auditors: Ensure Your Spreadsheets and Company Databases are Free of Errors and Fraud" deals with computers/software.
Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.

Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.

# Copying a Worksheet # Showing Numbers in Thousands # Quickly Seeing Sum or Average - Better in XL 2007! # Adding Subtotals # Quickly Filling a Series # Using a Fixed Value in Your Formula # Replacing a Thousand Formulas with One # Highlighting Outliers # Using Conditional Formatting in Excel 2007 - Better in XL 2007! # Finding Transactions from the Last Week # Using Icon Sets to Mark Values # Excel Secrets: Applying Icons to Only the Top 10% # Turning Your Data on Its Side with Transpose - Better in XL 2007! # Joining Text # Looking up Data # Dealing with #N/A for Missing Values # When You Know There Is a Match but Excel Cannot Find It # Retrieving Many Columns from the Lookup Range # Getting Good Records from Bad Data # Sorting Your Data - Better in XL 2007 - Sort by Color! # Dealing with Dates # Fiscal Responsibility (Fiscal Years NOT Ending on 12/31) # Analyzing Data with Pivot Tables # Analyzing Results by Date # Creating a Random Sample from a Dataset # Finding and Analyzing Records Using AutoFilter # Formula Auditing # Matching Two Lists # Finding Duplicates or Unique Values - Better in XL 2007! # Finding Missing Dates in Data # Automating Excel with VBA # Conclusion # Index

Erscheint lt. Verlag 1.10.2006
Reihe/Serie Excel for Professionals series
Zusatzinfo Illustrations
Verlagsort Uniontown
Sprache englisch
Maße 203 x 254 mm
Gewicht 371 g
Themenwelt Informatik Office Programme Excel
Wirtschaft Betriebswirtschaft / Management Rechnungswesen / Bilanzen
ISBN-10 1-932802-16-9 / 1932802169
ISBN-13 978-1-932802-16-0 / 9781932802160
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner

von Ignatz Schels

Buch | Softcover (2024)
Markt + Technik (Verlag)
24,95