PowerBI.tips

Monkey Tools are AWESOME

August 7, 2020 By Mike Carlo
Monkey Tools are AWESOME

The Monkey Tools add-in for excel is really amazing. As a developer for Power BI for many years I’ve learn a ton of tips and tricks while working with Power Query. Watching Ken demo the high level of automation that Monkey Tools really blew my mind. How did I not know about this tool earlier?! My development patterns have now forever changed.

This presentation for Monkey Tools is presented by it’s developer MVP Ken Puls. Ken is a staple and expert in the Excel community. Not to mention, he is an incredible presenter. You will enjoy this session from Ken.

What are Monkey Tools?

Monkey tools in short is a simple way to automate data modeling within Excel. There are some incredibly helpful portions such as making date calendars, changing how data is handled during Power Query loading process and many more.

Ken gives us a great overview and starts digging into the amazing features of this tool in this two part series about this tool.

Download Monkey Tools Here

Intro to Monkey Tools – Part 1

Intro to Monkey Tools – Part 2

Follow Ken

Blog: https://xlguru.ca/blog
Facebook: https://facebook.com/xlguru
Twitter: https://twitter.com/kpuls
Linkedin: https://linkedin.com/in/kenpuls

Training

Online Training: https://Skillwave.training

Book by Ken

Master Your Data with Excel and Power BI: https://amzn.to/2PyheVm
M is for (Data) Monkey: https://amzn.to/30BElov
RibbonX: Customizing the Office 2007 Ribbon: https://amzn.to/3fzPDh1

Download Monkey Tools

https://xlguru.ca/monkeytools

Previous

Milwaukee Brew City PUG – July 2020

More Posts

Mar 6, 2026

Kicking Off Fabric the Right Way - Ep. 508

Mike and Tommy break down what it really means to start a Fabric implementation the right way, from setting expectations early to choosing practical first moves that won't box teams in later. They also cover a coming permissions change for Fabric data agents that makes semantic models easier for more people to use.

Mar 4, 2026

AI-Assisted TMDL Workflow & Hot Reload – Ep. 507

Mike and Tommy explore AI-assisted TMDL workflows and the hot reload experience for faster Power BI development. They also cover the new programmatic Power Query API and the GA release of the input slicer.

Feb 27, 2026

Filter Overload – Ep. 506

Mike and Tommy dive into the February 2026 feature updates for Power BI and Fabric, with a deep focus on the new input slicer going GA and what it means for report filtering. The conversation gets into filter overload — when too many slicers and options hurt more than they help.