Ok, so you've been given the task of combining a lot of excel lists into one large list. 😲

As many of you know copy and paste is going to be a headache, and you might use the VSTACK formula... which may work sometimes.

But using VSTACK is not always the best solution...

You see the vast majority of excel users don't know how to use Power Query, and that Power Query can save you hours of repetitive work, and automate your tasks. 😁

This video will show you 3 ways to use Power Query.

⌚*TIMESTAMPS*

0:00 Why use Power Query
0:33 Don't copy and paste your lists 😬
0:57 Don't use VSTACK
1:20 The benefits of using Power Query
1:53 Method 1: How to use Power Query to combine multiple sheets into a new file
5:18 Method 2: How to use Power Query to combine multiple sheets into the same file
8:46 Method 3: How to use Power Query to combine multiple files into a new file
10:30 Bonus: How to edit in Power Query and create simple calculations

💾*FILE DOWNLOAD*

https://1drv.ms/u/c/a6a54ea252cde109/... (Zipped Format)

📢* FREE RESOURCES*

Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...

Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...

☕*BUY ME A COFFEE?*
https://www.buymeacoffee.com/professo...

~~~~~~~~~~~~~~~~~~~
ABOUT PROFESSOR CUBS

🏆 My goal is to help you learn popular software apps so you can be more productive, save time in life, so you can spend it on activities that matter.
Some of the app tutorials include:
- Microsoft Excel, Power BI, PowerPoint, OneNote, Word, Tableau, Audacity, Reaper and other popular software applications

🎓 My background: 25+ years in corporate training teaching both software and business skills, along with working in the financial business. Degree in Finance, along with a list of certifications that would bore you to tears.

🚀 I remember first learning technology, how confusing and overwhelming it can be. So I strive to make things simple, easy and fun.

Thanks,
Professor Cubs