Master visually Excel 2007 /
This text covers the basics of using the program, such as navigating in worksheets & workbooks, & understanding how to enter information into a worksheet, as well as intermediate through advanced features, such as using formulas & functions.
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Indianapolis, IN : Chichester :
Wiley Pub. ; John Wiley [distributor],
©2008.
|
Colección: | Master visually.
Visual read less, learn more. |
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- pt. I. Excel Basics
- 1. Getting Started with Excel
- 2. Managing work
- 3. Formatting Cells
- pt. II. Designing Worksheets
- 4. Editing Worksheets
- 5. Proofreading a Worksheet
- 6. Adjusting Worksheets
- 7. Managing Workbook Structure
- 8. Working with Views
- 9. Printing Worksheet Information
- pt. III. Calculating Data
- 10. Performing Basic Math
- 11. Working with Common Formulas
- 12. Mastering Date and Time Formulas
- 13. Working with Financial Formulas
- 14. Working with Lookup Formulas
- 15. Applying Reference, Information, and Text Formulas
- 16. Working with Logical and Error Trapping Formulas
- 17. Analyzing Tabular Information with Functions
- 18. Analyzing Formulas and Worksheets
- pt. IV. Mastering Excel Charts
- 19. Discovering Chart Basics
- 20. Changing Chart Layout Details
- 21. Formatting Charts
- 22. Working with Graphic Elements
- pt. V. Analyzing Data
- 23. Working with Tables
- 24. Summarizing Data with PivotTables and PivotCharts
- 25. Visually Analyzing Data
- 26. Linking and Consolidating Worksheets
- 27. Performing What-If analysis
- 28. Performing Advanced Statistical Analysis
- pt. VI. Customizing the Excel Environment
- 29. Working with Macros
- 30. Changing Excel Behavior
- pt. VII. Using Excel in Collaboration with Others
- 31. Using Workbooks in a Multi-User Environment
- 32. Sharing Excel Data with Other Programs
- Appendix. Excel Functions.