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