Publisher's Synopsis
Excel Data Analysis 2nd Edition
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
- High–resolution screen shots demonstrate each task
- Succinct explanations walk you through step by step
- Two–page lessons break big topics into bite–sized modules
- "Apply It" and "Extra" sidebars highlight useful tips
