Cart
Free Shipping in Australia
Proud to be B-Corp

Excel for Auditors Bill Jelen

Excel for Auditors By Bill Jelen

Excel for Auditors by Bill Jelen


$27.99
Condition - Very Good
5 in stock

Summary

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

Excel for Auditors Summary

Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 by 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.

About 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.

Table of Contents

# 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

Additional information

GOR004719024
9781932802160
1932802169
Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 by Bill Jelen
Used - Very Good
Paperback
Holy Macro! Books
20061001
212
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel for Auditors