Excel Data Analysis - Your Visual Blueprint for creating and analyzing data, charts, and PivotTables

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

• 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

Contents

• How to Use this Book
• Getting Started with Excel
• Organize Worksheet Data
• Evaluate Worksheet Data
• Creating Formulas
• Working with External Data
• Charting Data
• Working with Pivottable Reports
• Creating Pivotcharts
• Automating Actions with Macros
• Form Controls
• Using the Analysis Toolpack Add-Ins