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.
Sprache
Verlagsort
Verlagsgruppe
Bloomsbury Publishing PLC
Zielgruppe
Maße
Höhe: 246 mm
Breite: 189 mm
Dicke: 20 mm
ISBN-13
978-1-86076-163-8 (9781860761638)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
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.
