Which of the five techniques shown this week is your favorite?
This week, I covered Subtotals, Remove Duplicates, Advanced Filter, Consolidate, & Pivot Tables.
Vote here: Microsoft Forms
This week, I covered Subtotals, Remove Duplicates, Advanced Filter, Consolidate, & Pivot Tables.
Vote here: Microsoft Forms
Transcript of the video:
Learn Excel from MrExcel podcast, episode 2192.
Summary of Summarize Data Week.
All this week we did five episodes from 2187 to 2191.
I've to create a customer summary report from detail data.
Starting with subtotals, remove duplicates, advanced filter, consolidate and pivot table.
Now, I'm back to five videos and count number of click or key strokes.
Alright! And actually consolidate and pivot table are tied with 9 and then the elapsed time and cosolidate amazingly was faster than pivot table.
Now, in these videos, I'm explaining things like [ inaudible ].
So, it's probably almost a tie, I guess but here's a opportunity for you.
Well, if you are conceded the description of this link or if you just watching this, point your phone at the screen here and it will open a survey.
Vote for your favorite and then at the article that goes along the video.
I will post the results.
So, thanks for watching the summarize data week with a five different choices, sure I miss some.
Certainly power query, old Microsoft query.
If you have any other method let me know down here in the comments, vote for your favorite.
I wanna thank you for stopping by, we'll see you next time from another netcast from MrExcel.
Summary of Summarize Data Week.
All this week we did five episodes from 2187 to 2191.
I've to create a customer summary report from detail data.
Starting with subtotals, remove duplicates, advanced filter, consolidate and pivot table.
Now, I'm back to five videos and count number of click or key strokes.
Alright! And actually consolidate and pivot table are tied with 9 and then the elapsed time and cosolidate amazingly was faster than pivot table.
Now, in these videos, I'm explaining things like [ inaudible ].
So, it's probably almost a tie, I guess but here's a opportunity for you.
Well, if you are conceded the description of this link or if you just watching this, point your phone at the screen here and it will open a survey.
Vote for your favorite and then at the article that goes along the video.
I will post the results.
So, thanks for watching the summarize data week with a five different choices, sure I miss some.
Certainly power query, old Microsoft query.
If you have any other method let me know down here in the comments, vote for your favorite.
I wanna thank you for stopping by, we'll see you next time from another netcast from MrExcel.
