skip to content
Excel for auditors Preview this item
ClosePreview this item
Checking...

Excel for auditors

Author: Bill Jelen; Dwayne K Dowell
Publisher: Uniontown, Ohio : Holy Macro Books, ©2007.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
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.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; 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
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.