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 excelguru.ca Nanaimo, BC, Canada Joined February 2009-
Tweets8K
-
Followers7K
-
Following291
-
Likes3K
By default, when you unpivot a set of data in #PowerQuery, all null records are suppressed. But what if you need them in your unpivoted data set? 🤷♀️I'll show 2 different methods and discuss the impacts of each: youtube.com/watch?v=-j_qCu… #Excel #PowerBI #DataCleaning #DataAnalysis
At an AKA session, I helped a student rebuild a solution that had outgrown the original architecture. They ended up with a better designed #DataModel and a set of simpler #DAX formulas they can expand upon. 💡 Get AKA access with my #SelfServiceBI Academy: skw-t.com/ssbi
I'm stoked for the Global Excel Summit next May, and early bird tickets are now available for 30% off! 🐦Register for a Premium Conference + #SelfServiceBI Boot Camp ticket and choose which session to attend: ➡️ Munich in Oct 2025 ➡️ London in May 2026 See globalexcelsummit.com/product/premiu…
Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course at @skillwave_ where I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course #ExcelTools #DataAnalyticsTools
“Go To Special” is a tool that you might easily miss on the #Excel ribbon. Well, there likely are things you do manually that it could help you do a lot quicker. On Nov 6, Alison Pollecutt will introduce us to its simple magic. RSVP here to join us: meetup.com/vancouver-powe…
A big thank you to @GregDecklerfor presenting at last week's Vancouver #PowerBI and Modern #Excel meet-up! He helped us rethink the “conventional wisdom” or “best practices” of #DAX that don't always apply. 🤔Catch the recording here: youtu.be/f39fTR4ITtg
While #PowerQuery has a super easy way to merge columns, there is no easy-to-use UI command which allows you to merge multiple rows into a single cell. 🤔 In this Monkey Shorts, you'll see how we can leverage a little bit of M code to make it happen! youtube.com/watch?v=G8X9NV…
I'm wrapping up the week by teaching for a private client on writing DAX formulas for #Excel #PowerPivot. What is #DAX? It's the language used to create powerful measures that allow to aggregate your data and gain better #DataIsights. Here's an example to generate cost by line.🤓
An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up! Joseph Yeates show us what's new in PBI. Then, Greg Deckler will help us rethink how we use DAX outside of the “conventional wisdom” or “best practices”. 🤫 Sign up here: meetup.com/vancouver-powe…
Our Monkey Tools add-in provides a broad set of features specifically for working with #PowerQuery and #DataModeling in #Excel & #PowerBI. The tools are divided into 2 categories: 🐵Monkeys - make things happen 🔎Sleuths - figure out what's happened Go to mkyt.ca/features
If you’ve worked with #Excel for any length of time, we’re sure you’ve ended up with a file you need to update monthly… 📆🔄 In one of our AKA sessions, I showed how to use #PowerQuery to automate rolling a reconciliation report forward for the next month’s entry.
I'm excited to be taking my live #SelfServiceBI Boot Camp to Munich from Oct 27-29, 2025! Not just for #DataAnalysts, managers, or business leaders, it’s for anyone looking to harness the #BusinessIntelligence tools in #Excel and #PowerBI. Enroll today at xlguru.ca/ssbi-munich
DYK that when merging columns in #PowerQuery, the behaviour is different depending on whether you trigger the command from the Transform or Add column tabs? 🤯 Let's explore why adding a new column may be a better option than transforming existing ones: youtube.com/watch?v=b8ymV7…
We're looking forward to Aditya Kumar Darak, presenting at our Oct 2 Vancouver #PowerBI and Modern #Excel meet-up! He's sharing about his journey with AI, as he moved from viewing it as an adversary to instead approaching it as a teammate. 🤖 RSVP here: meetup.com/vancouver-powe…
We have a saying amongst Excel pros, “Friends don’t let friends merge cells.” 🙈 Monkey Tools includes several #Excel feature improvements to build a better user experience. Most expand Excel’s functionality, but a few actually replace Excel’s defaults: mkyt.ca/improve-excel
Harness the full potential of the #SelfServiceBI tools in #Excel and #PowerBI! There's still time to enroll in my in-person Boot Camp in Munich from Oct 27-29! This small group, hands-on training gives you a TON of access to the instructor (me!). Go to: xlguru.ca/ssbi-munich
In a recent AKA session, someone asked me to review their #PowerQuery based solution to see if it could be made more efficient. I tried modifying their custom function with a Sample Transform, but a version generated entirely via the UI was faster - despite having more steps!🤖
In this episode of Monkey Shorts, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒 youtube.com/watch?v=3hPMX0… #Excel #PowerBI #DataPreparation #DataAnalyticsTools
How can you automate the process of creating your Inventory Count Sheet in #Excel so you can distribute it to your warehouse stock takers? In an AKA session, I helped a client build a re-usable solution to this issue, so they no longer have to manually save and prepare the file.

