Содержание
Course Overview 1m 45s Course Overview 1m 45sCreating Your First PivotTable 26m 56s Introduction to PivotTables 6m 51s PivotTable Examples 6m 54s When to Use PivotTables vs. Standard Excel Tables 2m 28s PivotTables with Multiple Sources 1m 0s Demo: Creating Your First PivotTable 5m 4s Demo: Creating a PivotTable from Multiple Sources 4m 37sModifying PivotTable Formatting 18m 27s Introduction to PivotTable Formatting 1m 16s Demo: Adding Fields to the PivotTable 3m 2s Demo: Modifying the Design 6m 55s Demo: Formatting PivotTables 5m 26sFormatting Summary 1m 46s Choosing How PivotTable Values Are Presented and Displayed 13m 34s Introduction 1m 6s Demo: Summarization Options 3m 36s Demo: Calculation Options 4m 48s Demo: Sorting PivotTables 3m 14s Summary 48sCreating New PivotTable Values 10m 14s Creating New Values Using Calculated Fields 3m 38s Creating New Values Using DAX 5m 34s Summary 1m 0sAdding Grouping, Slicing, and Filtering Interactivity 25m 28s Introduction to Grouping, Filtering, and Slicing 1m 46s Demo: Grouping Fields 2m 44s Demo: Grouping Dates 5m 54s Filters and Slicers 3m 9s Demo: Filters 2m 53s Demo: Slicers 6m 54s Summary 2m 5sExploring Other Excel Capabilities 4m 38s Exploring Other Excel Capabilities 4m 38s