Ken Puls, FCPA, FCMA
@kpuls
Followers
7K
Following
3K
Media
2K
Statuses
8K
President of Excelguru, founding partner of https://t.co/85mDjDxAlG, Excel trainer, Microsoft MVP since 2006 Bluesky: https://t.co/bslVOSHd0H
Nanaimo, BC, Canada
Joined February 2009
I wrapped up the week with a great day of #PowerQuery training for @cpa_bc . If you have a report that you update regularly, you can set things up so that you just save the new data, refresh your query with a SINGLE CLICK, and your chart or visual is updated! 🔄📊 #Excel #PowerBI
0
1
3
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? 🤔 Wonder no more, as I'll show you how! Check out how I added the "Detect Data Types" button to the Power Query QAT:
0
0
1
I have pleasure to share with you the interview we made with Mike Koss - one of the Original Minds behind #Microsoft #Excel creation, part of the first team of programmers developed Excel 1.0 in 1985 He was the Honorary Guest of Bulgaria Excel Days 2025. https://t.co/wbW0PtM0Hc
1
2
5
An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up gets underway! Spreadsheet enthusiast Alison Pollecutt is willing to bet that there are things you're doing manually that "Go To Special" could help you do a lot quicker. 😲 RSVP at
meetup.com
**SESSION TRACK:** Excel **SESSION OUTLINE:** “Go To Special” is a tool that you might easily miss amongst the many other options on the Excel ribbon. Let’s face it, what
0
2
2
When you first open Query Sleuth in our Monkey Tools #Excel Add-in, you’ll notice that your queries are colour coded with up to four different colours: 🟠🟡🔵🟢 This adds a bit of extra insight around the query load destinations. Learn more at https://t.co/U8iNTzmMr0
#PowerQuery
0
0
0
Great overview!
Create multiple dependent drop down lists in Excel, based on named tables Read more 👉 https://t.co/8vx27Sr3Ik
1
0
2
Sweet trick!
Change one slicer in Power BI and the other one filters itself...frustrating, right? But you can make your slicers non-sticky, so when you change one, the others reset automatically as shown in the gif. Makes the whole experience more natural for stakeholders. I’ve explained
0
0
0
A new student joined my last AKA session with a familiar #Excel headache: “Every month I download new CSVs from our billing system – and every month I spend hours cleaning them up.” 😭 I walked her through how #PowerQuery can automate every step in a single refreshable query.
0
1
2
For local folks in Nanaimo, BC: I'm leading a FREE hands-on workshop at @VIUniversity on Dec 4. It's designed for accounting and finance students, helping them build essential #Excel skills for real-world #FinancialAnalysis and reporting. 📉 Sign up here:
eventbrite.com
Learn Excel with expert Ken Puls! Hands-on workshop for accounting students, build real financial statements & skills employers love.
0
4
6
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. In this episode of Monkey Shorts, I'll demonstrate a super-cool black magic technique that allows you to do exactly that.🧙♀️ https://t.co/n2d6qw1URf
#Excel #PowerBI
0
1
3
Check out what's new this month in #Excel, including these 2 features in the Windows version: 🟢 #PivotTables #SPILL! (similar to the experience in Dynamic Arrays) 🟢 Formula by Example (previously only in the Web version) https://t.co/iBTI3IMN1D
techcommunity.microsoft.com
This month, look for Agent Mode in Excel (Frontier) in the Tools menu of Copilot for Excel. Additionally, PivotTable #SPILL and accessibility assistant...
0
3
2
On Nov 20, learn how to manage the everyday chaos of supply chain spreadsheets with simple yet powerful #Excel tricks! Faraz Shaikh will share real-world tips to 🧹clean messy data, 🔎track stock smartly , and 📊visualize key insights Sign up here:
meetup.com
**SESSION TRACK:** Excel **SESSION OUTLINE:** Manage the everyday chaos of supply chain spreadsheets with simple yet powerful Excel tricks! In this fast-paced, practical s
0
0
0
I LOVE hearing from happy students! ❤️
Another happy student! ⭐️⭐️⭐️⭐️⭐️ Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by @kpuls. Learn how to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll at https://t.co/mT2zxDPIQk
0
0
0
It was the final day of my in-person #SelfServiceBI Boot Camp in Munich. The first part of the day was focused on #DAX and Calendar Intelligence. 📅 We then finished off with building and sharing dashboards with #PowerBI, and how to choose when to use Power BI or #Excel. 💪
0
0
1
The Basic Explicit Measure Monkey provides a simple interface to build basic #DAX measures without writing any code. 😎 It also gives aggregation choices based on your data types, shows the DAX written, and lets you set default measure formats. Learn more: https://t.co/5OBk5TCAA2
0
0
0
The latest edition of our newsletter is out! 📧 Stay up-to-date on what's new in #PowerBI and #Excel, updates to Ken's Monkey Tools add-in, content from our experts, and info on specials, events, and courses - go to https://t.co/arOsOF8na6 Plus, get our free 'DIY BI' eBooks! 📚
0
0
0
Today is Day 2 of my live Munich #SelfServiceBI Boot Camp, where we are focusing on #PowerPivot and #DataModeling. A key takeaway is that Facts and Dimensions should always live in separate tables. A fact is something that can be aggregated! A Dimension is how we slice our facts!
0
0
0
Another great event for the books!
✨Another unforgettable edition of Bulgaria #Excel Days has now become part of history. The beautiful emotions from the event are still fill my heart, but it’s time for final words and for gratitude. https://t.co/hSe9PVgtdn
0
1
3
In an Ask Ken session, I had a spontaneous question about budgeting and #FinancialForecasting techniques. The discussion resulted in a nice forecast sheet built against a #DataModel. It was fully dynamic so that it would update upon refresh, forecasting the next 2 years of sales!
0
0
0