Master visually Excel 2007

Master visually Excel 2007 / by Elaine Marmel.

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.

Saved in:
Bibliographic Details
Main Author: Marmel, Elaine J.
Format: eBook
Language:English
Published: Indianapolis, IN : Chichester : Wiley Pub. ; John Wiley [distributor], ©2008.
Series:Master visually.
Visual read less, learn more.
Subjects:
Microsoft Excel (Computer file)
Electronic spreadsheets.
Business > Computer programs.
COMPUTERS > Desktop Applications > Spreadsheets.
Business > Computer programs
Electronic spreadsheets
Online Access:Click for online access
Table of Contents:
  • 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.

Similar Items