Logo - Skillwave Training

Using Monkey Tools

Author: Ken Puls

Monkey Tools is an Excel add-in containing a set of tools to help you build better Excel solutions more quickly and follow data modeling best practices. The philosophy of Monkey Tools is simple: Build better, faster. It is targeted at modelers and analysts who work primarily in Excel, but is also useful for those who push their models into Power BI. This free course will explain how to unleash our army of monkeys and put them to work for you!

Duration:
5h 40m
Tools:
  • Excel
  • Power BI
Skills:
  • Formulas
  • Data Preparation
  • Data Analysis
  • Data Modeling

What you'll learn?

  • How to acquire, install and activate Monkey Tools
  • Automatically injecting useful queries, formulas, LAMBDAs and measures into your workbook
  • Writing DAX measures, from simple aggregations to complex patterns
  • Creating pivots and filters for your data model
  • Importing and exporting your data models, and restoring a model from backup
  • Identifying where queries load change multiple query load destinations at once
  • Reviewing, editing, and tracing relationships in you M code and DAX
  • Timing and comparing query refreshes, including the effects of privacy settings
  • Gathering insights into the quality of your data model, including: memory usage, unused items, key statistics, and more!
Course

Using Monkey Tools

FREE
  • 5h 40m of training content
  • 13 modules
  • Downloadable files and Handouts

Using Monkey Tools

FREE

Course Description

Monkey Tools is an Excel add-in developed by Ken Puls. It contains a set of tools to help you build better data models more quickly and follow data modeling best practices.

The philosophy of Monkey Tools is simple: Build better, faster. It is targeted at modelers and analysts who work primarily in Excel, but is also useful for those who push their models into Power BI.

Our aim is to provide you with a good set of tools that help you, as a business intelligence author to:

  • Build models more rapidly
  • Follow recommended practices
  • Export model data to CSV
  • Document your work
  • Audit files you receive
  • Import Power BI files to Excel

Monkey Tools adds a broad set of new features specifically for working with Power Query and the Data Model, and is divided into two general collections: Monkeys and Sleuths. Located on their own dedicated Monkey Tools ribbon tab, our team of Monkeys make things happen, and the Sleuths figure out what has happened.

In this free course, Ken Puls demonstrates how the various Monkeys and Sleuths work, so you can get the most from these amazing features.

Who this course is for?

  • Anyone who wants to learn more about the various features Monkey Tools
  • Every data modeler and data analyst working in Excel, and those who push their models to Power BI

Reviews

Using Monkey Tools

Average Rating

5 / 5

(based on 1 review)

4.88/5
Misca Mustonen
Misca Mustonen
July 9, 2024
Read More
Lots of information in an easy to digest format. The Using Monkey Tools course was super useful. Thank you for making it!

Course Update Log

First release of the course to the Skillwave Training site.

Course Formats

On Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files.

Course Content

Expand All
Module Content
0% Complete 0/1 Steps
Module Content
0% Complete 0/1 Steps
Module Content
0% Complete 0/1 Steps

About the author

Ken Puls

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQs

How long do I have access to this course?

You have unlimited access to this course. Unlike our other courses, it is not built on a subscription basis so there is no renewal or expiry date.

How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

Where do I get a Monkey Tools license?

Go to https://monkeytools.ca and select the license option you prefer.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

  • Excel
  • Power BI
2h 30m
4 Modules
FREE
  • Power BI
  • DAX Studio
  • Power Pivot for Excel
13h 30m
5 Modules
$350