The Accountant's Guide to Advanced Excel,

Description

The book looks at advanced data analysis techniques and some practical uses for Excel VBA. An extended tutorial, using randomly generated sales data, gives a hands-on tutorial on summarizing information, showing trends, and projecting into future periods.

The CD contains all of the spreadsheets in the book, and a Random Data Generator model, which can generate up to 65,000 sales transactions, setting individual growth factors and prices for each of the product lines, and then charting and summarizing, using the techniques learned in the book.