We know that there are other learning resources out there. 💻At Skillwave, our courses are created BY professionals, FOR professionals. Our trainers are #BusinessIntelligence and #DataAnaltyics experts who have lived in the trenches, just like you. Go to

In this episode of Monkey Shorts, @kpuls looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒. #Excel #PowerBI #DataPreparation #DataAnalyticsTools.

Join millions who have switched to Grok.

Another happy student! ⭐️⭐️⭐️⭐️⭐️.Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by @kpuls! Learn to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll today at

In our last AKA session, someone asked @kpuls to review their #PowerQuery based solution to see if it could be made more efficient. After trying to add a Sample Transform, in the end a UI-driven Power Query version – despite having more steps – can often be much more efficient!🤖

Today’s the last day to save on all courses – sale ends at midnight tonight!.☀️ 50% off on-demand courses with code: SUMMER50.☀️ 30% off premium coached courses with code: LEARN30.Now’s a great time to invest in yourself, see our catalog at #Excel #PowerBI

Ready to supercharge your #Excel skills? 🦸 This course will help you master essential formulas and functions, dive deep into #PivotTables, and transform data with #PowerQuery. Enroll now and save 30% by using code LEARN30 at checkout: #ExcelMastery

Our courses are changing lives! 👏.@kpuls will teach you how to write #ExcelFormulasAndFunctions, use VLOOKUP, create #PivotTables, transform data with #PowerQuery, and visualize data with charts. Register by Aug 31 and save 30% with code LEARN30 - go to

If you've ever tried to join 2 tables in your #Excel #PowerPivot (or #PowerBI) Data Model, and been blocked by 🙅 or warned about duplicate values, a Bridge Table may be just what you need. Here @kpuls shows his preferred recipe for creating them:

📧Our August newsletter has just gone out, so time to check your inbox if you're a subscriber!. As mentioned in the screenshot, we're working on consolidating the Skillwave and Excelguru newsletters, so stay tuned for more info in the coming weeks.

Elevate your #Excel game with @kpuls’ Excel Fundamentals Academy! 🌟 From basic formulas to advanced #DataAnalytics, we've got you covered. Plus, receive ongoing coaching and support directly from a world-class expert! Join and save 30% with code LEARN30:

Stuck trying to apply what you’ve learned to your own data? With our #SelfServiceBI and Excel Fundamentals) Academies, you don’t have to go it alone. Bring your questions to our instructor-led AKA sessions and get unstuck, fast. 👏 .Save 30% on either course with code LEARN30.4/4

Now, with a single-click, they can regenerate a fresh empty count sheet complete with Bin subheading counts, formulas and conditional formatting to highlight discrepancies. And amazingly, this solution is built completely in #PowerQuery without a single PivotTable in sight!😁 3/4.

They have been saving a new copy of their “expected count” file in a folder every month end and proceeding to do a bunch of manual work to get it into the format shown in the image. 😫 2/4

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 last week’s Ask Ken Anything session, @kpuls helped a client build a re-usable solution to this issue. 1/4.

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

Led by seasoned professionals, our training provides insights from experts who understand the art and science #DataVisualization. 📉Get grounded in #DataStorytelling and visual communication using #Excel and #PowerBI. 👉Save 50% with code SUMMER50:

See what students love about our #DataVisualization course! 💙.We'll help you help you communicate insights, tell stories, and persuade audiences by creating more effective graphs, charts, and diagrams in #Excel and #PowerBI. Use code SUMMER50 to save 50%:

If there are 2 things @kpuls dislikes, it's out-of-date software and having to update software. 😠 You'd think that this means he's never happy. 😜.See how he installs #PowerBI to ensure:.🅰️ It's always up-to-date, and.🅱️ He never has to update it, ever.

Master the art of #DataStorytelling! 🎨 We’ll guide you through the principles of effective #DataVisualization and show how to build different charts and graphs in #Excel and #PowerBI. Communicate your insights with impact and save 50% with code SUMMER50:

While it is awesome to have options #DataCleansing, sometimes the sheer amount of options can be overwhelming. 😧 This can prevent you from getting started or just make you question which is the best option to pursue for your scenario. Fortunately, our Ask Ken sessions can help!