Excel 2019 Pivot Tables Tutorial
Excel 2019 Pivot Tables Tutorial
Exercise Files: https://bit.ly/3wn3xLT
For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining
Join our online community! - https://www.offsitebylearnit.com
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
#Excel
Видео Excel 2019 Pivot Tables Tutorial канала Learnit Training
Exercise Files: https://bit.ly/3wn3xLT
For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining
Join our online community! - https://www.offsitebylearnit.com
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
#Excel
Видео Excel 2019 Pivot Tables Tutorial канала Learnit Training
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel 2016 IntermediateExcel PivotTables Made Easy - And Why Things Go Wrong!Data Analysis with ExcelExcel 2016 AdvancedExcel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Excel 2019 Expert TutorialExcel 2019 Power User50 Ultimate Excel Tips and Tricks for 2020Excel VBA Beginner TutorialPivot Table Excel TutorialTop 10 Most Important Excel Formulas - Made Easy!Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash CourseHow to build Interactive Excel DashboardsPower BI Beginner TutorialExcel 2016 - Demystifying Pivot TablesExcel Power User Beginner TutorialMicrosoft Excel Tutorial for Beginners - Full CourseExcel 2019 Beginner TutorialAdvanced Pivot Table Techniques (to achieve more in Excel)