Power Query Workshop (Live Online)

High Quality Training Created From a Practical Point of View.

No prior knowledge of Excel required!

Online Classes

Online Classes

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.

Video Recordings

Video Recordings

You’ll be able to download the full recordings of the Workshop in order to revisit any topics. (Full HD recordings)

Homework & Samples

Homework & Samples

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.

Free eBook

Free eBook

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’

Top Instructors

Top Instructors

You’re not getting one but two top quality instructors, both of whom are Microsoft Excel Most Valuable Professionals and experts in the field.

Q&A Session

Q&A Session

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.

Download the Course Brochure

Aimed Towards

Excel Users

Users that employ Excel on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools to improve their reporting and data crunching capabilities.

IT & BI Specialists

Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources.

large_323_MDataMonkey700[1]

Get a free copy of this book

Sign up for the workshop and get a free copy of the eBook

Note: By registering, you will receive a digital copy of this book.
About the Book

Workshop Content

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:

  • Solid instruction
  • Followed by hands on labs
  • Example files, each of which is built from real life scenarios that we’ve experienced
  • Custom Q&A Session to address any questions or special scenarios

Topics Covered

  • Introduction to Power Query and its usefulness to an Excel user
  • Appending multiple files together into a single data set
  • Cleaning imported data for analytical use
  • Sorting and grouping imported data
  • Transforming poorly structured data into useful data sets by un-pivoting, transposing, sorting and grouping
  • Understanding M syntax and how to create custom functions
  • How to import csv, txt and Excel files
  • How to import from databases, web pages and Microsoft Exchange
  • Creating your own data by using custom columns and Power Query formulas
  • Implementing conditional logic in Power Query columns
  • Exploring the benefits of the M coding language and how it will take your Power Query skills to superb levels
  • Creating and implementing calendar and parameter tables
  • Sharing your solutions with others
  • Best practices for landing and organizing queries for use in Excel and Power BI

S2A English Final

We’ve developed the most optimal path to teach Power Query

Meet the Instructors

Two Excel MVPs and Power BI professionals.
KenPuls-5506_5x5_Colour

Ken Puls, CPA, FCMA

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.

Miguel Escobar

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.

Workshop Schedule

¹ Prep Time

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

² Live Course

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.

³ Q&A Session

A complete session to address any questions regarding the topics covered in the course, samples, exercises and open questions

Notes

  • All of the online sessions will be delivered through a GoToTraining Session and the recording of such sessions will be made available to the participants no later than 24 hours after the session is finished.
  • You can complete the exercises after each session or, if you prefer, you can do so at any time before the Q&A session. We will address these exercises and any other questions that may arise from the course or the exercises during our Q&A session.

Register For a Live Online Workshop

Subscribe to our newsletter to be notified once new course dates become available.

Private & OnSite Workshop

Let us bring the Power Query training to you!

Learn

The techniques from the pros

Design

Solutions using YOUR data

Implement

Solutions for YOUR business

Save

Both time and money

Testimonials

What people think about the workshop and our content

IT WAS ABSOLUTLY INCREDIBLE! Actually I know already a lot about Power Query, but your examples and cases were absolutely great

Stefan, June 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!

Elizabeth, June 2015

I really enjoyed the class and found it very useful. The content was very strong.

Alex, June 2015

Excellent content and I loved the way the instructor conducted the workshop

Martin, June 2015

I’ve loved this course!! I think it perfectly complements Power Pivot

Juan, June 2015

I really enjoyed it

Samira, June 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!

Krishna P.

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!”

Anonymous

The training examples helped me gain the confidence to tackle what seemed like a really huge impossible task.

Anonymous

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.

Justin M.

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

Anonymous

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.

Mike R.

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.”

Anonymous

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.

Carla M. , 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!

Anonymous

Join our newsletter now and get a FREE copy of our eBook

'Magic Tricks for Data Wizards: TIps & Tricks for Power Query in Excel & Power BI'

x