Product Information
Offers a comprehensive review of all the functionalities of Pivot Tables, making it a single guide to Pivot Tables.; Authors have an experience base that would be difficult to replicate in any other team.; Provides practical scenarios that demonstrate the benefits of Pivot Tables and also explain how to avoid common pitfalls of every day data crunching.; All the best functionalities of Pivot Tables in one guide, creating a tutorial that offers practical solutions to day-to-day problems. In a survey of 5000 Excel users at MrExcel.com, only 42 per cent of users know how to use pivot tables. The Excel project team at Microsoft estimates that only 15 per cent of their survey pool makes use of pivot tables. In reality, probably only a quarter of Excel users can create a basic pivot table, and only a small percentage of that actually harness all power pivot tables afford them. The goal of this book is to consolidate all the best functionality of Pivot tables in one guide that provides basic and intermediate Excel users a meaningful tutorial that will offer some practical solutions to day-to-day problems. Most documentation on Pivot Tables offers examples that show clean environments with data that means nothing to users. Jelen and Alexander provide practical, real-world scenarios that not only demonstrate users the benefits of Pivot Tables, but also explain them how to avoid common pitfalls of every day data crunching. There are a lot of Excel savvy users that want to use the advanced features of Excel, but don't want to dedicate their lives to it. There is a huge segment of the Excel community that are not developers and don't want to be. Because the solutions presented in this book can be accomplished with available resources in the Excel interface, this book is beneficial to beginners, intermediate users, and experts. All the sample data sets will be available for download from www quepublishing.com.Product Identifiers
PublisherPearson Education (Us)
ISBN-139780789734358
eBay Product ID (ePID)86663141
Product Key Features
Number of Pages288 Pages
Publication NamePivot Table Data Crunching
LanguageEnglish
SubjectComputer Science
Publication Year2005
TypeTextbook
AuthorBill Jelen, Michael Alexander
FormatPaperback
Dimensions
Item Height184 mm
Item Weight494 g
Additional Product Features
Country/Region of ManufactureUnited States
Title_AuthorMichael Alexander, Bill Jelen