The Accountant's Guide to Advanced Excel

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.