👩🏫 Power Query course: [ Ссылка ]
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: [ Ссылка ]
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: [ Ссылка ]
🎯 FOLLOW me on LinkedIn: [ Ссылка ]
💬 EXCEL QUESTIONS: Get help on our Excel Forum: [ Ссылка ]
⏲ 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
