Cargando…

Excel 2007 bible /

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Walkenbach, John
Formato: Documento de Gobierno Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wiley Pub., ©2007.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.