Video:
11 Excel PivotTable TipsVan: Allan Murray - Computergaga
Duur: 10:46
11 Tips m.b.t. draaitabellen.
In Tip 5 en 6 wordt uitgelegd hoe je de opmaak van de draaitabel vast kunt leggen zodat alle andere draaitabellen in hetzelfde bestand dezelfde opmaak krijgen.
In this video, we see 11 Excel PivotTable tips in only 11 minutes. PivotTables are fantastic and there are so many tips beyond their initial use.
These are the timings of the video.
00:00 - Excel PivotTable tips introduction
00:11 - View Fields and Areas side-by-side
00:39 - Show Report Filter results on different pages
01:30 - Stop autofitting columns on update
02:30 - Switch to Tabular Form layout
03:34 - Set default layout settings for your Excel PivotTable
05:02 - Set a default style for the PivotTable
05:25 - Top 5 PivotTable report
06:25 - Clear all PivotTable filters in one click
07:06 - Group number values in a report
08:30 - Remove grand totals
09:08 - Display percentage of previous value
Functies: nvt
