Brilliant Microsoft Excel 2007 Pivot Tables

Description

Table of Contents

Introduction

1. Pivot Table Fundamentals
2. Creating a Basic Pivot Table
3. Customising 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. Analysing 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

Index

Back Cover

Brilliant Excel 2007 Pivot Tables

What you need to know and how to do it

Excel is one of the most powerful office and business productivity tools available – but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Excel skills that you need to produce solutions to all of your business needs/ Brilliant Excel 2007 Pivot Tables will deliver increased office productivity and improved results by unleashing your inner Excel expert! This book is for the savvy Excel user who wants to understand and then use the advanced features of Excel but doesn’t want to dedicate their life to it.

Develop your Excel 2007 expertise instantly with proven techniques

Pivot tables are the most powerful feature in Excel 2007. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. You can make changes to your data analysis in seconds by dragging a few fields around the pivot table field list. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them.

Thisbook consolidates all the best functionality of pivot tables into one guide that that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours. By Chapter 6, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability, or to compare sales by period, product or region in a few mouse clicks, and without knowing any formulas. 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.

Brilliant Excel 2007 Pivot Tables will show you how to ….

·         Create powerful summary reports in seconds

·         Build ad-hoc query tools with ease

·         Enhance your Executive Reporting

·         Filter reports to top 10 customers or products

·         Add dynamic charts to reports

·         Quickly summarize daily data by month, quarter, or year.

Bill Jelen is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and 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 and his daily video podcast is regularly in the top tech podcasts in iTunes.

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently heads an analytical services group for a $700-million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares Access and Excel tips with intermediate users.

Visit us on the web at

www.pearson-books.com

Author

Paul McFedriesis well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).