Excel Tricks to Save 95% of Your Time on Boring Tasks

👩‍🏫 Power Query course: https://bit.ly/powerq24course
Excel feature you didn't know could save you hours (tips & tricks on how to use it)

⬇️ Download the example file here and follow along: https://bit.ly/powerq24file

There’s no avoiding messy data, whether it’s splitting columns, merging tables with VLOOKUP or XLOOKUP, unpivoting, transposing data, or removing duplicates to name a few. And what’s worse is having to repeat these laborious tasks every month or week or more.

Unfortunately, most people think you need VBA programming skills to automate these boring tasks, but that’s not the case.

In this video, I’m going to show you 5 common laborious data gathering and cleaning tasks you can do with absolutely zero code so you can cut your repetitious data cleanup time by up to 95%.

LEARN MORE
===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
==============
0:00 Save 95% of your time
0:46 Boring task №1
2:31 Boring task №2
3:51 Boring task №3
6:19 Power Query (course)
7:11 Boring task №4
10:22 Boring task №5

#Excel #PowerQuery #PowerQueryTips