Product Description* Essential for those who know basic Excel and want to explore the full potential of the program
* Teaches how to manipulate data to suit specific needs and achieve more by doing less work
* Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver



From the Back CoverWelcome 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