I want to make sure that all #SelfServiceBI Academy members have the necessary background skills in #Excel. So now, access to Excel Fundamentals Academy is included with all SSBI registrations! 🎁. Right now you can save 30% with code LEARN30 - go to

Ever wanted to grab a single cell of data from your #PowerPivot model? Tired of setting up an entire #PivotTable and using GETPIVOTDATA? I'll show how to quickly convert a Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints! 👋

I'm super proud to be renewed again as a Microsoft MVP. This makes it the 19th year in a row!! 🏆. And congratulations to all the other recipients - it's such a wonderful community to be a part of. 🥳

In an Ask Ken call, someone wanted to add aging to a Power Pivot model. Well, here's a Pivot Table showing AR transactions summarized by days outstanding. Wish you had this kind of help? My #SelfServiceBI & #Excel Fundamentals Academies include the AKAs:

There's still time to RSVP for today's Vancouver #PowerBI and Modern #Excel meet-up! Join us at 1pm PDT to grow your essential Excel skills with Lee Becker. She's sharing practical #ExcelTipsAndTricks (no formulas!) to increase your productivity. Go to:

Want to revolutionize your data game? 💡 Join Power Query Academy and streamline data manipulation in #Excel and #PowerBI! Discover the benefits of mastering #PowerQuery – efficiency, accuracy, and stand-out skills! Enroll with code SUMMER50 to save 50%:

RT @getgoskills: What if you could master #Excel in just 10 minutes a day? 🤯. With the Excel – Basic & Advanced course from Microsoft MVP @….

In #PowerQuery, you can choose various query load destinations. When you mouse over the preview pane, you’re either told that the query loads to Connection Only, or as “x Rows Loaded”. But it doesn’t tell you WHERE. But Destination Sleuth knows! 🤜

Kickstart your career by upgrading your #BusinessIntelligence and #DataAnalytics skills! It’s our biggest sale ever on all our @skillwave_ courses. ☀️ 50% off on-demand courses with code: SUMMER50.☀️ 30% off premium coached courses with code: LEARN30.Go to

I'm teaching today for @cpa_bc on how we can use #PowerBI for rapidly building and sharing dashboards and reports. Ever been in a situation like the first image? The beauty of Power BI is that it allows the #DataAnalyst to prototype the report without wasting IT's resources!

The new Regex functions in #Excel can be a powerful tool when it comes to #DataCleaning. 🧼 Never used Regex before? Don't worry, on August 7 @TrumpExcel will walk you through everything you need to know to start using these functions. Sign up here:

A student mentioned that they’ve seen a lot about the power of Python in #Excel and specifically asked about its power related to cleaning data. They wondered whether #Python was a skill that they should prioritize learning for this. I had some thoughts.

Explore the realm of #BusinessIntelligence with my #SelfServiceBI Academy. 📈 Whether you're a #DataAnalytics beginner or looking to enhance your #Excel and #PowerBI skills, this course is for you!. Register now to save 30% with code LEARN30: #DataModel

This happy student has been a part of my #SelfServiceBI Academy for almost 4 years! 🥰.One of the things I love best is interacting with students at the live 'Ask Ken Anything' sessions hosted twice each month. Until Aug 30, save 30% with code LEARN30:

Did you know that an official #Excel table (Ctrl + T) can be set up to have a single cell? 🤓 In this video, Ken Puls shows you how this is done, as well how it can be used to read data into and out of #PowerQuery: #DataAnalysis #BusinessIntelligenceTools.

📊 Dive into the world of #BusinessIntelligence in my #SelfServiceBI Academy. I'll provide hands-on experience using #Excel and #PowerBI to create insightful reports and dynamic dashboards. Kickstart your learning journey! Use code LEARN30 to save 30%:

RT @borianapetrova: 🎤 Meet the Speakers of Bulgaria #Excel Days 2025: .Today we present Chris Webb – Power BI Authority, Principal Program….

Monkey Tools' TimeSleuth allows you to time all the queries in your #BusinessIntelligence solution, or just specific queries using the Detailed Refresh option. ⏱ It provides a detailed list of the refresh times as it goes. Learn how at #Excel #PowerQuery

Now’s the perfect time to take your #BusinessIntelligence and #DataAnalytics skills to the next level! Until Aug 31, save on all our @skillwave_ courses!.☀️ 50% off on-demand courses with code: SUMMER50.☀️ 30% off premium coached courses with code: LEARN30.

How do you separate values and text in #PowerQuery when there is no common delimiter, like a space, separating them? ⁉️.Here, I build a custom function to remove the leading numeric values. That leaves me with the text values, which I can then replace: