Excel Data Analysis Your Visual Blueprint For Creating and Analyzing Data, Charts, And Pivottables

Excel Data Analysis 2nd EditionWelcome 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 tipsSimon, Jinjer is the author of 'Excel Data Analysis Your Visual Blueprint For Creating and Analyzing Data, Charts, And Pivottables', published 2005 under ISBN 9780764597800 and ISBN 0764597809.