Ken Puls, FCPA, FCMA

Delivering expert training BY humans, FOR humans, Excelguru is dedicated to unlocking your team’s potential through: 🔹On-site workshops 🔹Online coached courses 🔹On-demand video courses Contact us today for training options at excelguru.ca #Excel #PowerBI #PowerQuery

It's no secret that the #PowerQuery editor locks your #Excel instance while it's open. This means that you can't change or select a different worksheet while using Power Query. In this video, I'll give you some alternate methods of interacting with Excel: youtube.com/watch?v=bKBeRC…

In today’s data-driven world, ensuring #PowerBI reports are accessible to all users is not just an ethical responsibility but a fundamental necessity. At our April 16 meet-up, Juliana Smith will provide practical strategies for embedding accessibility. ♿️📊meetup.com/vancouver-powe…

One of my favourite tricks is to create a “From Folder” solution which avoids hard-coding a file path, instead pulling it dynamically via our fnGetParameter setup. The SmartFolder Monkey does it all without triggering the formula firewall error!🎉 See how: mkyt.ca/sfmonkey

📣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, specials, and the latest expert content. We'll also send our free 'DIY BI' eBooks! 📚

I recommend asking the client to set up their #PowerBI tenant and create a login for me to publish into their environment. That way, when the engagement wraps up, it's simply a matter of reassigning access - no messy transitions, no data exposure risk, no awkward conversations.

The recording from last week's Vancouver #PowerBI and Modern #Excel meet-up is up: youtube.com/watch?v=69Cl94… We learned about what's new in PBI with Joseph Yeates. Then, George Mount led a hands-on session about creating AI agents and workflows to streamline #DataAnalysis. 🤓

Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎The Data Monkey and I will show you how in this latest episode of Monkey Shorts! youtube.com/watch?v=PazQmz… #Excel #PowerBI #DataAnalyticsTools

@contextures Thanks Deb!

Double congratulations, Ken!

One hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates will 1st show us what's new in PBI, and then George Mount will present on building practical AI agents and workflows using #Copilot and #PowerAutomate. 🤖 RSVP here: meetup.com/vancouver-powe…

Great tips!

I'm super proud to be a finalist it 2 categories and part of this amazing group of contenders! Public voting is open until April 30.

Ever wanted to: ⏱Time all queries in a refresh to see which of your child queries are impacting your load time the most? ⏳Create 2 queries and compare to see which loads faster? That is exactly what Monkey Tools' TimeSleuth helps you achieve! Learn how: mkyt.ca/timesleuth

Ever filtered an #Excel #PivotTable and noticed that dates with no sales suddenly disappear? 😟 A student asked me: "Do I need to write a complicated #DAX measure to keep empty dates visible in my report?" The good news: you don’t! 😀 Here's what you do: youtu.be/jhc_L2b0Ml0

Nice use of conditional formatting - one of my favourite #Excel tricks!

And thank you to @ExcelSummit for once again running these awards!

What a great way to start off the week! 🎉 The finalists for this year's Global #Excel Awards have been announced and I'm super proud to be included: 🌟Monkey Tools for Best Excel Add-in 🌟Ken Puls for Training Provider of the Year 🗳 Voting now open at: globalexcelsummit.com/global-excel-a…

During an AKA session, I revealed a critical #PowerBI setting that can bloat your file size with hidden tables: auto date/time intelligence. 🗓️ Either mark your calendar table as a proper date table, or uncheck the “Auto date/time” setting in Options > Current File > Data Load.

I wrapped up the week by leading a course for @cpa_bc on using #DAX in #PowerPivot for gaining enhanced #DataInsights. E.g. If you have to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have.💡

It is pretty common to use the drop down arrows 🔽 when filtering content in #PowerQuery. But do you pay attention to what Power Query actually does when you do this? 🫣 I'll show how can get burned, as well as how you can take granular control of filters: youtube.com/watch?v=BeOpEL…

There’s a lot of talk about #VibeCoding. 💻 As Jan Karel Pieterse understands it, this is letting AI do the programming based off descriptions you give. On April 2nd, he’ll demo how he went about “programming” his new Rule Manager for #Excel add-in: meetup.com/vancouver-powe…