I call the following a Data Jockey's Ordeal !
A typical Excel Report or Dashboard goes through 3 essentials phases
Nearly 80% of the time is consumed in performing repetitive data cleaning tasks!
The worst part.. you've gotta do this each day, each week, each month in-fact each time you need to create the report
Most people of think of solving this problem using... VBA (creating a Macro in Excel). Not a bad idea but not that good as well. 3 Major problems that you'll run into
And you are back to manual data cleaning.
Consider my solution..
3 awesome things about Power Query that you can't ignore
In the last few years I have taught hundreds of people, how to use power query to solve data cleansing and automation problems.
Now it may sound like that I am exaggerating but the major benefit that all of my students got that how much time they saved by automating repetitive tasks.
With one click!
3 people x 3 hours per day for 5 days = 45 hrs saved per week for only on a single task!
I am sure you'd want that.. wouldn't you?
If you don't believe me see this simple example of combining data from multiple excel files... Imagine how much time would you take to do this manually each day.
I solved this problem using Power Query (this is an actual video from the course)
Power Query is going to be new for you.. you will need help from scratch. That's why I have put together this course which teaches you how to work with Power Query and set up automation right from Scratch.
The course is divided into 2 parts
Come learn Power Query with me
There is just one strong recommendation - Don't buy this course and then never use it! Be consistent in completing & practicing the lessons everyday and I promise you'll see surprising results for yourself
If you always wanted to work faster and smarter, don't procrastinate. This course will be worth every penny and minute of your time.