Excel 2007 bible
Annotation
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Indianapolis, Ind.
Wiley Pub.
2007
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Includes bibliographical references and index
- Ch. 1. Introducing Excel
- Ch. 2. What's new in Excel 2007?
- Ch. 3. Entering and editing worksheet data
- Ch. 4. Essential worksheet operations
- Ch. 5. Working with cells and ranges
- Ch. 6. Introducing tables
- Ch. 7. Worksheet formatting
- Ch. 8. Understanding Excel's files
- Ch. 9. Using and creating templates
- Ch. 10. Printing your work
- Ch. 11. Introducing formulas and functions
- Ch. 12. Creating formulas that manipulate text
- Ch. 13. Working with dates and times
- Ch. 14. Creating formulas that count and sum
- Ch. 15. Creating formulas that look up values
- Ch. 16. Creating formulas for financial applications
- Ch. 17. Introducing array formulas
- Ch. 18. Performing magic with array formulas
- Ch. 19. Getting started making charts
- Ch. 20. Learning advanced charting
- Ch. 21. Visualizing data using conditional formatting
- Ch. 22. Enhancing your work with pictures and drawings
- Ch. 23. Customizing the quick access toolbar
- Ch. 24. Using custom number formats
- Ch. 25. Using data validation
- Ch. 26. Creating and using worksheet outlines
- Ch. 27. Linking and consolidating worksheets
- Ch. 28. Excel and the Internet
- Ch. 29. Sharing data with other applications
- Ch. 30. Using Excel in a workgroup
- Ch. 31. Protecting your work
- Ch. 32. Making your worksheets error-free
- Ch. 33. Using Microsoft query with external database files
- Ch. 34. Introducing pivot tables
- Ch. 35. Analyzing data with pivot tables
- Ch. 36. Performing spreadsheet what-if analysis
- Ch. 37. Analyzing data using goal seek and solver
- Ch. 38. Analyzing data with the analysis ToolPak
- Ch. 39. Introducing Visual Basic for applications
- Ch. 40. Creating custom worksheet functions
- Ch. 41. Creating UserForms
- Ch. 42. Using UserForm controls in a worksheet
- Ch. 43. Working with Excel events
- Ch. 44. VBA examples
- Ch. 45. Creating custom Excel add-ins