Microsoft Office Excel 2007 Data Analysis

Welcome to the only guidebook series that takes a visual approachto professional-level computer topics. Open the book and you'lldiscover step-by-step screen shots that demonstrate over 110 Exceldata analysis techniques, including:

* Identifying trends in your data * Sorting, filtering, and identifying lists * Creating, editing, and checking formulas * Calculating interest rates and depreciation * Performing simple sorts and filters * Hiding rows or columns in a PivotTable * Adding and removing chart data * Querying an Access database * Assigning digital signatures * Solving a formula with a data table
„I was stuck on an Excel problem for two days. Finally, I openedone of your books, and there was a macro to accomplish exactly whatI needed! You made me look good to the boss.“ -Rob L. Meerscheidt(The Woodlands, TX)
* 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