Panier
Livraison gratuite
Nous sommes Neutres au Carbone

Excel for Auditors Bill Jelen

Excel for Auditors par Bill Jelen

Excel for Auditors Bill Jelen


€27.00
État - Très bon état
5 en stock

Résumé

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

Excel for Auditors Résumé

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.

À propos de 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.

Sommaire

# 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

Informations supplémentaires

GOR004719024
9781932802160
1932802169
Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 Bill Jelen
Occasion - Très bon état
Broché
Holy Macro! Books
20061001
212
N/A
La photo du livre est présentée à titre d'illustration uniquement. La reliure, la couverture ou l'édition réelle peuvent varier.
Il s'agit d'un livre d'occasion - par conséquent, il a été lu par quelqu'un d'autre et il présente des signes d'usure et d'utilisation antérieure. Dans l'ensemble, nous nous attendons à ce qu'il soit en très bon état, mais si vous n'êtes pas entièrement satisfait, veuillez prendre contact avec nous.