Download or read book Microsoft Office Excel 2007 Data Analysis written by Denise Etheridge and published by John Wiley & Sons. This book was released on 2011-06-17 with total page 308 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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