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, [2006], ©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
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Bill Jelen; Dwayne K Dowell
OCLC Number: 253935353
Notes: Title from title screen.
Includes index.
Description: 1 online resource (vi, 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.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/253935353> # Excel for auditors
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
   library:oclcnum "253935353" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/1428932139#Place/uniontown_ohio> ; # Uniontown, Ohio
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/ohu> ;
   schema:about <http://id.loc.gov/authorities/subjects/sh85018263> ; # Business--Computer programs
   schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
   schema:about <http://experiment.worldcat.org/entity/work/data/1428932139#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
   schema:about <http://id.worldcat.org/fast/821168> ; # Auditing--Computer programs
   schema:about <http://id.worldcat.org/fast/907463> ; # Electronic spreadsheets
   schema:about <http://dewey.info/class/005.54/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/1428932139#Topic/auditing_computer_programs> ; # Auditing--Computer programs
   schema:about <http://id.worldcat.org/fast/842283> ; # Business--Computer programs
   schema:bookFormat schema:EBook ;
   schema:contributor <http://viaf.org/viaf/219025916> ; # Dwayne K. Dowell
   schema:copyrightYear "2007" ;
   schema:creator <http://experiment.worldcat.org/entity/work/data/1428932139#Person/jelen_bill> ; # Bill Jelen
   schema:datePublished "2006" ;
   schema:description "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."@en ;
   schema:description "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."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/1428932139> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:name "Excel for auditors"@en ;
   schema:productID "253935353" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/253935353#PublicationEvent/uniontown_ohio_holy_macro_books_2006_2007> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/1428932139#Agent/holy_macro_books> ; # Holy Macro! Books
   schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=235109> ;
   schema:url <http://ebookcentral.proquest.com/lib/oldscollege/detail.action?docID=349823> ;
   schema:url <http://ebookcentral.proquest.com/lib/northernlakes-ebooks/detail.action?docID=349823> ;
   schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xna&AN=235109> ;
   schema:url <http://ebookcentral.proquest.com/lib/norquest-ebooks/detail.action?docID=349823> ;
   schema:url <http://site.ebrary.com/id/10237070> ;
   schema:url <http://www.books24x7.com/marc.asp?bookid=16073> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/253935353> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/1428932139#Agent/holy_macro_books> # Holy Macro! Books
    a bgn:Agent ;
   schema:name "Holy Macro! Books" ;
    .

<http://experiment.worldcat.org/entity/work/data/1428932139#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.loc.gov/authorities/subjects/sh85018263> # Business--Computer programs
    a schema:Intangible ;
   schema:name "Business--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/821168> # Auditing--Computer programs
    a schema:Intangible ;
   schema:name "Auditing--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/842283> # Business--Computer programs
    a schema:Intangible ;
   schema:name "Business--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/907463> # Electronic spreadsheets
    a schema:Intangible ;
   schema:name "Electronic spreadsheets"@en ;
    .

<http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xna&AN=235109>
   rdfs:comment "from EBSCO Academic Collection" ;
   rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://viaf.org/viaf/219025916> # Dwayne K. Dowell
    a schema:Person ;
   schema:familyName "Dowell" ;
   schema:givenName "Dwayne K." ;
   schema:name "Dwayne K. Dowell" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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