The accountant's guide to advanced Excel / James Fulford

Includes index

Written by an accountant for accountants, this advanced guide is the second in The Accountant's Guide series. The book looks at advanced data analysis techniques and some practical uses for Excel VBA. An extended tutorial, using randomly generated data, gives hands-on experience of how to summarise information, show trends, project into future periods and present the results in a PowerPoint presentation

Accompanying CD-rom

The accompanying CD contains all the spreadsheet models in the book, showing how the finished models are built. The CD also includes 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, analysing and summarising, using the techniques learnt in the book. Practice putting it together in an automated Powerpoint presentation, which will maximise the impact of your message