Ken Puls, FCPA, FCMA

President of Excelguru, founding partner of Excel trainer, Microsoft MVP since 2006
Bluesky:

[Ken Puls, FCPA, FCMA @kpuls]

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 https://t.co/QDgWM7w9hD
#Excel #PowerBI #PowerQuery

[Ken Puls, FCPA, FCMA @kpuls]

We love hearing from happy Monkey Tools users! 🥰
The philosophy of of our Monkey Tools add-in is simple: Build better #Excel solutions, faster.
👉Get started with our FREE 2-week pro trial - go to https://t.co/62miFqhKFu

#DataModeling #DataAnalysisTools #DataAnalytics

[Ken Puls, FCPA, FCMA @kpuls]

📩 A new edition of our newsletter was sent earlier today if you're a subscriber!
If not, sign up at https://t.co/DWpRiB6oYV for expert content, what's new in #Excel and #PowerBI, info on courses, events, specials, and more. Plus, our free 'DIY BI' eBook series as a bonus gift!🎁

[Ken Puls, FCPA, FCMA @kpuls]

Today, I'm leading 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

[Ken Puls, FCPA, FCMA @kpuls]

📽️ If you weren't able to join last week's Vancouver #PowerBI and Modern #Excel meet-up, the recording is now available: https://t.co/Keg0ewgvzw
Microsoft MVP Richard Nero showed us how a few clicks can turn Excel workbooks into cloud based #SQL databases that fuel #AIAgents.

[Ken Puls, FCPA, FCMA @kpuls]

On the first Monkey Shorts episode, I showed the first #PowerQuery setting I change when I install #Excel - the query load destination. 🐵🩳 https://t.co/ZjMeccegEZ

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools

[Ken Puls, FCPA, FCMA @kpuls]

One hour to go until our Vancouver #PowerBI and Modern #Excel meet-up! Many will argue Excel is not a database. Well, Richard Nero will show how in a few clicks you can turn Excel workbooks into cloud based #SQLServer databases that fuel #AIAgents.
https://t.co/lcN4y4h5re

[Ken Puls, FCPA, FCMA @kpuls]

Often, the reason for tracing a query’s dependency chain is to make a change to a child query, and you want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right within the editor, without opening #PowerQuery! 🤯 https://t.co/U8iNTzmeBs

[Ken Puls, FCPA, FCMA @kpuls]

Wow - a former student emailed out of the blue the other day to share a success story. 🤩 #PowerQuery for the win!

[Ken Puls, FCPA, FCMA @kpuls]

Are your UTC transaction dates showing up on the wrong day in your reports? 📆🕛 In this step-by-step tutorial, I demonstrate how to convert UTC timestamps into local dates using #PowerQuery, while accounting for daylight saving time (DST): https://t.co/5mUVzJSwAy
#Excel #PowerBI

[Ken Puls, FCPA, FCMA @kpuls]

While Monkey Tools won't help you build a LAMBDA function, it definitely makes it easy to inject them into your #Excel workbook. 🙌 See how to use this FREE Monkey Tools feature to both store and inject LAMBDA functions into your workbooks: https://t.co/SqdAk2HqhN
#ExcelTips

[Ken Puls, FCPA, FCMA @kpuls]

I've always said it: #PowerQuery changes lives! I recently heard from someone who had taken a course with me 10 years ago, which turned out to be a turning point in his career. 😃

[Ken Puls, FCPA, FCMA @kpuls]

See what's new this month in #Excel, including the ability to name tables at time of creation now being available to all Windows users (not just Insiders): https://t.co/2RJA1KYp8K

[Ken Puls, FCPA, FCMA @kpuls]

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: https://t.co/uX60jmRY9B
#PowerQuery

[Ken Puls, FCPA, FCMA @kpuls]

Are you a newsletter subscriber? If so, better check your inbox! 📧
If not, sign up at https://t.co/DWpRiB6oYV 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 @kpuls]

Need to display revenues and expenses as positive values in your #Excel #PivotTable while still calculating the correct profit or loss? Use #DAX measures to flip the signs of revenue values w/out changing expense values, and keep the bottom-line accurate: https://t.co/XP6iJ4Jpo8

[Ken Puls, FCPA, FCMA @kpuls]

I'm back home after an amazing trip to Sofia for Bulgaria Excel Days, and wanted to share a few pictures. This is always my favourite event of the year, and I absolutely love teaching in person connecting with fellow #Excel enthusiasts!

[Ken Puls, FCPA, FCMA @kpuls]

A student replaced Not A Number values using #PowerQuery but the query still showed errors. My fix? Replace NaN as text AFTER promoting headers but BEFORE setting data types. If it's already been converted, change the column to text, replace the values, and then convert it back.

[Ken Puls, FCPA, FCMA @kpuls]

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! In this video, I'll show you how I added the "Detect Data Types" button to the Power Query QAT. 🛠
https://t.co/jgLMqiOyK2

[Ken Puls, FCPA, FCMA @kpuls]

If you work with #Excel, chances are you deliver your files to someone else. On Nov 26, Laura Szepesi will present on design principles and clever workarounds you can use immediately for creating #ExcelReports that your users don’t just like, but love! 😍
https://t.co/gFhOHiGYWC

[Ken Puls, FCPA, FCMA @kpuls]

Are you based in BC and looking to expand your #Excel and #PowerBI knowledge? Your organization could qualify for funding to help cover either in-person or on-demand training through our @skillwave_ learning platform!

#BusinessIntelligence #DataAnalyticsTraining #DataModeling

[Skillwave Training @skillwave_]

We recently had a corporate client apply for the BC Employer Training Grant through @WorkBC, to help cover the cost of some team training. 💵 It's available to organizations of all sizes and you could get up to $300,000! Check out the program details at https://t.co/cdhukrjCA9