Not yet registered? Create a OverBlog!

Create my blog

An introduction to Excel pivot tables

Do you need to analyse a huge amount of data and run a comprehensive report based on that? The best way to address this is by building an Excel pivot table that you can further use to display, re-arrange and filter your complex data conveniently. This article summarises a few Excel 2007 guidelines that will help you with that.

Pivot tables: The basics

To create a pivot table in Excel, you have to connect to a data source and set the location of your report. Make sure that your data doesn't include any empty rows and that the columns have descriptive headings. First, click on a cell somewhere inside the data, then go to 'Insert tab' and in the 'Tables group'. Click the 'PivotTable' button. At this point, Excel selects all the data into your pivot. It tells you where it is selected and it asks you where to put the table. The best option is to choose 'New Worksheet'. However, if you decide to place your table in the 'Existing Worksheet,' specify the first cell in the range of cells where you want to position your pivot table. Initially, a pivot table is empty. Excel creates a place holder box and displays the pivot table field list on the right side of your screen so that you can add fields, create a layout and customise your pivot table report.

The ways in which to work with a pivot table

The pivot table will help you query a large amount of data in a user-friendly way. You can create subtotals and summarise data by categories and subcategories and insert formulas as well as custom calculations. You can "pivot" the data by moving rows to columns and columns to rows to see different summaries of your source data from different angles. You have the possibility to filter, sort, group or conditionally format the most important subset of data that you need to analyse. You can further explore your data by expanding and collapsing it and show the underlying details that are relevant to the values. In order to produce the most concise and attractive reports, you can change the form layout (compact, outline or tabular) and field arrangement. You can establish the way in which empty cells or errors are shown and you can choose to display or hide blank lines. For further details, have a look at the 'Microsoft Office Excel Help'.

Same category articles Digital & online

RewardTV: The facts

Rewardtv: the facts

Rewardtv is a website that awards you prizes for answering questions about your favourite tv shows. you can also enter sweepstakes to win prizes like a holiday in las vegas or a monetary prize that you can specify for a purpose such as paying your rent. if you are interested in learning facts about rewardtv and its prizes, read on the following article.
How to format windows XP

How to format windows xp

Windows xp is one of the older operating systems that are still making its presence felt. lots of individuals are still not aware of how to format windows xp in a proper manner. with this article, you will get a clear understanding of how to format windows xp. read on!
All about: Blogthings.com

All about: blogthings.com

Everyday there seems to be a different quiz popping up on facebook or various blogging sites across the internet. a lot of these quizzes originate from this site blogthings.com. this article will look at the different aspects of the site and how they can be used to make your blog better or more popular with people.
Good PC Games.co.uk: Review and rate

Good pc games.co.uk: review and rate

The pc gaming scene is as active as ever, with a vast array of titles available for your machine. many websites act as a guide to the top pc games. among these is goodpcgames.co.uk. read on for the verdict on this site.