Accountant's Guide to Advanced Excel

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.Fulford, James is the author of 'Accountant's Guide to Advanced Excel' with ISBN 9781860761638 and ISBN 1860761631.