Special edition using Microsoft Office Excel 2007 /

Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will the...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Que, 2006.
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Tableurs > Logiciels.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Introducing the ribbon user interface
  • 2. quick access toolbar
  • 3. mini toolbar and other U.I. improvements
  • 4. Keyboard shortcuts
  • 5. Galleries, live preview, and themes
  • 6. Excel options dialog
  • 7. big grid
  • 8. Fabulous table intelligence
  • 9. Visualizing data in Excel
  • 10. Using pivot tables to analyze data
  • 11. Formatting pivot tables
  • 12. Pivot table data crunching for Excel 2007
  • 13. Removing duplicates and filtering
  • 14. Sorting data
  • 15. Using Excel charts
  • 16. Using SmartArt, shapes, WorldArt, and text boxes
  • 17. Using pictures and clip art
  • 18. File format differences
  • 19. Working with prior versions of Excel
  • 20. Understanding formulas
  • 21. Controlling formulas
  • 22. Understanding functions
  • 23. Using everyday functions : math, data and time, and text functions
  • 24. Using powerful functions : logical, lookup, and database functions
  • 25. Using financial functions
  • 26. Using statistical functions
  • 27. Using trig, matrix, and engineering functions
  • 28. Connecting worksheets, workbooks, and external data
  • 29. Using super formulas in Excel
  • 30. Using names in Excel
  • 31. Using what if, scenario manager, goal seek, and solver
  • 32. Formatting worksheets
  • 33. Printing
  • 34. Sharing workbooks with others
  • 35. More tips and tricks for Excel 2007
  • 36. Automating repetitive functions using VBA macros
  • 37. Interacting with other office applications
  • 38. tour of the best add-ins for Excel.

Ejemplares similares