The pivot table will automate how to calculate sum, count, average, max, min, standard deviation etc based on data group which are associated to the same data. This make the analysis work / calculation easier and faster to achieve without manually group them. The pivot table also have a filter that allow users to filter the data group which they want to display only.
In order to use the pivot table Ms Excel 2013
1. Select the data you want to analyze including its header
2. Select INSERT>Pivot Table
3. It will prove which data to analyze just click OK since it is already selected
4. Select the field you want to display in pivot table
5. Put numbers in the values section which you want to analyze sum, count, average, max or min
You can also analyze percentage data
How To Excel Spreadsheet Tips and Tricks
Excel | Spread Sheet | Tips and Tricks | Open Office | How To | Tutorials | Beginners | Dummy Guide
Clear cells format in MS EXCEL 2013
Copy and Paste data from format i.e. CSV, HTML, Words, etc carried over the format that you don't want in excel. However that can be solved by removing / clear the formatting of the data in the excel itself. This tip is based on Ms Excel 2013.
All kind of format can be removed: Colors, Font Size, Font Format (italic, bold, superscript, subscript), Font type, etc. Clear all formatting will clear all the format and reset it to default.
1. Select the cells that you want to clear its format. Multiples selection of cells are allowed
2. Go to Home> Clear > Clear Format
You can also clear comments, hyperlink, and contents of the cells
All kind of format can be removed: Colors, Font Size, Font Format (italic, bold, superscript, subscript), Font type, etc. Clear all formatting will clear all the format and reset it to default.
1. Select the cells that you want to clear its format. Multiples selection of cells are allowed
2. Go to Home> Clear > Clear Format
You can also clear comments, hyperlink, and contents of the cells
Subscribe to:
Posts (Atom)