Warenkorb
Kostenloser Versand
Unsere Operationen sind klimaneutral

Excel for Auditors Bill Jelen

Excel for Auditors von Bill Jelen

Excel for Auditors Bill Jelen


€10,49
Zustand - Sehr Gut
5 auf Lager

Zusammenfassung

Excel for Auditors: Ensure Your Spreadsheets and Company Databases are Free of Errors and Fraud deals with computers/software.

Excel for Auditors Zusammenfassung

Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 Bill Jelen

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.

Über Bill Jelen

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.

Inhaltsverzeichnis

# 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

Zusätzliche Informationen

GOR004719024
9781932802160
1932802169
Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 Bill Jelen
Gebraucht - Sehr Gut
Broschiert
Holy Macro! Books
20061001
212
N/A
Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.