|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
| 9) Now select the New Worksheet option and press the Ok button. |
| |
| 10) A new worksheet with the Pivot table blank design will appear. |
| |
|
| Illustration 5: Blank Pivot table layout. |
| |
| 11) At the right side, you will see the Pivot Table Fields List. |
| |
|
| Illustration 6: Pivot table Fields list. |
| |
| 12) Click on each field that you wants to add to the Pivot Table design or drag and drop the fields to the headers. |
| |
|
| Illustration 7: Drag and drop fields. |
| |
| 13) If you want to see only Table A data, you could set up the filters. |
| |
|
| Illustration 8: Filtering data. |
| |
| 14) To change the Chart type select the chart area, then rigt click and select the Change Chart Type menu item. |
| |
|
| Illustration 9: Data filtered. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
