Description |
1 online resource (xxvii, 953 pages) : illustrations |
Note |
Includes index. |
Contents |
Introduction -- I. Getting started with Excel 2003 -- 1. Getting around Excel -- 2. Spreadsheet basics -- 3. Editing spreadsheets -- II. Formatting and printing Excel worksheets -- 4. Applying number and date formats -- 5. Formatting and printing -- III. Using formulas and functions -- 6. Function fundamentals -- 7. Database functions -- 8. Date and time functions -- 9. Engineering functions -- 10. Financial functions -- 11. Information functions -- 12. Logical functions -- 13. Lookup and reference functions -- 14. Math and trigonometry functions -- 15. Text functions -- 16. Statistical functions -- IV. Using Excel's analysis tool -- 17. Setting up a list or database in Excel -- 18. Using Excel's data-management features -- 19. Outlining, subtotaling, and auditing worksheet data -- V. Creating and modifying charts -- 20. Building charts with Excel -- 21. Modifying Excel charts -- 22. Formatting charts -- 23. Professional charting techniques -- VI. Using Excel in business -- 24. Using PivotTables and PivotCharts -- 25. Using analysis tools : goal seek, solver, and data tables -- 26. Using Excel in business -- 27. Customizing Excel to fit your working style -- VII. Integrating Excel with other applications -- 28. Building presentations with Excel -- 29. Using Excel with Access and other databases -- 30. Retrieving data from OLAP servers -- 31. Recording and editing a macro -- 32. Creating interactive Excel applications with VBA -- VIII. Appendix -- A. What's on the CD. |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
Tableurs. |
|
Business -- Computer programs |
|
Electronic spreadsheets |
Added Title |
Special edition using Microsoft Office Excel 2003 |
Other Form: |
Print version: Blattner, Patrick. Using Microsoft Office Excel 2003. Special ed. Indianapolis, Ind. : Que, ©2004 0789729539 (DLC) 2003103672 (OCoLC)53469444 |
|