🚨🚨Last chance for Early Bird pricing on Premium Boot Camp tickets to Global #Excel Summit + my in-person #SelfServiceBI Boot Camp in May! There are only 2 tickets are left at the sale price, when ends on January 31. Don't miss out, scoop them up at

At our Feb 19 Vancouver #PowerBI and Modern #Excel meet-up, we'll start off by learning about what's new in Power BI with Joseph Yeates. Then we'll learn about custom #PowerQuery functions with @cristiangyal.bsky.social. 👉Sign up here: www.meetup.com/vancouver-po... (Session will also be recorded.)

🎉 It's awesome to see that #PowerQuery is now generally available in #Excel for Web, including the PQ Editor and import wizard! Learn more about all of the latest updates to Excel for Windows, Web, and Mac in this blog post from the Excel team: techcommunity.microsoft.com/blog/excelbl...

Something we wish #Excel had is the ability to provide a table name during the creation process. To solve this issue, Monkey Tools replaces the standard “Create Table” dialog with one that gives you the ability to name your table, range, or dynamic array, and more! 💥 Learn at mkyt.ca/from-tbl-rng

📣Hey subscribers, the latest newsletter should be in your inbox! If you're not subscribed, sign up at xlguru.ca/newsletter and get info on what's new in #Excel and #PowerBI, courses, events, and specials, and the latest expert content. Plus, we'll also send you our free 'DIY BI' eBook series! 📚

The recording for last week's Vancouver #PowerBI and Modern #Excel meet-up is now available: www.youtube.com/watch?v=JlUK... 🙏 Thank you again to Joseph Yeates for showing us what's new in Power BI, and to Reza Rad for teaching us about designing time intelligence patterns and using #DAX functions.

In this Monkey Shorts, I look at a simple #Excel #PowerPivot trick which helps: ✅ Prevent users from accidentally adding a "foreign key" to a #PivotTable (resulting in cross filtering issues) ✅ Keep data organized ✅ Visibly identify tables with measures on them

Our first Vancouver #PowerBI and Modern #Excel meet-up of 2026 starts at noon today (Pacific Time)! Joseph Yeates will first show us what's new in Power BI, and then Reza Rad will talk about time-based #DataAnalysis and calculations. 📅 Sign up here :

By default, #MonkeyTools' Query Sleuth displays every query in your solution in the navigation Treeview. 🌳 But if you have a complex solution, the Treeview can get quite busy. This is where the “End Points Only” option helps. Learn more about Query Sleuth at mkyt.ca/querysleuth. #Excel #PowerQuery

In this new video, I tackle how to reliably identify price changes over time using #PowerQuery. 📈 Using a practical dataset, I walk through 3 common techniques: ➡️ Index -1 approach ➡️ Prior Row Merge method ➡️ Using the Group By clause www.youtube.com/watch?v=vu0H... #DataAnalysis #Excel

Recently, I walked a student through a #PowerQuery solution, showing how to: ✅Extract the correct year from a header section ✅Isolate it as its own value ✅Merge it back into the transaction data before converting everything into proper dates The result? Accurate timelines w/out manual #DataCleanup.🧵

In this Monkey Shorts, I show how to get your #PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. 🧙 www.youtube.com/watch?v=Sa-z...

The one and only @humblestmvp.bsky.social will be presenting at our Vancouver #PowerBI and Modern #Excel meet-up on Feb 5! 😎 He's been testing #AITools for #FinancialModeling and will be sharing the highs and lows of this journey. RSVP here to join us:

Monkey Tools' handy GetMonthEnds function allows you to enter 2 dates and it returns a single-column table of all Month End dates between the provided dates. It’s nice and simple, and saves you from having to write the function yourself! 🙊 Learn more at mkyt.ca/getmonthends #PowerQuery #Excel

Time to check your inbox because he first newsletter of 2026 has been sent! 📩 Not subscribed? Sign up today at xlguru.ca/newsletter and we'll send you our free "DIY BI" eBook series to say thanks. 📕📗📘📙

In our last AKA session of 2025, a student asked the question that always follows a great #Excel or #PowerBI report: “Okay… but how do I update this every month without breaking it?” 😨 I broke the answer into three real-world update strategies using #PowerQuery. 🧵

