 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
|
|||
Pivot Table Data Crunching for Microsoft Office Excel 2007
"Summarize 900,000 rows of data in seconds!"The functionality behind pivot tables was actually invented by folks at the Lotus Advanced Technology Group in the late 1980's. Originally available only for Steve Job's NeXT computer, the technology became widely available in 1992 with the release of Improv. During Microsoft's bitter battle with Lotus for spreadsheet supremacy, the concept was added to Excel's data menu. Not many people understand how to actually make use of pivot tables. As a data analyst in 1992, Bill Jelen quickly discovered the power behind pivot tables. "It was possible to create summary reports before Pivot Tables, but you had to build complicated DSUM formulas and weave them into an obscure feature called / Data Table 2. It would take an hour and make your head spin. If I ever tried to explain the process to a spreadsheet novice, their eyes would glaze over. It was something that was simply impossible to learn. Once Pivot Tables were added to Excel, anyone who can drag a mouse can create stunning summary reports in seconds. "If you can drag a mouse, you can create a basic pivot table"Imagine that you have 900,000 rows of transactional data like this: 
Your department VP asks for a summary table showing sales by product and region. Without a pivot table, you are going to be learning CSE formulas or using the conditional sum wizard in combination with Data - Filter - Advanced Filter. But, with a pivot table, you can convert the 900,000 rows of data to this summary report with four mouse clicks and three mouse drags.
Once you have a pivot table, then one additional mouse drag allows you to transform the report to show detail by customer or any other field.
Both of the above summary reports were created in seconds instead of hours.
Click here to order the book! Includes proven and creative Pivot Table recipes for fast results on the job!As if Pivot Tables were not powerful enough, you can also use them to create Top 10 reports, or charts for each region, or tables showing year over year growth. Learn how to use Pivot Tables with Access or OLAP data. See how to use VBA to automate the creation of charts for each product or customer. This book will allow you to stop wasting time with obscure methods (I have to read Aladin's post every time that I try to use SUMPRODUCT...). This book will enable you to do analyses that were previously time-prohibitive. Become the Excel superstar in your office with just a few clicks of the mouse. Provides practical, real-world scenarios that not only demonstrate the benefits of Pivot Tables, but also explains how to avoid pitfalls of every day data crunching.Excel PivotTables help you summarize huge amounts of data practically instantly, and analyze it almost as quickly. If PivotTables haven't come naturally to you, you're not alone. Pivot Table Data Crunching for Excel 2007 will help you finally master this powerful tool -- and it will transform the way you use Excel.By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks. About the Authors Mike Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently lives in Frisco, Texas, where he works as a senior program manager for a top technology firm. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users. Bill Jelen is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com. He honed his pivot table wizardry during a 12-year tenure as a financial analyst for a fast growing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on “Call For Help” on TechTV Canada. 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.Click here to order the book! "Learn how to do things you never dreamt were possible."Table of Contents Introduction. 1. Pivot Table Fundamentals. 2. Creating a Basic Pivot Table. 3. Customizing a Pivot Table. 4. Controlling the Way You View Your Pivot Data. 5. Performing Calculations Within Your Pivot Tables. 6. Using Pivot Charts and Other Visualizations. 7. Analyzing Disparate Data Sources with Pivot Tables. 8. Sharing Pivot Tables with Others. 9. Working with and Analyzing OLAP Data. 10. Enhancing Your Pivot Table Reports with Macros. 11. Using VBA to Create Pivot Tables. 12. Common Pivot Table Issues and Questions A. Finding Pivot Table Commands on the Ribbon. Click here to order the book! "If you want to save hours per day in Microsoft Excel --- You Need This Book!"Product Details Paperback: 360 Pages ; Dimensions (in inches): 9 x 7 x 0.7 Publisher: QUE; ISBN 9780789736017 (December 2006) Price: $34.99 "Downloadable Sample Files"See the top of page 9 for a link to all of the sample files in the book. Order Click here to order the book!
|
