Find a copy online
Find a copy in the library
Finding libraries that hold this item...
Details
Genre/Form: | Electronic books Handbooks and manuals Handbooks, manuals, etc |
---|---|
Additional Physical Format: | Print version: Jelen, Bill. Excel for auditors. Uniontown, Ohio : Holy Macro Books, ©2007 (DLC) 2006931383 (OCoLC)74496187 |
Material Type: | Document, Internet resource |
Document Type: | Internet Resource, Computer File |
All Authors / Contributors: |
Bill Jelen; Dwayne K Dowell |
ISBN: | 9781932802634 1932802630 9781615473113 1615473114 |
OCLC Number: | 729252845 |
Description: | 1 online resource (vi, b, 212 pages) : illustrations |
Contents: | Copying a worksheet -- Showing numbers in thousands -- Quickly seeing sum or average -- Adding subtotals -- Quickly filling a series -- Using a fixed value in your formula -- Replacing a thousand formulas with one -- Highlighting outliers -- Turning your data on its side with transpose -- Joining text -- Looking up data -- Sorting your data -- Dealing with dates -- 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 -- Finding missing dates in data -- Automating Excel with VBA -- Conclusion -- Index. |
Responsibility: | by Bill Jelen and Dwayne K. Dowell. |
Abstract:
Find audit red flags using techniques in Microsoft Excel. From pivot tables to formula auditing, learn the essential Excel skills for analyzing mounds of data. Learn important concepts as well as tips to make your use of Excel far more efficient. Covers Excel 97-2003 and shows off the new features in Excel 2007.
Reviews
User-contributed reviews
Add a review and share your thoughts with other readers.
Be the first.
Add a review and share your thoughts with other readers.
Be the first.


Tags
Add tags for "Excel for auditors".
Be the first.