In regard to content and functionality, Jinjer Simon's book is a more than adequate text that takes the reader from the rudimentary to the intermediate/advanced techniques in each of the areas of Excel data analysis that is covered. For the most part, the format is concise and clear. The associat
Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables
โ Scribed by Denise Etheridge
- Publisher
- Wiley
- Year
- 2007
- Tongue
- English
- Leaves
- 306
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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
๐ SIMILAR VOLUMES
<b>Advanced techniques for Excel power users</b><p>Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional
<p><b>Professional-level coverage and techniques for Excel power users</b><p>Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level m
Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functio
* Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations * Now revised with over 30 percent new content to cover the enhancements in Excel 200