Take the live classes from anywhere around the world with an internet connection. No need to travel to a classroom, let the classroom come to you.
You’ll be able to download the full recordings of the Workshop in order to revisit any topics. (Full HD recordings)
In order to get you started, we’ll provide you a full set of examples and homework that we’ll revisit during our Q&A Time.
Take home even more tricks and patterns with this free eBook, ‘M is for Data Monkey’. This workshop is based on our upcoming book ‘M is for Data Monkey’
You’re not getting one but two top quality instructors, both of whom are Microsoft Excel Most Valuable Professionals and experts in the field.
One week after the workshop we’ll provide a full Q&A Session in order to address any questions that may arise during the practice and homework.
As business professionals and employers, we understand that the value of a training session is in making sure the participants learn skills that they can apply in their daily jobs.
Our goal with every course is to ensure that all of our students learn real skills that can be applied in the real world. To maximize learning, we provide:
Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.
He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.
Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks.
He also holds the Microsoft MVP distinction and Microsoft Certified Professional for Excel.
Once you register, you’ll receive a set of files that you can check out before the course. These files include the handouts, sample files, workshops and more
2 Sessions, 4 hours each, delivered in 2 days to cover from the basics of Power Query to the advanced topics of the M Language.
A complete session to address any questions regarding the topics covered in the course, samples, exercises and open questions
September 6, 2017 @ 11AM Eastern (New York Time)
September 7, 2017 @ 11AM Eastern (New York Time)
September 20, 2017 @ 11AM Eastern (New York Time)
If you are interested in joining our affiliate program then click here to learn more.
The techniques from the pros
Solutions using YOUR data
Solutions for YOUR business
Both time and money
IT WAS ABSOLUTLY INCREDIBLE! Actually I know already a lot about Power Query, but your examples and cases were absolutely greatJune 2015
this was one of the absolutely most wonderful excel training classes I’ve ever attended! The assignment guide was awesome! Whoever created that did an absolutely thorough job!June 2015
I really enjoyed the class and found it very useful. The content was very strong.June 2015
Excellent content and I loved the way the instructor conducted the workshopJune 2015
I’ve loved this course!! I think it perfectly complements Power PivotJune 2015
I really enjoyed itJune 2015
Since the course] I did one complex project using my PowerQuery and PowerPivot – Instead of opening 8 reports, I use one single report! Love your energy and passion to help the students… Just stunned by your humbleness… Thank you!
My most favorite story: just last week, one of my co-workers had a huge chunk of sales data… they were complaining how long it would take them to get it to a format where they could use pivot tables. And when I told them I could do it in less than 30 seconds — of course, they didn’t believe! Insert table, grab data, unpivot, voila!!! New office hero! Power Query actually makes cleaning data fun!”
The training examples helped me gain the confidence to tackle what seemed like a really huge impossible task.
Your content, blogs, (M) is for Data Monkey, have all been reliable and practical resources for our employee’s development. PowerQuery has become the cornerstone in our business workflow, and has allowed us to achieve incredible productivity and quality improvements in handling our customer’s information.
Enjoyed the book and work through examples as well as the format and working exercises and the Q&A… The timeline was perfect and the follow-up session very helpful. Ken and Miguel did an excellent job overall… Have recommended book and workshop to co-workers
I really enjoyed the workshop. It was one of the best training I had! I was amazed of all the material you covered and how smooth it went and on time. I look forward to leaning more about Power Query.
I love the video format because when I come across a new problem, I can reference the video to review a pattern that was taught in the course to handle that exact issue. The class was very reasonably priced and one of the most useful classes I have ever taken.”
The training and your written resources are excellent. It was really understanding the ‘group by’ function that finally turned the light bulb on how to re-create a lot of my previous work… Thank you for both of your passion and love of the tool to share and educate others… Keep doing what you are doing.June, 2017
My [BI] solution would not be possible without Power Query! Both Ken and Miguel are great and know their stuff. They posted all sessions online for us so I can always look back… All in all, very happy!