The Course – Live Online

[vc_row css=”.vc_custom_1427118687259{padding-top: 50px !important;padding-bottom: 50px !important;}”][vc_column width=”2/3″][themeone_header type=”h2″]High Quality Training Created From a Practical Point of View.[/themeone_header][vc_column_text]There are no workshops presently scheduled. Subscribe to our newsletter to be notified once new course dates become available. For private workshops, contact us for more information.[/vc_column_text][vc_row_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Online Classes” color=”#aaaaaa” icon=”devices-monitor”]

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.

[/themeone_box_anim][/vc_column_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Video Recordings” color=”#aaaaaa” icon=”icon-et-video”]

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

[/themeone_box_anim][/vc_column_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Homework & Samples” color=”#aaaaaa” icon=”icon-et-tools-2″]

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.

[/themeone_box_anim][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Free eBook” color=”#aaaaaa” icon=”fa fa-book”]

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’

[/themeone_box_anim][/vc_column_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Top Instructors” color=”#aaaaaa” icon=”steadysets-icon-users2″]

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

[/themeone_box_anim][/vc_column_inner][vc_column_inner width=”1/3″][themeone_box_anim title=”Q&A Session” color=”#aaaaaa” icon=”fa fa-comments-o”]

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.

[/themeone_box_anim][/vc_column_inner][/vc_row_inner][/vc_column][vc_column width=”1/3″][vc_single_image image=”421″ img_size=”medium” alignment=”center”][themeone_ptable featured=”true” link=”” button=”Register” style=”“width: 250px;” src=”““” alt=”“Power”][themeone_li icon=”steadysets-icon-checkmark”]

1 Free Book (eBook version)

[/themeone_li][themeone_li icon=”steadysets-icon-checkmark”]

2-Day Course (5 hours each)

[/themeone_li][themeone_li icon=”steadysets-icon-checkmark”]

1-Q&A Session (5 hours)

[/themeone_li][themeone_li icon=”steadysets-icon-checkmark”]

Top Quality Instructors

[/themeone_li][themeone_li icon=”steadysets-icon-checkmark”]

6 Hands-on Labs

[/themeone_li][/themeone_ptable][/vc_column][/vc_row][vc_row txt_section_color=”light” css=”.vc_custom_1440308711153{padding-top: 50px !important;padding-bottom: 10px !important;background-color: #545454 !important;}”][vc_column][vc_row_inner css=”.vc_custom_1427121266187{padding-bottom: 50px !important;}”][vc_column_inner width=”2/3″][themeone_header txtalign=”txt-center”]

Download the Course Brochure

[/themeone_header][/vc_column_inner][vc_column_inner width=”1/3″][themeone_button text=”Download” url=”” target=”_blank” size=”large” type=”full-width” iconanim=”animate” icon=”steadysets-icon-book2″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row to_section_layout=”section-container”][vc_column width=”2/3″][vc_row_inner css=”.vc_custom_1427122237749{padding-top: 100px !important;}”][vc_column_inner txt_column_align=”txt-center” delay=”0ms”][themeone_header txtalign=”txt-center”]

Aimed Towards

[/themeone_header][themeone_spacer height=”30px”][/vc_column_inner][/vc_row_inner][vc_row_inner css=”.vc_custom_1427123370829{padding-bottom: 100px !important;}”][vc_column_inner width=”1/2″ txt_column_align=”txt-center” delay=”0ms”][themeone_icon_txt title=”Excel Users” size=”fa-5x” color=”accent-color1″ anim=”tada” icon=”fa fa-user”]

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.

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/2″ txt_column_align=”txt-center” delay=”0ms”][themeone_icon_txt title=”IT & BI Specialists” size=”fa-5x” color=”#007dbc” anim=”tada” icon=”fa fa-user”]

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.

[/themeone_icon_txt][/vc_column_inner][/vc_row_inner][/vc_column][vc_column width=”1/3″ delay=”0ms” css=”.vc_custom_1427144083832{background-color: #8c8c8c !important;}”][vc_row_inner css=”.vc_custom_1427143822794{padding-top: 100px !important;padding-bottom: 20px !important;}”][vc_column_inner txt_column_align=”txt-center” delay=”0ms”][vc_column_text]
[/vc_column_text][/vc_column_inner][/vc_row_inner][vc_row_inner css=”.vc_custom_1427144175414{padding-bottom: 130px !important;}”][vc_column_inner width=”1/2″][vc_single_image image=”1384″ img_size=”231×300″ alignment=”center”][/vc_column_inner][vc_column_inner width=”1/2″][themeone_header type=”h2″ txtcolor=”second-bgcolor”]

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.

[/vc_column_text][themeone_spacer height=”30px”][themeone_button text=”About the Book” url=”” target=”_blank” size=”large” style=”to-button-border” bgcolor=”#ffffff” iconanim=”animate” icon=”fa fa-book”][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row css=”.vc_custom_1440309039971{background-color: #f5f5f5 !important;}”][vc_column][themeone_spacer height=”51px”][themeone_header txtalign=”txt-center”]

Workshop Content

[/themeone_header][themeone_spacer height=”51px”][vc_row_inner][vc_column_inner width=”1/2″][vc_column_text]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

[themeone_toggle active=”false” title=”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

[/themeone_toggle][/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_single_image image=”761″ img_size=”560×421″ alignment=”center”][themeone_header type=”h3″ txtalign=”txt-center”]

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

[/themeone_header][/vc_column_inner][/vc_row_inner][themeone_spacer height=”30px”][vc_row_inner][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][themeone_button text=”Download Course Brochure” url=”” target=”_blank” size=”large” type=”full-width” iconanim=”animate” icon=”steadysets-icon-align-justify”][/vc_column_inner][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][/vc_row_inner][themeone_spacer height=”51px”][/vc_column][/vc_row][vc_row css=”.vc_custom_1427944312313{padding-top: 51px !important;padding-bottom: 51px !important;}”][vc_column][themeone_header subtitle=”Two Excel MVPs and Power BI professionals.” txtalign=”txt-center”]

Meet the Instructors

[/themeone_header][/vc_column][/vc_row][vc_row css=”.vc_custom_1427026758963{padding-bottom: 0px !important;}”][vc_column width=”1/4″ txt_column_align=”txt-center” delay=”0ms”][vc_single_image image=”446″ img_size=”157 × 235″ alignment=”right”][vc_column_text]

[themeone_social_icon type=”linkedin” url=””] [themeone_social_icon type=”twitter” url=””]

[/vc_column_text][/vc_column][vc_column width=”1/4″][vc_column_text]

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.[/vc_column_text][/vc_column][vc_column width=”1/4″][vc_single_image image=”448″ img_size=”full” alignment=”right”][vc_column_text]

[themeone_social_icon type=”linkedin” url=”″] [themeone_social_icon type=”twitter” url=”″]

[/vc_column_text][/vc_column][vc_column width=”1/4″][vc_column_text]

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.[/vc_column_text][/vc_column][/vc_row][vc_row to_section_layout=”section-container”][vc_column][themeone_spacer height=”51px”][/vc_column][/vc_row][vc_row to_section_layout=”section-container” to_equal_column=”equal_height” txt_section_color=”dark”][vc_column delay=”0ms” css=”.vc_custom_1429048777769{background-color: #fcfcfc !important;}”][themeone_spacer height=”50px”][themeone_header txtalign=”txt-center”]

Workshop Schedule

[/themeone_header][themeone_spacer height=”50px”][vc_row_inner txt_section_color=”dark” txt_section_align=”txt-center”][vc_column_inner width=”1/3″][themeone_icon_txt title=”¹ Prep Time” size=”fa-5x” color=”accent-color1″ iconbg=”true” icon=”fa fa-check-square-o”]

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

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/3″][themeone_icon_txt title=”² Live Course” size=”fa-5x” color=”accent-color1″ iconbg=”true” icon=”steadysets-icon-screen”]

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.

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/3″][themeone_icon_txt title=”³ Q&A Session” size=”fa-5x” color=”accent-color1″ iconbg=”true” icon=”fa fa-comments-o”]

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

[/themeone_icon_txt][/vc_column_inner][/vc_row_inner][themeone_spacer height=”50px”][vc_row_inner txt_section_color=”dark”][vc_column_inner][vc_column_text]


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

[/vc_column_text][themeone_spacer height=”30px”][/vc_column_inner][/vc_row_inner][vc_row_inner to_equal_column=”equal_height” txt_section_color=”light”][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][themeone_button text=”Download the Course Agenda” url=”” target=”_blank” type=”full-width” iconanim=”animate” icon=”li_note”][/vc_column_inner][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][/vc_row_inner][themeone_spacer height=”100px”][/vc_column][/vc_row][vc_row txt_section_color=”light” css=”.vc_custom_1481703546808{background-color: #3d3d3d !important;}”][vc_column][themeone_spacer height=”100px”][themeone_header txtalign=”txt-center” txtcolor=”second-bgcolor”]Notify Me When a New Workshop is Scheduled[/themeone_header][themeone_spacer height=”50px”][vc_single_image image=”600″ img_size=”medium” alignment=”center”][themeone_spacer height=”15px”][vc_row_inner txt_section_color=”light”][vc_column_inner width=”1/2″][vc_column_text]

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

[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text][thrive_leads id=’1662′][/vc_column_text][/vc_column_inner][/vc_row_inner][themeone_spacer height=”15px”][/vc_column][/vc_row][vc_row to_section_layout=”section-container” to_equal_column=”equal_height” txt_section_color=”light”][vc_column txt_column_align=”txt-center” delay=”0ms” css=”.vc_custom_1427965566459{background-color: #217245 !important;}”][themeone_spacer height=”51px”][themeone_header subtitle=”Let us bring the Power Query training to you!” txtalign=”txt-center”]

Private & OnSite Workshop

[/themeone_header][vc_row_inner txt_section_color=”dark” txt_section_align=”txt-center”][vc_column_inner width=”1/4″][themeone_icon_txt title=”Learn” size=”fa-5x” icon=”general-light-bulb-on”]

The techniques from the pros

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/4″][themeone_icon_txt title=”Design” size=”fa-5x” icon=”icon-et-map”]

Solutions using YOUR data

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/4″][themeone_icon_txt title=”Implement” size=”fa-5x” icon=”icon-et-flag”]

Solutions for YOUR business

[/themeone_icon_txt][/vc_column_inner][vc_column_inner width=”1/4″][themeone_icon_txt title=”Save” size=”fa-5x” icon=”business-coin-dollar”]

Both time and money

[/themeone_icon_txt][/vc_column_inner][/vc_row_inner][vc_row_inner txt_section_color=”light” txt_section_align=”txt-center” css=”.vc_custom_1427166745388{padding-bottom: 50px !important;}”][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][themeone_spacer height=”30px”][themeone_button text=”Request More Info” url=”/contact-us” target=”_blank” size=”large” type=”full-width” style=”to-button-border” txtcolor=”second-bgcolor” bgcolor=”second-bgcolor” bganim=”animate” iconanim=”animate” icon=”fa fa-book”][/vc_column_inner][vc_column_inner width=”1/4″][vc_column_text]
[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row to_section_layout=”section-container” top_section_deco=”triangle-inner” css=”.vc_custom_1437169161700{background-color: #f1f1f1 !important;}”][vc_column][themeone_spacer height=”51px”][themeone_header subtitle=”What people think about the workshop and our content” txtalign=”txt-center”]Testimonials[/themeone_header][themeone_testimonial_carousel autoplay=”true” speed=”10000ms” page=”true” nav=”true”][themeone_testimonial author=”Stefan” description=”June 2015″]

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

[/themeone_testimonial][themeone_testimonial author=”Elizabeth” description=”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!

[/themeone_testimonial][themeone_testimonial author=”Alex” description=”June 2015″]

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

[/themeone_testimonial][themeone_testimonial author=”Martin” description=”June 2015″]

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

[/themeone_testimonial][themeone_testimonial author=”Juan” description=”June 2015″]

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

[/themeone_testimonial][themeone_testimonial author=”Samira” description=”June 2015″]

I really enjoyed it

[/themeone_testimonial][themeone_testimonial author=”Krishna P.” description=””]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![/themeone_testimonial][themeone_testimonial author=”Anonymous ” description=””]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!” [/themeone_testimonial][themeone_testimonial author=”Anonymous ” description=””]The training examples helped me gain the confidence to tackle what seemed like a really huge impossible task.[/themeone_testimonial][themeone_testimonial author=”Justin M.” description=””]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.[/themeone_testimonial][themeone_testimonial author=”Anonymous ” description=””]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[/themeone_testimonial][themeone_testimonial author=”Mike R.” description=””]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. [/themeone_testimonial][themeone_testimonial author=”Anonymous ” description=””]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.” [/themeone_testimonial][themeone_testimonial author=”Carla M. ” description=”June, 2017″]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.[/themeone_testimonial][themeone_testimonial author=”Anonymous ” description=””]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![/themeone_testimonial][/themeone_testimonial_carousel][/vc_column][/vc_row]



15K+ subscribers have already claimed their free eBook.

Sign up and get your FREE copy