Pivot tables can be hard enough to understand, but using the right tools can help.
If you're working with a pivot table, be sure to display the PivotTable toolbar by selecting View, Toolbars, PivotTable. Initially, Excel will open the toolbar in floating mode, but you can dock it like any other toolbar. This is a great place to start if you want to create a pivot table, since the toolbar includes a tool for launching the PivotTable Wizard.