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

How to buy images from picture hosting sites

How to buy images from picture hosting sites

Be it for professional or private use, sometimes your own collection of photographs might not have the image that you require for a project that you are currently working on. whilst there are many millions of images available online, thought has to be taken into consideration before using one these in your work, mainly through potential copyright reasons that may crop up. this article will guide you through buying images from picture hosting sites.
What is data?

What is data?

Data in a general sense is information. they are qualitative or quantitative attributes of a variable or set of variables. typically, data is a series of measurements which can be shown as images, on graphs or observations of a set of variables. as a term, it is nowadays more associated in the popular consciousness with computer science.
A guide to online passport application

A guide to online passport application

This article acts as a guide to the online passport application service in the uk. the main features of the service offered online is discussed here.the current pricing structure and who can use the service are outlined, and the process of logging an application, the time scales for waiting are also noted. the handling of your sensitive data in accordance with the data protection act is mentioned as well.
The top five virtual animal games

The top five virtual animal games

Virtual animal games are very popular amongst children. this article details some of the top virtual animal games that can be found on the internet.