Description |
1 online resource (vi, b, 212 pages) : illustrations |
Physical Medium |
polychrome |
Description |
text file |
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. |
Note |
Includes index. |
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. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Auditing -- Handbooks, manuals, etc.
|
|
Auditing. |
Genre/Form |
Electronic books.
|
|
Handbooks and manuals.
|
|
Electronic books -- Handbooks, manuals, etc.
|
|
Handbooks and manuals.
|
Added Author |
Dowell, Dwayne K.
|
Other Form: |
Print version: Jelen, Bill. Excel for auditors. Uniontown, Ohio : Holy Macro Books, ©2007 1932802169 (DLC) 2006931383 (OCoLC)74496187 |
ISBN |
9781932802634 (electronic book) |
|
1932802630 (electronic book) |
|
9781615473113 (electronic book) |
|
1615473114 (electronic book) |
|
1932802169 |
|
9781932802160 |
|