1. Excel Basics -- 2. Entering Information -- 3. Working with Files -- 4. Manipulating Data -- 5. Structuring Worksheets -- 6. Printing -- 7. Managing Data -- 8. Using Formulas -- 9. Worksheet Functions -- 10. Advanced Work with Formulas -- 11. Charting Data -- 12. Drawing Objects -- 13. Pivot Tables -- 14. Goal Seek and Solver: Reaching Solutions with Brute Force -- 15. Acquiring Data -- 16. Sharing Workbooks -- 17. Using Web Technology -- 18. Repeating Tasks Automatically -- 19. The Visual Basic Editor and the Excel Object Model -- 20. Writing Subroutines -- 21. Writing Functions -- 22. Controlling Input with User Forms -- 23. Techniques for Handling VBA Arrays -- 24. Using Data Access Objects -- App. A. Excel Functions -- App. B. MOUS Core Certification
Summary
Guide to using the latest edition of the popular Excel spreadsheet program for Office XP from tips on using basic features to easy to understand explanations of advanced functions. By inputting or importing data, analyses for financial, statistical, engineering, or, other professional functions can be made