Mr Excel & excelisfun Trick 174: Clean & Transform GDP Data Set: Advanced Filter? Or Power Query?

Bill Mr Excel Jelen and Mike excelisfun Girvin show how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and match just the data we want to create a smaller data set using Advanced Filter or Power Query:
1) (00:15) Introduce Task of converting large data set into a smaller data set with desired filter
2) (00:56) Mr Excel uses Advanced Filter
3) (02:48) Excelisfun uses Power Query

M is for Data Monkey

Basic Excel Business Analytics. Basic Excel Business Analytics Transforming Data.

Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter?

Excel Magic Trick 1242: Transform Large GDP Data Set for Final Report: TTC, MATCH, Filter & Formatting

[bohemaxxtum]

thank you guys for both methods.for me, mr.excel's way is much easier.and to watch you is just fun.

[RavinderOzha]

7:07 Yes, Dividing by Million may also be an option as following Type 10, 000, 00, Copy > Select Number Table > Paste done. By the way you Guys are awesome Teachers for all YT Excel Learners.... Thanks

[excelisfun]

Point to Mr Excel for Advanced Filter!!!!

[MySpreadsheetLab]

This is a classic! Thanks Bill & Mike !

[XLarium]

Sounds like you were broadcasting from the bottom of a bucket. :-)
And I learned something new: Advanced Filter using multiple criteria lines with one title line => multiple results.

[krn]

Thanks guys. It has been too long between duels. Miss my weekly duel.

[diaconescutiberiu]

Hey Mike&Bill. Thank you for this ...you saved me from hours of doing that filtering (which i had to do several times per week). Keep up the great work.

PS: Mike, i know you did a gant chart tutorial inside a CF video, but yours was for days. Do you have/Would you make one for months? Like I need to do EU project Gant Charts... that usually last for 2 years; the project is divided in phases of several months (in length). Weekends and Holidays are not so important, when you do it for months (but i wouldnt mind :) 2 tutorials, one only for month and one with months and days). Thank you so very much! You are a life saviour

[marekzadecki]

I think that Power Query is easier and faster than Advanced Filter. But both solucions give the same result.