Do you know this POWERFUL trick in Excel?

[@launchexcel]

*Get the FREE Excel workbook for this video* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Get the workbook: courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-85ff31d2 TIP: Stay logged in for quick access to ALL workbook downloads ✅ Learn Power Query Fast: go.launchexcel.com/moth-power-query-course *Chapters:* 00:00 Have you ever spent hours mindlessly copying and pasting? 01:29 LEVEL 1: Basic Web Query 02:58 LEVEL 2: Customize the Table 11:11 LEVEL 3: Single Text Changes 14:38 LEVEL 4: 2-Letter Country Codes to Full Country Names 19:59 LEVEL 5: Work on Dates 21:57 How to learn Power Query in depth? *Watch this video next* STOP Wasting Time on Repetitive Tasks with Excel VBA kzbin.info/www/bejne/o5CpmIltnpyLaas

[@JanBolhuis]

Great video. Thanks. The copy-paste “trick” in level 5 is great. Never thought of doing it this way.

[@launchexcel]

Glad you liked Level 5's copy paste! I'm gathering up all these little tricks for Power Query because I'm learning it myself this year.

[@robbe58]

Downloading the example file for his video fails. The website is accessible but gives an error when going to the download section. Could you please check it out? Thank you.

[@launchexcel]

Thanks for bringing this to my attention. It looks like the site has an issue with loading. I'll get some tech support to resolve.

[@launchexcel]

The site is back up. Have a look to see if it's working for you.

[@robbe58]

@@launchexcel Everything is running smoothly again. Thank you.

[@christianwinter20]

Power query is just an incredibly powerful tool inside excel

[@launchexcel]

Yes indeed. I'm actually on a journey of learning it myself and documenting my findings. Feel free to share stuff you know about PQ 😀