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.
