Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables

Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables

by Simon, Jinger Simon
     
 

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key Excel data analysis techniques, including:

  • Creating PivotTables and PivotCharts
  • Importing and linking data
  • Compiling data from various sources
…  See more details below

Overview

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key Excel data analysis techniques, including:

  • Creating PivotTables and PivotCharts
  • Importing and linking data
  • Compiling data from various sources
  • Filtering a list
  • Creating an amortization table
  • Manipulating data within a chart
  • Editing external database tables
  • Using an Excel function in a macro
  • Building PivotTable formulas
  • Using Analysis ToolPak Add-ins

Data analysis tools on CD-ROM!

  • Trial versions of FinOptions XL, Analyse-It, Sigma XL, 4TOPS Data Analysis, and XLSTAT Pro
  • UNISTAT demo version
  • Macro codes
  • A searchable e-version of the book

Product Details

ISBN-13:
9780764537547
Publisher:
Wiley, John & Sons, Incorporated
Publication date:
03/03/2003
Series:
Visual Read Less, Learn More Ser.
Edition description:
Book and CD-ROM
Pages:
304
Product dimensions:
8.00(w) x 9.12(h) x 0.83(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >