Use Pivot Table with 1 how-to topic, including creating a pivot table; start from the How-to Index and follow the feature path and steps to complete the task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Create a Pivot Table | Free |
How-to Guide
1. Create a Pivot Table
Feature path: Tools → Insert → Pivot Table
- Tap Tools at the bottom.
- Select the Insert tab.
- Tap Pivot Table.
- Select the source data range in the worksheet for pivot table creation.
- Tap Done to enter the field setup screen, then add column fields and row fields.
- Tap Export to finish creating the pivot table.
Success Criteria
- Interface result: You can see the generated pivot table result.
- Next step available: You can continue reviewing the summary result and use it for further analysis.
Tips While Using
- Common mistake: If the selected data range is incomplete, the summary result may be inaccurate.
- Data requirement: It is recommended that the source data has headers for each column and does not contain merged cells.
- Environment note: Some advanced configurations may not be available on mobile, so more complex adjustments can be completed on desktop if needed.