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

Excel feature you didn't know could save you hours (tips & tricks on how to use it)

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
===========



⏲ 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

[MyOnlineTrainingHub]

❓ What’s your favorite Excel trick for saving time?

[ymup]

The comparing two lists is a good reminder that I have been under utilizing power query because a lot of my old and cumbersome ways still work and are so familiar to me. I turn to them not because they are the best but because I sometimes don't have the time or energy to learn a new way to do something I already know how to do. But it is totally worth the effort to learn a new mew approach when it is clearly a much better method. I just need to form a new habit. Thank you

[cyberdeath]

I think I landed a gold mine with this channel! I love the teaching language and approach. Makes it very easy to follow.

[mogarrett]

Power Query is the magic in the it . Thank you my friend

[sinnersavedbygracethrufait]

Such a gifted teacher, thanks for sharing!

[msmith]

Excellent intro to some common scenarios where Power Query is quite useful. I've been trying to get my coworkers to learn Power Query, so will pass this URL on to them.
Thank you, Mynda!

[ssm]

I did a live demo of #3 and #5 for co-workers and they were all 🤯.

[andrzejhornostaj]

Unpivoting the columns is the perfect tip for me.thank you😊

[greapis]

Wow! It's fantastic. PowerQuwry you explained to me enhanced a lot of productivity.
Thanks a lot!!❤

[mohammedfayas]

OMG!!! I gotta grab some real grip with PQE. It's insanely genius :) U are amazing.😃

[xeeshanahmad]

Every time I watch your video it mesmerized me. You are amazing.

[vorpalsword]

I love your channel so much. Thank you for this

[eliasnahhas]

Wow! Nice Power Query video! Covering some very nice transformation!

[JavierLeBlan]

OMG! Thank u so much, this are so amazing tricks!!! Greetings from México!

[scotolivera]

loved the lookup trick with the inner step

[BestJerome]

Thank you for the wonderful introduction!

[und]

I'm 77 years old. Where can I download ready made files I can download and use ?

[SothearithKONGMrMuyKhmer]

🥰 That’s really helpful. Thanks so much!

When I combined the files using power query and each file has different sheet names, I ended up with error.. until I renamed the sheet name of all files with the same names (i.e. Sheet1). Do you have any advice for this? Thanks a lot!

[silversolver]

Excellent as always Mynda, thank you :)

Question: do you regard Excel as being robust enough these days to function as a database? Not huge DBs, my biggest table is 200K rows, updated regularly from data cleaned in XL. So workflow XL> Access > XL.

I've used XL for 30+ years and it used to be too 'fragile' for DB use—just too easy to break the data. So I've used Access for 20 years to store data and XL to analyze and present.

[jamesessiet]

Hello, Treacy. Great teaching here. I found the suggestions very helpful, and Power Query is an essential tool that empowers any & every Excel user.

However, I realized an impediment. The Table/Range option in the Get Data ribbon is unavailable on MacOS (I used my Windows to test your solutions), and I use 365.
Would you happen to have any suggestions on how to navigate that? Thank you