The Accountant's Guide to Advanced Excel

James Fulford (Autor)

Media-Kombination

356 Seiten

2000
Thomson Learning
978-1-86076-163-8 (ISBN)

Infos

Written by an accountant for accountants, this advanced guide to Excel is the second in The Accountant's Guide series. The book looks at advanced data analysis techniques and some practical uses for Excel VBA. the accompanying CD-ROM contains all of the spreadsheet models in the book, demonstrating how the finished models are built. Comprehensive and easy to use, this book will improve your ability to handle large volumes of data easily, and enhance the professionalism of your presentation of this information to senior management and clients.

Inhalt

1. Starting Point. 2. Auditing Spreadsheets. 3. Desk Checking Spreadsheets. 4. Programming. 5. Excel Visual Basic Applications Edition (I). 6. Excel Visual Basic Applications Edition (II). 7. Random Data Generator. 8. Data to Information. 9. Excel Data to Excel Information. 10. More Pivot Tables. 11. Data Tables. 12. Solver. 13. Scenarios. 14. Charting. 15. Charting and Maps. 16. Forecasting and Analysis. 17. PowerPoint Presentations. 18. The PowerPoint Menus. 19. The PowerPoint Report Structure. 20. Working with the PowerPoint Report. 21. Initial Meetings. 22. Spreadsheet Outline. 23. Historical Data. 24. Presenting the Historical Data (I). 25. Presenting the Historical Data (II). 26. Presenting the Historical Data (III). 27. The VBA Control Center. 28. Coding the VBA Control Center. 29. Sales and Production Forecasting. 30. Sales and Production Meetings. 31. The 'What If' Model (I). 32. The 'What If' Model (II). 33. The 'What If' Model (III). 34. Loading from PowerPoint. 35. Consolidations. 36. Consolidated Accounts. 37. Summary.

Produkt-Details

• Erscheint lt. Verlag: 15.6.2000
• Verlagsort: London
• Sprache: englisch
• Maße: 189 x 246 mm
• Themenwelt: Informatik ► Office Programme ► Excel
• ISBN-10: 1-86076-163-1 / 1860761631
• ISBN-13: 978-1-86076-163-8 / 9781860761638
• Zustand: Neuware