College Being

Not sure why this is so funny but we can’t stop laughing:

View Comments

Pivot tables are used in Microsoft Excel for easy compilation and analysis of large volumes of data. A pivot table summarizes the list of information into a simplified format arranging the rows and columns as per the requirement of the user and also provides options for easy rearrangement. These tables are considered one of the most powerful features of Microsoft Excel. The pivot tables can be used for easy data analysis in the academic as well as the professional world. This article lists 10 things you should know about Pivot tables and their application.

1. They can be quickly created

A pivot table can be created in Microsoft Excel within a minute. The manual creation of reports has been often a lengthy process and learning the application of pivot tables can simplify this process and make it much faster. The simple steps for creation of a table are given here:

1. Select any cell in the source data

2. On the Insert tab of the ribbon, click the PivotTable button

3. In the Create PivotTable dialog box, check the data and click OK

4. Drag a “label” field into the Row Labels area (e.g. Organization)

5. Drag a numeric field into the Values area (e.g. Units sold)

2. ‘Perfect’ data

The pivot tables make use of only perfect source data so that no blank rows or columns are included in it. The repeated groups of data are not included during data analysis and tool ensures that each row and column has a unique name and every field has a unique value which minimizes the chances of error in calculation or doubling of information. Click to continue reading…

View Comments

This may be an innovative new way to market a company. Very NSFW:

View Comments