<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
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
โ Scribed by Jinjer Simon
- Publisher
- Visual
- Year
- 2003
- Tongue
- English
- Leaves
- 308
- Edition
- Bk&CD-Rom
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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 association between text and spreadsheet illustrations is well done. Appendixes A and B in the back are helpful in quick referencing: Excel functions (B) and VBA statements, VBA functions, and Excel Events. The CD does an adequate job of providing some but not all the examples that I would have liked to see. I do appreciate the data analysis software trial tools offered on the CD. Its always nice to be able to kick the tires before purchasing or recommending additional software.
In regard to real world application, I have found Chapters 5: Working with External Data , and Chapter 11: Using the Analysis Tool Packs Add-ins as a good reference guide to small business auditing in Excel. The definitions, concepts and instructions are easy to communicate to the small business user and staff..
๐ SIMILAR VOLUMES
<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
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,
Master two of the most powerful features of ExcelEven if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need mo