The No1 Ethical retailer for Books, CD’s, DVD’s & Games
30 Day Refund Guarantee

Pivot Table Data Crunching

Pivot Table Data Crunching

by Michael Alexander (Author), Bill Jelen (Author)

  • Used

    Paperback 2005

    $3.25
Synopsis

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

$3.25

Save:$29.39 (90%)

Quantity

1 in stock

More Information

Format: Paperback
 Pages: 288
 Edition: 1
 Publisher: QUE
Published: 21 Jun 2005
ISBN 10: 0789734354
ISBN 13: 9780789734358
Book Overview: In a survey of 5000 Excel users at MrExcel.com, only 42% of users know how to use pivot tables. The Excel project team at Microsoft estimates that only 15% 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.

Media Reviews

Excel users may already be aware of the power of pivot tables, which allow summarization of 50,000 rows of data with one click of the mouse - but many user's guides don't begin to touch upon its powerful features. PIVOT TABLE DATA CRUNCHING provides a tutorial which promises users and prior Excel fans the ability to get up to speed quickly, using real-world examples such as how to highlight productivity channels and produce meaningful reports. An excellent business guide.

--California Bookwatch, 10/1/06

Author Bio
Bill Jelen is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 12 million page views annually. Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and VB.Net. He currently lives in Plano, TX where heads an analytical services department for a $700 million company, and has written numerous articles at the www.DataPigTechnologies.com website.