It was a unique feature in Microsoft Excel. Pivot Table is also a very useful tool available in Microsoft Excel, basically it is data mining tool, this tutorial will describe pivot table in detail. Pivot table helps in working on large data and user can dig out the data and can present the that is useful.Microsoft Excel is powerful, full featured tool of Microsoft Office suite. Microsoft Excel is being used every where it may be video library or might be a multinational company. Every department need Microsoft Excel in some way to perform their day to day activities. To be more efficient and to save your precious time you need to have in depth knowledge of this powerful application named Microsoft Excel.
It is not only a spreadsheet, it is programmable spreadsheet. It provides wide range of powerful tools for data manipulation, analysis. It can display the data in large variety of formats. Microsoft Excel provides a powerful programming language that can control all aspect of it.The programming feature of Microsoft Excel offers wide range of benefits like saving a lot of time, reducing errors, maintaining standards, high level of accuracy, integration with other applications.Below mentioned tutorial provides indepth basic knowledge of Microsoft Excel.Pivot table is a very useful tool available in MS-Excel. This can be used to summarize data in tabular format. It can be used to quickly create cross tab view. User can use the data stored in spreadsheet to create pivot table and perform mathematical functions like sum, count, average to summarize data and make it more presentable.