Limiting the data that appears within a worksheet using a filter helps focus your analysis, but if you use the FILTER function you can go one step farther. In this movie, I’ll show you how to limit the columns that appear in a FILTER formula’s results so you get exactly the data you need.

In this video, I demonstrate how to use #PowerQuery to perform approximate matching when working with multiple criteria. Inspired by a student question, I'll walk through the solution using a fictitious employee salary dataset: www.youtube.com/watch?v=ZZC7... #Excel #PowerBI #DataPreparation

Not satisfied with Compact Form for your #Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, I'll show you how to modify your #PivotTable defaults: www.youtube.com/watch?v=eCut... #DataAnalyticsTools #BusinessIntelligence

Good to know!

Our first Vancouver #PowerBI and Modern #Excel meet-up of 2026 is on Jan 22. 📆 Time-based analysis and calculations are the most common calculations, and sometimes challenging, but our good friend @rezarad.bsky.social is here to help! 👍Sign up here to join us:

Unsure what Monkey Tools can actually do for you? 🐵⚒️ I have a FREE Using Monkey Tools course available through our @Skillwave.Training site, where I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course #BusinessIntelligenceTools

Join me and the Data Monkey as we explore how to enhance an #Excel #PowerPivot #DataModel to handle commissionable items. This video walks through the practical process of retrofitting an existing data model and when to use #DAX vs #PowerQuery:

If you have an Excel workbook that contains images, there is a way to make all of those images available through File Explorer. In this video, I'll show you how to get at them! youtu.be/fhfidzla64U

In our last AKA session of 2025, an attendee raised a deceptively simple question: “Why does Excel keep calling my column ‘Sum of Amount’ and can I stop it?” 😩 @excelguru.ca used this moment to explain how #Excel automatically assigns aggregations when numeric fields hit a #PivotTable. 🧵

Do you typically spend a bunch of time trying to position your slicers in an #Excel report "just right"? Ever been frustrated with those perfectly placed slicers moving around as you slice or update your #PivotTable?😡 This will definitely help you out: www.youtube.com/watch?v=xTBj... #DataAnalysis

Often, the reason we are trying to trace a query’s dependency chain is because we need to make a change to a child query, and want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right in the editor, without opening #PowerQuery! 🤯 Learn more: mkyt.ca/querysleuth

We've sent out our last newsletter of 2025! 😁 If you're not already subscribed, sign up at xlguru.ca/newsletter and get the latest content from our experts, what's new in #Excel and #PowerBI, and info on courses, events, and specials. We'll also send your our free 'DIY BI' eBook series! 📚

When notes are added to a table generated by #PowerQuery in #Excel, refreshing the data can cause those notes to shift and no longer align with the correct records. This video walks through why this happens and how to fix it: www.youtube.com/watch?v=Hg1x... #DataAnalytics #BusinessIntelligence

In a recent AKA session, a student asked “Why is my PivotTable giving me weird blanks and not calculating month-over-month changes properly?” I immediately spotted the red flag. 🚩 Instead of jumping straight to formulas, I explained why data normalization matters. Then came the teaching moment.🧵

In this Monkey shorts, I demonstrate how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG... #ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence

Merry Christmas and Happy New Year everyone! Here's a fun little project to give you a laugh over the holidays. 🙉🎶 A big thank you to the @unpivotshow.bsky.social team for gifting us this song:

When #DataModeling in #Excel, do you prefer to create a separate (disconnected) table to hold your measures? Get the Measure Table Monkey to do it for you! Simply provide a table name, click OK, and then hide a column. 😎 Learn more about it at mkyt.ca/measuretbl #PowerQuery #DataAnalytics

Moving, copying, and deleting worksheets in your Excel workbooks helps you manage your data effectively. In this movie, I'll show you how to perform all of those tasks efficiently, saving your time and effort for analysis instead of housekeeping. youtu.be/c14pHmyHJlA

In a recent AKA session, one attendee asked how to replicate #PowerBI-style colour grading inside a single #Excel PivotTable – without needing a second helper pivot to drive the colour rules. I was able to build a clever workaround. 🧵 1️⃣ Convert the colour logic measure into numeric values (0–3).

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

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

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

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!

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! 📚

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

Nothing better than hearing from happy students! ❤️

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

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

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:

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

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

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

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!

🚩Red Flags in a file- and a Chris (tmas) Angyal youtu.be/NqIs6Xhu_uo #Unpivot #Excel #PowerBI