Ken Puls, FCPA, FCMA

8K posts

Ken Puls, FCPA, FCMA

@kpuls

President of Excelguru, founding partner of https://t.co/85mDjDxAlG, Excel trainer, Microsoft MVP since 2006 Bluesky: https://t.co/bslVOSHd0H

Nanaimo, BC, Canada Katılım Şubat 2009

286 Takip Edilen7.1K Takipçiler

Sabitlenmiş Tweet

Ken Puls, FCPA, FCMA@kpuls·2 Mar

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

English

476

Ken Puls, FCPA, FCMA@kpuls·21h

When importing CSV files with a date-time field, #PowerQuery can't convert directly to a date type. It throws an error unless you: 1⃣ Convert to date-time 2⃣ Add a step to strip the time I confirmed for a student that there's no shortcut to eliminate this two-step dance. 👢🎶

English

176

Ken Puls, FCPA, FCMA@kpuls·3d

That's a wrap, London! ✋️ Today was the final day of my live #SelfServiceBI Boot Camp. The first part of the day was focused on #DAX and Calendar Intelligence. 📅 We then explored building and sharing dashboards with #PowerBI, and how to choose when to use Power BI or #Excel.

English

180

Ken Puls, FCPA, FCMA@kpuls·3d

Sometimes, you want to browse Microsoft's official documentation for #PowerQuery's function library when writing a query. 📖 Maybe you need to discover a function, or maybe you need more info on how it works. Here, we'll look at 2 options: youtube.com/watch?v=GX5zxy… #Excel #PowerBI

YouTube

English

164

Ken Puls, FCPA, FCMA@kpuls·4d

@ddalgleish It would have been amazing to have you there, Deb!

English

Debra Dalgleish@ddalgleish·4d

Thanks for sharing your photos, Ken! Wish I’d been at that “old guard” table, to catch up with everyone!

Ken Puls, FCPA, FCMA@kpuls

I've been having an amazing week in London at @ExcelSummit. I pre-gamed the conference with some of the Excel "old guard" and went out with Wyn Hopkins and Cristiano Galvao another evening. Nothing better than catching up with friends in person! 😄

English

163

Ken Puls, FCPA, FCMA@kpuls·4d

@ExcelSummit A huge congratulations to all of the winners! 🙌 And a great big "thank you" to all of the organizers for putting on such an amazing event again this year.

English

Global Excel Summit@ExcelSummit·4d

🏆 𝗪𝗘 𝗛𝗔𝗩𝗘 𝗢𝗨𝗥 𝗚𝗟𝗢𝗕𝗔𝗟 𝗘𝗫𝗖𝗘𝗟 𝗔𝗪𝗔𝗥𝗗𝗦 𝗪𝗜𝗡𝗡𝗘𝗥𝗦! 👏🥳 Thank you to everyone who participated in the process, whether it was nominating your favourites or choosing the winners! #excel #microsoftexcel #globalexcelsummit

English

242

Ken Puls, FCPA, FCMA@kpuls·4d

English

367

Ken Puls, FCPA, FCMA@kpuls·4d

Learn to make your #DAX more reusable and maintainable using: ✅Calculation groups ✅User functions Joseph Yeates will walk through practical patterns for reducing duplicated logic, simplifying measure design, and building more scalable #PowerBI models: meetup.com/vancouver-powe…

English

230

Ken Puls, FCPA, FCMA@kpuls·5d

Yesterday was Day 2 of my live #SelfServiceBI Boot Camp in London, which focused on #PowerPivot and #DataModeling. A key takeaway is that Facts and Dimensions should live in separate tables. Facts are something that can be aggregated! 🧮 Dimensions are how we slice our facts! 🔪

English

147

Ken Puls, FCPA, FCMA@kpuls·5d

With Monkey Tools, you no longer have to change the load destinations of your #PowerQuery queries individually! Simply select the queries, change the destination, click Update Load Destinations, and go grab a coffee while our Sleuth handles it. ☕🐵 mkyt.ca/destsleuth

English

105

Ken Puls, FCPA, FCMA@kpuls·6d

