How To Use Advanced Pivot Tables to Make Data Analysis Simpler Than Ever

preview_player
Показать описание
Learn how to use the advanced pivot technique in Power Query to easily pivot messy data where you have text, dates, and currency values in various rows and you want to pivot these into their own separate columns. Using the advanced pivot technique in Power Query will help you analyze your data faster, save you time and no formulas needed! And as this is Power Query your pivot table is dynamic, just hit refresh and your query automatically updates!

Timestamps:
00:00 Example 1
00:29 The Messy Data to Pivot
01:12 Add Index
01: 46 Add Conditional Column
2:14 Fill Down
02:34 Pivot the Data
03:55 Example 2
04:25 Columns to Fill Down
04:31 Pivot the Data
05:58 Advanced Editor Video

✅ Please see link to videos mentioned in this video:

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ For more Power Query videos please use the links below:

✅ Please also check out my Excel course on Udemy, please use this link:
  1. Miss Microsoft
  2. advanced excel tricks
  3. excel tips and tricks
  4. excel for analysts
  5. microsoft excel tutorials
  6. microsoft excel
Рекомендации по теме
Advanced Pivot Table 0:11:47

Advanced Pivot Table Techniques (to achieve more in Excel)

You Won't Believe 0:11:30

You Won't Believe These Crazy PIVOT TABLE Hacks!

Advanced Excel - 0:13:11

Advanced Excel - Creating Pivot Tables in Excel

Advanced Pivot Table 0:10:40

Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel

How To Use 0:06:39

How To Use Advanced Pivot Tables to Make Data Analysis Simpler Than Ever

Advanced Pivot Table 0:08:09

Advanced Pivot Table Techniques in Excel (Surprising Features)

☑️ Top 25 0:28:30

☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft Excel

Advanced Pivot Table 0:18:34

Advanced Pivot Table Options in Excel |

How to use 0:10:15

How to use Pivot Tables in Excel - A Step-by-step guide

🧙‍♂️ Pivot Table 0:17:23

🧙‍♂️ Pivot Table Excel Tips & Tricks

Advanced Pivot Tables 1:08:00

Advanced Pivot Tables in Excel: 1-hour Excel Pivot Tables Tutorial

Advanced Pivot Tables 2:43:53

Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course

Advanced Pivot Table 0:15:10

Advanced Pivot Table Design | Microsoft Excel Tutorial

MS Excel - 0:15:05

MS Excel - Pivot Table Example 1 Video Tutorials

Pivot Table Excel 0:13:36

Pivot Table Excel Tutorial

Advanced Excel - 0:05:17

Advanced Excel - Using 'Recommended Pivot Tables'

Excel Pivot Table 0:13:22

Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)

Create Pivot Tables 0:12:01

Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial

I don't use 0:06:37

I don't use PIVOT tables anymore... I use this other thing instead!

Advanced Pivot Table 0:06:30

Advanced Pivot Table Tricks #11 - Dynamic Pivot Charts

Advanced Pivot Tables 0:26:55

Advanced Pivot Tables Tips and Little known Secrets

How to use 0:30:38

How to use Power Pivot in Excel | Full Tutorial

4 Advanced Pivot 0:07:34

4 Advanced Pivot Table Tips in Excel

SURPRISING Advanced Filter 0:05:59

SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

Комментарии
Автор

You have NO IDEA how much I've been looking for this. You just earned a Subsribe a comment and a like.

PatrickPitso
Автор

Really appreciate this tutorial! Helped so much

KidtomanxietySano
Автор

Awesome examples! Thanks for providing the sample file to follow along. Note that for example #1, you can also directly transform the index column with Integer-Divide Column by 6 and you will get six 0s, six 1s and six 2s which then allows you to Pivot on Field Name and get the data in rows 0, 1, 2. Just another way to get there. Thanks for your lessons! Very helpful :)) Thumbs up!!

wayneedmondson
Автор

Hi thanks for this! However, i don’t understand the need for index and conditional column? Would pivoting without those steps work?

ardenzhuo
Автор

Thanks for the sharing
Request you to please share excel file link.

RahulChauhan-llpu
Автор

5:20 on that step the add columng tab standard is grey out, what could be wrong?

alejguz