Pivot tables are designed to help users crunch and analyse large amounts of data. Today we will learn                       a very useful feature in Excel pivot tables, which is adding calculated fields. Calculated fields can be used when we need to create some custom fields which was not there in the base data. In this tutorial we will see how to insert a calculated field in Excel 2007, modifying or deleting it and what are the benefits and drawbacks in using the calculated fields.

(more…)

Tags: Pivot table

Consolidating multiple ranges using Pivot table is a very useful function in Excel which will help to consolidating values from different sheets. This is an alternative to consolidating data using Sum product explained in the previous posts. Data consolidation is possible in Excel using data Consolidation function, consolidating multiple ranges using Pivot tables and using 3D functions.

(more…)

Tags: Pivot table

Pivot tables are the most powerful tool in Excel. This tutorial is intended to give a complete guide to Pivot Tables in Excel 2007. Shown are the major titles below which i will be covering. Many of the links shown below are inactive currently . But sooner I will be linking them with relevant posts.  Also this will be interactive and will be updated considering the feedback from the users. I don’t have in mind any priority list for updating the below content. This is not exhaustive list and will be adding to this at a later stage. You can bookmark the site , which will help as a quick referencer for Pivot Table help.

(more…)

Tags: Pivot table

In this session we will see how to create a Pivot Table in Excel 2007. Hope you have already gone through the earlier post on Introduction to the Excel pivot Tables.

(more…)

Tags: Pivot table

This is a continuation of series of posts explaining A to Z of Excel Pivot table.  Here in this post we will try to understand the various parts of a Pivot Table. We will see the same example of the Quarter sales of the Toy company. Hope you have already read the introduction to the pivot tables.

(more…)

Tags: Pivot table