Marco Russo @marcorus
26K Followers 470 Following Consultant, speaker, book writer, mentor. Business Intelligence with Power BI, Analysis Services, and Power Pivot. Other info on https://t.co/hYayga42y6
David Eldersveld @dataveld
13K Followers 1K Following Data & Analytics, Copilot, MSFT Fabric & Power BI 📈, Solution Engineer at #Microsoft (viewpoints on Twitter are my own), former 4x Microsoft MVP, #GoBlue
Christopher Webb @cwebb_bi
19K Followers 2K Following Member of Fabric CAT team. Blog: https://t.co/dIk6f7ezh5 MS Employee, but my tweets are my own.
KratosBI @KratosBi
9K Followers 2K Following Home of the Data gods. Our goal is to turn YOU into a data god too! My opinions are my own and do not represent any company or person.
Guy In A Cube @GuyInACube
29K Followers 2K Following Just doing the work and teaching you the clicks of #MicrosoftFabric including #PowerBI. Videos every Tuesday, Wednesday and Thursday and Saturday live streams!
Wyn - Now on BlueSky @wynhopkins
11K Followers 283 Following https://t.co/FkBygilgam | Microsoft ⓂVP | Author | Speaker | Power BI & Excel Developer & Instructor 🦋 https://t.co/fQXk2HqfOY
Reza Rad #PowerBI #Fa... @Rad_Reza
14K Followers 1K Following #Microsoft Regional Director, #MVP #Author #Trainer #Speaker #Consultant #PowerBI Co-Founder and CEO @RADACAD_com Co-Founder @difinityconf #PowerBISummit
Kasper de Jonge @Kjonge
10K Followers 762 Following Program manager at the @Microsoft Fabric CAT team Kasper On BI show on Youtube, Spotify and Itunes. Tweets are my own.
Bas (How to Power BI) @HowToPowerBI
21K Followers 228 Following Power BI reports that make a difference 🚀 training 600 k + followers in Power BI across social platforms 👉🏼https://t.co/lWIqE7UzQo https://t.co/lWIqE7UzQo
Chandoo.org @r1c1
28K Followers 145 Following Making you awesome in Excel, Power BI, data analytics & charting. One tweet at a time. Also, love mangoes, lego, cycling and coffee...
Ed Hansberry @ehansalytics
9K Followers 558 Following Christ follower first. Then family, and finally Power BI consultant 📊 @P3Adaptive. Also owns the best dog in the world. 🐶 Opinions are correct.
Mim @mim_djo
11K Followers 3K Following #MicrosofFabric user advocate, interests in Small Data & Self Service #Microsoftemployee since Dec 2023 , but my tweets are my own
Nikola Ilic @DataMozart
6K Followers 287 Following I'm making music from the data🎶 #PowerBI addict, Microsoft Data Platform MVP, Pluralsight Author, O'Reilly Instructor...Father of 2, Barça and Messi fan⚽
Tom Urtis @TomUrtis
51K Followers 14K Following Microsoft Excel MVP, Excel skills testing, project developer, trainer, author. Stanford & Michigan State athletics.
CrispEXCEL Training &... @Crisp_EXCEL
37K Followers 248 Following ⭐We are the best Excel Trainers in East & Central Africa.
Imke Feldmann @TheBIccountant
6K Followers 362 Following Power Query Fan, BI Consultant, Blogger, PBIUG Leader, Ex-Finance & Controlling Manager, accidental coder
Learn Excel to excel @exceltoexcel
78K Followers 150 Following Learn #Excel, #GoogleSheets with Daily #Office Tips Excel | Sheets Tips, Tricks, Tutorials, Lessons, and much more
Power BI Weekly @PowerBIWeekly
19K Followers 267 Following Your free weekly newsletter, all about @MSPowerBI. Subscribe at https://t.co/v0nbDsPrWx. Published every Tuesday. Powered by @endjin
Chandeep Chhabra @chandeep2786
6K Followers 48 Following Excel & Power BI consultant and content creator. Beware if you follow me - I rant occasionally.
Rotibenggali @rotibenggali001
0 Followers 63 Following
Don Wong @GordonYHuang
4 Followers 51 Following
Helen Jackson @HelenJacks66741
28 Followers 299 Following American Patriot to the end!! Adore my little daughter, dog mama, love God and my country. #2A#XPR#™️
MOHAMMED MURTUZA ALI @MDMURTUZAALI
5 Followers 636 Following
Ariezzz @Ariezzz50
10 Followers 202 Following
sich @sich214220
3 Followers 34 Following
Kimberly Jones @jones_kimb54095
1 Followers 67 Following
AEEB ALEZZI @ADAZ61390769
6 Followers 250 Following Interested in international financial and economic affairs
Charles Egbejimba @CharlesEgb85664
10 Followers 192 Following
Maksym Lohvinenko @mlohvinenko_dev
1 Followers 19 Following
Kashif Khan @MkaashifKhan
8 Followers 261 Following
Tim Sipe @timjsipe
83 Followers 139 Following I write about corporate finance, tools & techniques (Excel, Power BI, AI) along with my personal anecdotes. Mixed Judeo-Christian family & values, tech hobbyist
Borzak @BorzakovskyS
36 Followers 86 Following
aka ShKas @aka_Karl_Marx
1 Followers 32 Following
Emmy Jakes @Obiekweemma
157 Followers 763 Following I am a Very Curious, Very Creative, and Highly Ambitious Person. Data Analyst 📊 || Aspiring Entrepreneur
Anoj Paudel @APaudel90
134 Followers 869 Following
HelloMoto @0g_muck
19 Followers 523 Following
Diligent ICT solution... @DiligentTECH147
382 Followers 2K Following Diligent ICT solutions offers sustainable and reliable solutions to laptop repairs full-stack web development with python/design, graphics design & lot more🛠️
Tristin Durgan @tristin83211
104 Followers 3K Following
Desiree Boyle @DesireeBoy58015
63 Followers 2K Following
amir moezi @moezi_amir68436
0 Followers 2K Following
Yahya Sinwar The real... @bhittani5869
102 Followers 1K Following
Kawuk Kawuk @KawukK69693
3 Followers 123 Following
Ayodeji Jolaoso 🇳�... @dejinero
757 Followers 5K Following Omo lehin Jesu, Husband, Lawyer, Data and compliance analyst, Anime & movie lover, Gunner.
Mary🦄 FREE 🅾 �... @abretsunsk28249
23K Followers 94 Following Cute but a little wild 🌸 Here I share what I love to watch and do Tweet me at the link if you dare 💋
Adam Piotrowski @AdamPio98699311
12 Followers 336 Following
jfjoyner3 @jfjoyner3
121 Followers 364 Following Making small efforts to restore sanity to western civilization.
Karthick k @karthi14sep
77 Followers 184 Following
Fredrick Buabin @ik_clear
91 Followers 893 Following
arifbudiman1909 @arifbudima75879
1 Followers 167 Following
Gabrielle Eliana @GiavannaW58AA
48 Followers 2K Following
amri kuzan @AmriKuzan8184
5 Followers 242 Following
klayton robertson �... @greenturtle32
776 Followers 3K Following Fake people can't stand me. I piss them off. Autistic. he / him. #exvangelical #deconstruction #churchtoo #spiritualabuse #religioustrauma #bluecrew
Layefa 𓃵 @AbrahamT_E
854 Followers 5K Following Ijaw| #Bitcoin | #ETH | Proud Agricultural Economist| Sustainable Agriculture Enthusiast| Statistical Analyst| Loves music after God and family. 🥴Christian Guido @ChristianGuido
133 Followers 888 Following Databases, Analytics, and Web 💽📊🌐 | FL🐊 ➡️ TX🤠
JC 📊🏗 @jcvanbrunt
89 Followers 331 Following Power BI • Construction • Finance #GoHuskies☔️ #PurpleReign #SunsUp
DataNerd @DataNerd789
0 Followers 230 Following
Daniel Emmanuel Olami... @ExcelCraftsman
4 Followers 47 Following Turning spreadsheets into insights 📊 | Excel Specialist | Data Analysis & Visualization | Helping you work smarter with data
Peter Dzenkov @Kerrhigh
41 Followers 282 Following
John Sullivan @jlsullivan4580
79 Followers 624 Following
Marco Russo @marcorus
26K Followers 470 Following Consultant, speaker, book writer, mentor. Business Intelligence with Power BI, Analysis Services, and Power Pivot. Other info on https://t.co/hYayga42y6
David Eldersveld @dataveld
13K Followers 1K Following Data & Analytics, Copilot, MSFT Fabric & Power BI 📈, Solution Engineer at #Microsoft (viewpoints on Twitter are my own), former 4x Microsoft MVP, #GoBlue
Christopher Webb @cwebb_bi
19K Followers 2K Following Member of Fabric CAT team. Blog: https://t.co/dIk6f7ezh5 MS Employee, but my tweets are my own.
KratosBI @KratosBi
9K Followers 2K Following Home of the Data gods. Our goal is to turn YOU into a data god too! My opinions are my own and do not represent any company or person.
Guy In A Cube @GuyInACube
29K Followers 2K Following Just doing the work and teaching you the clicks of #MicrosoftFabric including #PowerBI. Videos every Tuesday, Wednesday and Thursday and Saturday live streams!
Wyn - Now on BlueSky @wynhopkins
11K Followers 283 Following https://t.co/FkBygilgam | Microsoft ⓂVP | Author | Speaker | Power BI & Excel Developer & Instructor 🦋 https://t.co/fQXk2HqfOY
Reza Rad #PowerBI #Fa... @Rad_Reza
14K Followers 1K Following #Microsoft Regional Director, #MVP #Author #Trainer #Speaker #Consultant #PowerBI Co-Founder and CEO @RADACAD_com Co-Founder @difinityconf #PowerBISummit
Kasper de Jonge @Kjonge
10K Followers 762 Following Program manager at the @Microsoft Fabric CAT team Kasper On BI show on Youtube, Spotify and Itunes. Tweets are my own.
Chandoo.org @r1c1
28K Followers 145 Following Making you awesome in Excel, Power BI, data analytics & charting. One tweet at a time. Also, love mangoes, lego, cycling and coffee...
Ed Hansberry @ehansalytics
9K Followers 558 Following Christ follower first. Then family, and finally Power BI consultant 📊 @P3Adaptive. Also owns the best dog in the world. 🐶 Opinions are correct.
Nikola Ilic @DataMozart
6K Followers 287 Following I'm making music from the data🎶 #PowerBI addict, Microsoft Data Platform MVP, Pluralsight Author, O'Reilly Instructor...Father of 2, Barça and Messi fan⚽
Tom Urtis @TomUrtis
51K Followers 14K Following Microsoft Excel MVP, Excel skills testing, project developer, trainer, author. Stanford & Michigan State athletics.
Christian Wade @_christianWade
7K Followers 433 Following Group product manager for Fabric/Power BI at Microsoft. Coined the term "clicky clicky draggy droppy data analysis". Tweets are my own.
Imke Feldmann @TheBIccountant
6K Followers 362 Following Power Query Fan, BI Consultant, Blogger, PBIUG Leader, Ex-Finance & Controlling Manager, accidental coder
Chandeep Chhabra @chandeep2786
6K Followers 48 Following Excel & Power BI consultant and content creator. Beware if you follow me - I rant occasionally.
Cristian Angyal @cristian_angyal
2K Followers 817 Following Project Manager turned into Data guy using #PowerBI | #PowerQuery | #DAX | Microsoft MVP | Romania #PowerBI and #Excel User Group founder | #Blockchain believer
Sandeep Pawar @PawarBI
5K Followers 1K Following Principal PM @ Microsoft Fabric CAT | 🇮🇳🇺🇲 https://t.co/ZDAcUyygbo | Tweets & opinions are my own
Paul Turley @paul_turley
4K Followers 491 Following Microsoft MVP, BI & Data Architect, 3Cloud Principal Consultant, Manager
Belinda Allen (She/He... @MsBelindaAllen
3K Followers 2K Following A (Microsoft) Data Platform MVP, Trainer, Author, and lover of Power BI, PowerApps and Flow. #PowerAddict
Kyle A. Mueller @KyleAMueller2
817 Followers 343 Following Power BI and PowerQuery nerd/evangelist at @TabularEditor Food enthusiast, constantly dreaming of leaving it all behind to open a food truck
ASAP Utilities @ASAPUtilities
372 Followers 20 Following ASAP Utilities makes YOU rock in Excel! Easy to use tools that save time and speed up your work in Excel.
Eras Tour Resell @ErasTourResell
316K Followers 26 Following fill out the form in our bio so we can get your tickets to another swiftie! ran by @ttwaswift @folklorewlw and @floellasversion
susan bayes @sue_bayes
1K Followers 955 Following Passionate about data, Data Analytics Power BI developer and data fixer. R, Python, SQL, Excel & database dev - ask questions, see patterns & solve problems.
Microsoft Excel Colle... @mecc_college
109 Followers 27 Following Enhance your Excel skills and logical thinking with fun, free challenges and competitions. Join the Microsoft Excel Collegiate Challenge today!
Alejandra Horvath @alejandrahorv
124 Followers 58 Following Empowering organizations & individuals automating reports, finding efficiencies. Training to optimize Excel & Google Sheets use. Opinions are my own.
Unpivot @UnpivotShow
34 Followers 8 Following A light hearted show about Excel, Power BI and other business data related topics.
Sheetcast @SheetcastDotCom
252 Followers 388 Following With Sheetcast, users can create fully customizable web apps in minutes, from within Excel!
UrBizEdge @urBizEdge
1K Followers 314 Following We are Nigeria's leading business data analysis firm. Visit https://t.co/TndMVXSUur to get some of our training resources for free.
Roland Szirmai @BILAnalytics
579 Followers 130 Following Useful tips and guides on how to master #PowerBI and create #insights. All of these through the eyes of a #BusinessAnalyst. Microsoft Data Platform MVP
Midterms are Nov. 3rd... @RandVegan
2K Followers 823 Following Vegan. Learning R, Bash, Vim, SCSS and now apparently basic lua
Global Excel Summit @ExcelSummit
14K Followers 38 Following The award-winning Microsoft Excel conference for finance and data professionals. Limited Early Bird tickets available now!
Rick de Groot @Rickmaurinus
1K Followers 199 Following Microsoft MVP | Blog https://t.co/qwx9m8DZhg | Become a Power Query Pro - Join 1000+ subscribers and transform your job: https://t.co/DZi4ztUjD3
Alex Kolokolov @KolokolovAlex
415 Followers 658 Following Data2Speak Inc Founder. I’ve been helping businesses turn complex reporting systems into professional management tools for 13 years
Excel Robot @ExcelRobot
188 Followers 285 Following Mission: to accelerate the world's transition to loving Excel as much as I do.
Computergaga | Alan M... @Computergaga1
19K Followers 5K Following 🏆Microsoft MVP 💡20+ years mastering Excel 🚀45M+ views on YouTube | Excel Tips | Courses ⬇️
CPABC @cpa_bc
5K Followers 1K Following The Chartered Professional Accountants of British Columbia (CPABC) represents over 40,000 CPA members and 6,000 CPA students.
Muigai Mwaura @automation254
785 Followers 423 Following Software Engineer | Sharing tips, tricks and scripts | Excel | GoogleSheets Lover of all things tech and coffee. DMs open.
Faraz Shaikh | Excel ... @ExcelExciting
394 Followers 83 Following
Eugene Meidinger @SQLGene
3K Followers 616 Following Data training for busy people. Power BI Consultant. Pluralsight author. He/Him. Mast: @[email protected] Bsky: @sqlgene.com
Jason Cockington @JasonCockington
15 Followers 73 Following Operations & Team Leader | Power BI Reporting | Stakeholder & Compliance Manager | Technical Product Sales | Process Improvement | Science Writing
theKeyCuts.com @KeyCuts
303 Followers 39 Following We love data analysis, productivity hacks, and thinking critically | Excel training for businesses and organizations.
Scott Durow #ProCodeN... @ScottDurow
7K Followers 2K Following 10xMicrosoft MVP @ Microsoft, #PowerPlatform Cloud Advocate 🥑 He/Him, Father of the Ribbon Workbench 💚 https://t.co/Mde7UKr5gv
Kim Preece @KNPBI
442 Followers 206 Following Job Title: Business Intelligence Consultant. What do you do for a job? Make pretty graphs. o_O
MacRumors.com @MacRumors
1.4M Followers 93 Following Apple, iPhone, iPad and Mac rumors, news, tips and videos. Tap Follow! Message us with questions / comments.
My Data Summit @MyDataSummit
42 Followers 26 Following My Data Summit is virtual global conference on Microsoft Office, PowerPlatform & various Microsoft Technologies.
Leila Gharani @LeilaGharani
18K Followers 88 Following #Excel #PowerBI Instructor, Microsoft MVP, Online Instructor, VBA, Data Visualization & Dashboard Enthusiast, MA Economics, Addicted to Learning.
Kevin Arnold @kevarnold
925 Followers 740 Following Husband, Father, Consultant, MS Data Platform MVP - Business Intelligence and Analytics | Views expressed here are mine and not those of my employer.
Randolph West is not ... @_randolph_west
478 Followers 375 Following I work at Microsoft on the Database Docs team 🏳️⚧️ Not a “he” #AzureDataCommunity #ActuallyAutistic #Actor #Writer #Queer #NonBinary. Find me on Bluesky.
Excel Turbo (Cristian... @ExcelTurbo
475 Followers 275 Following Excel tips and news by @CristianoGalvao in English 🇺🇲 and Portuguese 🇧🇷 Make sure you visit my YouTube channel, on the link below.
Tim Heng @timaheng
207 Followers 40 Following Financial modelling professional. Microsoft Excel MVP.
Mark Beedle @markbdi
822 Followers 221 Following I enjoy a good bourbon, big beards, and Business Intelligence.
Michael Olafusi @olafusimichael
2K Followers 2K Following Microsoft MVP (10x), Financial Modeler, Data Engineer, and Power BI Developer.
Ilgar Zarbaliyev 🇦... @IlgarZ
392 Followers 382 Following MCT Community Lead | Microsoft Data Platform MVP
RawDataByP3Adaptive @RawDataByP3A
461 Followers 64 Following Raw Data By @P3Adaptive, a podcast about data...with the human element!
David Prewitt, MBA, C... @davidwprewitt
430 Followers 1K Following ERC (Employee Retention Credit), data, accounting, and finance consulting services to closely-held businesses and tax-exempts...
Rob Collie @robcolli3
1K Followers 243 Following @P3Adaptive CEO & Founder. Former engineering leader on @MSPowerBI and @MSExcel. Host of @RawDataByP3A podcast.
Ben Gribaudo @bgribaudo
1K Followers 333 Following Consultant Architect • Mentor • Developer • BI/Data Engineer C#/.Net, SQL, Power BI/Power Query, business strategy, … Author of the Power Query M Primer series