Ken Puls, FCPA, MS MVP
banner
excelguru.ca
Ken Puls, FCPA, MS MVP
@excelguru.ca
I teach people how to use Excel (https://skillwave.training), host an Excel website (https://excelguru.ca), build software (https://monkeytools.ca) and enjoy watching football (aka soccer).
Pinned
Dec 14 is International Monkey Day! 🐵
To celebrate, we're offering discounts on our Monkey Tools #Excel add-in. From Dec 14-20, 2025, simply go to monkeytools.ca and use the following codes at checkout:
🔵 20% off Annual Licenses = MDANNUAL20
🟢 15% off Lifetime Licenses = MDLIFETIME15

#DataModeling
It's the last day to save on our Monkey Tools #Excel add-in! ⏰ Don't miss out, go to monkeytools.ca and apply these these codes at checkout:
🔵 20% off Annual Licenses = MDANNUAL20
🟢 15% off Lifetime Licenses = MDLIFETIME15

#BusinessIntelligenceTools #DataAnalysis #DataModel #PowerBI
December 20, 2025 at 6:55 AM
In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
www.youtube.com
December 19, 2025 at 5:30 PM
In this video, I demonstrate how to build a dynamic forecast sheet in #Excel that connects directly to a #PowerPivot #DataModel. 📉
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution: www.youtube.com/watch?v=y1fz...

#FinancialModeling
Forecasting - Dynamically from Data Model
YouTube video by Skillwave Training
www.youtube.com
December 18, 2025 at 7:18 PM
Even though International Monkey Day was on December 14, we're celebrating all week long! 🐵
Until December 20, 2025, save on our Monkey Tools #Excel add-in by using these codes at checkout:
🔵 20% off Annual Licenses = MDANNUAL20
🟢 15% off Lifetime Licenses = MDLIFETIME15
Go to monkeytools.ca today!
December 17, 2025 at 5:40 PM
The new edition of our newsletter is out! 📧
Want to get the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, and more? Subscribe today at xlguru.ca/newsletter. Plus, we'll also send you our free 'DIY BI' eBook series! 📚
December 16, 2025 at 6:44 PM
If you’ve ever added a column to your #PowerQuery-generated table to keep notes, flags, or status codes, you know the pain: as soon as new records arrive or sorting changes, your notes stay in the old row positions – now attached to the wrong records. 😬
A student asked about this in our AKA call. 🧵
December 16, 2025 at 5:12 PM
Nothing better than hearing from happy students! ❤️
Woo hoo, another 5⭐️ review for @excelguru.ca's #SelfServiceBI Academy!

This premium, self-paced training is crafted for business professionals who demand excellence in #DataAnalytics using #Excel and #PowerBI. Get started today at skw-t.com/ssbi
December 16, 2025 at 1:30 AM
While functions in #Excel and #PowerQuery are often quite similar, there are some key differences. The most important thing to remember is that all functions in Power Query, whether text, logic or anything else, are case sensitive - “if” is not the same as “IF”.

#DataAnalytics #DataPreparation
The IF Function in Power Query
Today we’re going to look at another compare/contrast scenario between Excel and Power Query, but this time it’s going to be the IF function in Power Query
excelguru.ca
December 15, 2025 at 5:36 PM
Dec 14 is International Monkey Day! 🐵
To celebrate, we're offering discounts on our Monkey Tools #Excel add-in. From Dec 14-20, 2025, simply go to monkeytools.ca and use the following codes at checkout:
🔵 20% off Annual Licenses = MDANNUAL20
🟢 15% off Lifetime Licenses = MDLIFETIME15

#DataModeling
December 14, 2025 at 4:03 PM
When importing data in #Excel or #PowerBI via #PowerQuery, it's good to set the column data types. But with wide tables, it can take a lot of time as you have to wait for PQ to catch up after setting each column. 😭
Here's a tip to quickly set ALL data types:
Quick tip for setting Data Types in Power Query - Monkey Shorts Episode 004
When importing data via Power Query, it is a good idea to set the data types of your columns. The challenge is that - in wide tables - doing this for each column can take a lot of time as you set…
www.youtube.com
December 12, 2025 at 5:20 PM
In this step-by-step demo, I highlight how Auto Refresh brings standard #PivotTables up to par with a Power Pivot #DataModel and the importance of #PowerQuery in managing data refreshes, plus give insights on SPILL errors: www.youtube.com/watch?v=cCKI...

#Excel #DataAnalytics #BusinessIntelligence
Pivot Consistency
YouTube video by Skillwave Training
www.youtube.com
December 11, 2025 at 6:45 PM
In one of my AKA sessions, an attendee asked why a #PowerBI report kept losing its table column headers whenever they scrolled down the table. Even the slicer vanished off-screen! 😠
The culprit? The canvas size had been set to a massive custom size – 1080 pixels tall by 6000 pixels wide. 🧵
December 11, 2025 at 5:04 PM
I love hearing from happy Monkey Tools users! 🥰

The philosophy of Monkey Tools is build better, faster. Our add-in is targeted at the #DataModeler and #DataAnalyst who works primarily in #Excel, but is also for those who push their models into #PowerBI.
👉Get a FREE 2-week pro trial: monkeytools.ca
December 10, 2025 at 5:34 PM
I'm really excited to be leading an in-person session today for CPABC in Vancouver! It's about how using #PowerBI for rapidly building and sharing dashboards and reports.

🤔Ever been in a situation like the first image? PBI allows the #DataAnalyst to prototype the report without wasting IT's time!
December 9, 2025 at 5:46 PM
Reposted by Ken Puls, FCPA, MS MVP
🚩Red Flags in a file- and a Chris (tmas) Angyal

youtu.be/NqIs6Xhu_uo

#Unpivot #Excel #PowerBI
December 6, 2025 at 11:40 PM
If you weren't able to attend last week's Vancouver #PowerBI and Modern #Excel meet-up, the recording is now available here: youtu.be/wqnrqD5-CWs

If you work as an Excel consultant and deal with client requests and tweaks, you'll want to check out Marco Filocamo's presentation. 😉
In the Excel of Madness: Surviving Client Requests
As an Excel consultant, have you ever felt lost between a client’s ever-changing requests and the endless possibilities of Excel? Welcome to In the Excel of Madness, a session for those who live on…
youtu.be
December 8, 2025 at 5:12 PM
Today, I'm leading another session for Chartered Professional Accountants of BC on creating vibrant dashboards in #Excel.

But what exactly is a dashboard? 🤷♂️
It's a quick visual summary to display key information. Its purpose isn't to provide solutions, but to expose problems.

#DataVisualization
December 5, 2025 at 9:55 PM
In this episode of Monkey Shorts, I'll show you how you can set different layouts for each column of your #PivotTable: www.youtube.com/watch?v=6ewp...

#DataAnalysisTools #BusinessIntelligence #Excel
Granular PivotTable Layouts - Monkey Shorts Episode 003
In this episode of Monkey Shorts, Ken will show you how you can set different layouts for each column of your PivotTable.
www.youtube.com
December 5, 2025 at 7:18 PM
It's the last day of our Cyber Week deals!

🐒Monkey Tools: mkyt.ca/cyber2025
- Save 20% on Annual Licenses with code MONKEYANNUAL20
- Save 15% on Lifetime Licenses with code MONKEYLIFE15

💻 @Skillwave.Training: skw-t.com/cw25
- Save 25% on all courses and eBooks with code 2025CYBER
December 5, 2025 at 4:05 PM
Tired of boring data presentations? Join our #DataVisualization course at @skillwave.training, and master the art of visual storytelling. Learn to create captivating graphs and charts in #Excel and #PowerBI to communicate more effectively!

Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-dv
December 4, 2025 at 9:47 PM
An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up. Marco Filocamo will be presenting "Excel of Madness" - a session for those who live on the edge of formulas, consulting deadlines, and last-minute “small tweaks” from clients. 😱
👉 Sign up here:
In the Excel of Madness: Surviving Client Requests | Marco Filocamo, Thu, Dec 4, 2025, 9:00 AM | Meetup
***\*\*NOTE: This will be our last event of 2025, but we'll be back in January 2026!*** **SESSION TRACK:** Excel **SESSION OUTLINE:** As an Excel consultant, have you eve
www.meetup.com
December 4, 2025 at 3:59 PM
🔑 #DimensionalModeling is the key to unlocking the power of #DataAnalytics in #Excel and #PowerBI. Learn to design and optimize your #BusinessIntelligence models to make them more stable and scalable with our course at @skillwave.training. 🖥️
Sign up with code 2025CYBER to save 25%: skw-t.com/cw25-dm
December 3, 2025 at 8:57 PM
There's still time to save on a Monkey Tools license: mkyt.ca/cyber2025
- 20% off Annual Licenses with code MONKEYANNUAL20
- 15% off Lifetime Licenses with code MONKEYLIFE15

Our Monkey Tools #Excel add-in will help you build better data models more quickly and using #DataModelling best practices.
December 3, 2025 at 5:06 PM
Become an #Excel guru with my Excel Fundamentals Academy at @skillwave.training! 🌟 From basic formulas to automated #DataCleaning to advanced #DataAnalytics, we've got you covered. Take the plunge into the world of #ExcelMastery! 💪
Join us today and save 25% by using code: skw-t.com/cw25-xlf
December 2, 2025 at 9:36 PM
Reposted by Ken Puls, FCPA, MS MVP
For the morning UK and Europe crew: Working efficiently means creating reusable assets. In Microsoft Excel, worksheet frameworks such as monthly summaries or invoices can be saved as template files that you open with a single click. In this movie, I'll show you how to create them!
Create and use an Excel template
If you find yourself creating the same type of worksheet frequently, you can save a base file as an Excel template to provide a structure you can modify later. In this movie I’ll show you how to save…
youtu.be
December 2, 2025 at 7:45 AM