Excel 365 (2019) Pivot Tables

Introduction

Excel 2019 Pivot Tables Tutorial

Download the exercise zip file

• Start 0:00
• Introduction 0:03
• Data Mining 2:40
• Adding Related Data Using VLOOKUP 13:35
• Inserting Pivot Tables 26:23
• Setting Up Pivot Tables 30:51
• Building Pivot Tables 36:56
• Filtering and Slicing Pivot Table Data 42:21
• Changing Source Data and Refreshing Pivot Tables 48:23
• Inserting Pivot Charts 55:17
• Using Tables to Build Pivot Tables 59:28
• Finding Correct Layouts for Reports 1:05:37
• Setting Default Layouts for Reports 1:11:03
• Using Pivot Table Styles 1:14:25
• Subtotals and Grand Totals 1:18:03
• Creating Report Pages 1:20:31
• Adding the Power Pivot Tab to Excel 1:27:13
• Creating Tables for the Data Model 1:30:36
• Adding Relationships with Power Pivot 1:34:32
• Using DAX Expressions with Power Pivot 1:40:18
• Creating Pivot Tables with Power Pivot 1:42:21
• When to Use Power Pivot 1:46:03
• Conclusion 1:47:33

Please ensure that you have the sound enabled on your Computer.