Ken Puls, FCPA, FCMA

8K posts

Ken Puls, FCPA, FCMA banner
Ken Puls, FCPA, FCMA

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
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
Ken Puls, FCPA, FCMA tweet media
English
0
1
2
476
Ken Puls, FCPA, FCMA
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. 👢🎶
Ken Puls, FCPA, FCMA tweet media
English
0
0
0
176
Ken Puls, FCPA, FCMA
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.
Ken Puls, FCPA, FCMA tweet mediaKen Puls, FCPA, FCMA tweet media
English
0
0
0
180
Ken Puls, FCPA, FCMA
@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
0
0
0
35
Global Excel Summit
Global Excel Summit@ExcelSummit·
🏆 𝗪𝗘 𝗛𝗔𝗩𝗘 𝗢𝗨𝗥 𝗚𝗟𝗢𝗕𝗔𝗟 𝗘𝗫𝗖𝗘𝗟 𝗔𝗪𝗔𝗥𝗗𝗦 𝗪𝗜𝗡𝗡𝗘𝗥𝗦! 👏🥳 Thank you to everyone who participated in the process, whether it was nominating your favourites or choosing the winners! #excel #microsoftexcel #globalexcelsummit
Global Excel Summit tweet media
English
2
0
1
242
Ken Puls, FCPA, FCMA
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! 😄
Ken Puls, FCPA, FCMA tweet mediaKen Puls, FCPA, FCMA tweet media
English
0
0
4
367
Ken Puls, FCPA, FCMA
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
0
0
0
230
Ken Puls, FCPA, FCMA
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! 🔪
Ken Puls, FCPA, FCMA tweet mediaKen Puls, FCPA, FCMA tweet media
English
0
0
0
147
Ken Puls, FCPA, FCMA
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
Ken Puls, FCPA, FCMA tweet media
English
0
0
0
105
Ken Puls, FCPA, FCMA
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
0
0
1
200
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
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 video
YouTube
English
0
0
0
451
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
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 video
YouTube
English
0
1
2
279
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
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
0
1
4
234
GoSkills
GoSkills@getgoskills·
🧵 20 Best Courses for #SmallBusiness Owners (4/6) Essential Apps & AI courses: ✅ Google Drive & Apps ✅ Microsoft Excel – Basic & Advanced ✅ Generative AI for Small Businesses
GoSkills tweet media
English
2
0
0
24
GoSkills
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…
GoSkills tweet media
English
1
1
2
286
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
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! 📖
Ken Puls, FCPA, FCMA tweet media
English
0
0
2
103
Ken Puls, FCPA, FCMA
Ken Puls, FCPA, FCMA@kpuls·
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
Ken Puls, FCPA, FCMA tweet media
English
0
0
0
148