I've been having an awesome tine leading my 3-day live #SelfServiceBI Boot Camp in London this week! 👨‍🏫 One of the first things 2e covered was the #BusinessIntelligence ecosystem, explaining how we can use #Excel, #PowerQuery, #DAX, and #PowerBI together for robust reporting.

English

164

Ken Puls, FCPA, FCMA@kpuls·6d

I'm really proud to have partnered with @getgoskills on these #Excel courses!

GoSkills@getgoskills

PivotTables. Dashboards. Power Query. Tableau. 🤓 If those skills are sitting on your “I should probably learn this” list (and you should!), this learning path is for you. 🧵 Here are 5 GoSkills courses to help you level up your #Excel and data analysis game:

English

144

Ken Puls, FCPA, FCMA@kpuls·6d

A question came up in an AKA session that resonated with others: what do you do when #AIGenerated #VBA code seems to work – but is quietly making things worse? 🫣 I spotted the real issue immediately. ⚠️ The lesson: AI can be a powerful coding assistant but it needs context.

English

200

Ken Puls, FCPA, FCMA@kpuls·18 May

Following up on my last video, I'll now take the 9 #PowerQuery join types from concept to real-world demo. 💪 See how each behaves when matching data across multiple columns without needing to manually create a combined key: youtu.be/Cn-3QHO-Sy0 (Works in #Excel and #PowerBI.)

YouTube

English

451

Ken Puls, FCPA, FCMA@kpuls·15 May

When writing formulas in the #PowerQuery formula bar, you'll occasionally see helpful tooltip text that indicates that there are 1 of x arguments for the function... But when you try to click on item 2, it disappears! 😱 See how to navigate through to it: youtube.com/watch?v=nfcoI-…

YouTube

English

279

Ken Puls, FCPA, FCMA@kpuls·14 May

I'm super excited to have my good friend Jon Peltier back to present at our June 4 meet-up! 🥳 He's going to describe some of the challenges with using #DynamicArrays for Dynamic #ExcelCharts, and how to work around them. 📊 Sign up here: meetup.com/vancouver-powe… #Excel

English

287

Ken Puls, FCPA, FCMA@kpuls·13 May

While it's always been possible to create a table from #PowerPivot-backed #DataModels, it has required some black magic and #DAX knowledge to make it happen. The DAX Table Monkey builds it for you with just a few clicks. 🐵 Learn more about it at mkyt.ca/daxtable #Excel

English

155

Ken Puls, FCPA, FCMA@kpuls·12 May

I'm proud to have my #Excel training included here! As a small business owner myself, I can vouch for the importance of learning theses types of skills.

GoSkills@getgoskills

Because running a #SmallBusiness means learning everything. 😀 That’s why we rounded up 20 of the best courses for small business owners on GoSkills.com — from leadership and finance to AI, Excel, marketing, and productivity. Follow the 🧵 below! 👉 Access the full roundup here: goskills.com/resources/best…

English

234

Ken Puls, FCPA, FCMA@kpuls·12 May

@getgoskills Thanks for including me on the list here!

English

GoSkills@getgoskills·12 May

🧵 20 Best Courses for #SmallBusiness Owners (4/6) Essential Apps & AI courses: ✅ Google Drive & Apps ✅ Microsoft Excel – Basic & Advanced ✅ Generative AI for Small Businesses

English

GoSkills@getgoskills·12 May

English

286

Ken Puls, FCPA, FCMA@kpuls·12 May

Are you a newsletter subscriber? If so, time to check your inbox! 📧 If not, sign up at xlguru.ca/newsletter to get the latest in expert content, what's new in #Excel and #PowerBI, info on our courses, events, and promotions, AND our free 'DIY BI' eBook series! 📖

English

103

Ken Puls, FCPA, FCMA@kpuls·12 May

While Microsoft is deprecating #PowerBI custom data types, I showed students a 3rd-party add-in that allows you to define custom data types from #Excel tables or PBI semantic models on SharePoint. You can then expand any value to see its properties. See buff.ly/40TR5Kb

English

148

Keşfet

@ddalgleish @ExcelSummit @getgoskills @elonmusk @BarackObama @taylorswift13 @cristiano @BillGates