Excel 2007 data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables / by Denise Etheridge.

Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.

Saved in:
Bibliographic Details
Main Author: Etheridge, Denise
Format: eBook
Language:English
Published: Hoboken, N.J. : Wiley, 2007.
Series:Visual read less, learn more.
Subjects:
Online Access:Click for online access
Table of Contents:
  • Ch. 1. Getting started
  • Ch. 2. Creating formulas
  • Ch. 3. Creating and using functions
  • Ch. 4. Using financial functions
  • Ch. 5. Using statistical functions and tools
  • Ch. 6. Organizing worksheet data
  • Ch. 7. Working with pivottables
  • Ch. 8. Charting data
  • Ch. 9. Working with external data
  • Ch. 10. Useful data analysis tools and techniques
  • Ch. 11. Sharing your workbook with others
  • Ch. 12. Automating with macros
  • App. A. Excel keyboard shortcuts
  • App. B. Excel function quick reference
  • App. C. Formula basics.