Monkey Tools are AWESOME

August 7, 2020 By Mike Carlo

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

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.