🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

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

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! 🤜 mkyt.ca/destsleuth

What if you could master #Excel in just 10 minutes a day? 🤯 With the Excel – Basic & Advanced course from Microsoft MVP Ken Puls, FCPA, FCMA, you absolutely can! ✅ 3–7 minute lessons ✅ Quick quizzes ✅ Hands-on practice Ranked the top Excel course by Investopedia and trusted by 100,000+

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%: skw-t.com/pqa50

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: meetup.com/vancouver-powe…

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: skw-t.com/courses

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. 🥳

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! 👋youtube.com/watch?v=GSNqeU…

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 skw-t.com/ssbi30

Learn #PowerQuery to transform data effortlessly, save time, and make smarter decisions! Power Query Academy unveils the secrets to data mastery in #Excel and #PowerBI. Register today on our Skillwave Training learning platform, and save 50% with code SUMMER50: skw-t.com/pqa50

We had an awesome time with Lee Becker at last week's Vancouver #PowerBI and Modern #Excel meet-up, where she showed us a ton of great #ExcelTips. Want to boost your efficiency in Excel? 🎥 Watch the recording here: youtube.com/watch?v=6mpA9o…

For the next 3 days, I'm leading an #Excel Fundamentals Boot Camp for a private client. 👨‍🏫 Today includes a review of formulas and functions, including the daunting VLOOKUP. (Yes, I'm aware that XLOOKUP exists - but if you can master VLOOKUP, you can master ANY Excel formula!)

Now’s the perfect time to take your #BusinessIntelligence and #DataAnalytics skills to the next level! Save on all Skillwave Training courses until Aug 31. ☀️ 50% off on-demand courses with code: SUMMER50 ☀️ 30% off premium coached courses with code: LEARN30 See skw-t.com/summer2025

One of the killer features of Monkey Tools' Time Sleuth is that it allows you to easily set up multiple tests and it charts the results for you. With the info provided in the output report, it becomes easy to compare the speed of 2 queries. Learn more at mkyt.ca/timesleuth

🔑 #DimensionalModeling is the key to unlocking the power of the #DataModel in #Excel and #PowerBI. But do you really know how to work with it properly? Learn to make your #BusinessIntelligence models more stable and scalable. Save 50% with code SUMMER50: skw-t.com/datamodel50

Following on last week's Monkey Shorts, let's look at one potential "gotcha" that can happen when converting a #PivotTable into CUBE functions - the array formula. 😩 Learn how to identify an array, and how to break it to make your formulas dynamic again: youtube.com/watch?v=XU5uKZ…

Yesterday's post on Monkey Tools showed the box & whisker chart in the TimeSleuth output. Unfortunately, many people don’t really understand the chart (aka Box Plot), so here I explain how they work and what conclusions you can draw from the data: excelguru.ca/reading-excels…

I'm leading a course today on how to build charts and dashboards in #Excel for CPABC. Here are my 5 Rules of Effective Charting: 1️⃣ Every chart should tell a story 2️⃣ Pick the RIGHT chart type 3️⃣ Make it a SHORT story 4️⃣ Avoid chart junk and noise 5️⃣ Review completed chart

I love that our #Dimensional Modeling for the #Excel and #PowerBI Pro course on Skillwave Training has saved people both time and heartburn! 😆 We'll show you how to work with your #DataModel the right way. Save 50% when you register with code SUMMER50: skw-t.com/datamodel50

Our #DimensionalModeling course at Skillwave Training pairs 2 of #SelfServiceBI’s most powerful features: #PowerQuery and the #DataModel. Learn to use each for what they were designed to do and build your data models the RIGHT way.✅ Use code SUMMER50 & save 50%: skw-t.com/datamodel50