Microsoft Office Excel 2007 Data Analysis

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 110 Excel data 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 opened one of your books, and there was a macro to accomplish exactly what I 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