Excel for auditors
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
eBook, English, [2006], ©2007
Holy Macro! Books, Uniontown, Ohio, [2006], ©2007
1 online resource (vi, 212 pages) : illustrations
253935353
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
Title from title screen
Includes index