Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and Pivot Tables

This work is essential for those who know basic Excel and want to explore the full potential of the program. It teaches how to manipulate data to suit specific needs and achieve more by doing less work. Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility. It covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver.