Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

Описание к видео Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

Download Excel Start File https://people.highline.edu/mgirvin/Y...

Download file: https://people.highline.edu/mgirvin/E...
1. See how to quickly create many student summary report using a Pivot Table and the Show Report Filter Pages feature
Steps
1. Proper data set with Field Names in first row
2. Keyboard to create PT on new sheet: Alt, N, V, T, Enter
3. Drag field that will determine each sheet to the Report Filter area
4. Drag criteria fields to Row Label area
5. Drag field to make calculations upon to the Values area
6. Format report: Design Tab, Layout Group, Report Layout, Show in Tabular Form
7. Create sheets for Report Filter: PivotTable Options ribbon tab, PivotTable group, Options button, Show Report Filter Pages, OK

Комментарии

Информация по комментариям в разработке

Похожие видео