Skillwave Training
LightNews LightNews
banner
skillwave.training
Skillwave Training
@skillwave.training
100 followers 55 following 420 posts
Your #1 resource for online training on Power BI, Power Query, Power Pivot, and Excel. View our course catalog at skillwave.training/learn
Posts Replies Media Videos
Pinned
skillwave.training
Skillwave Training @skillwave.training · 6d
Learn from industry experts, gain practical insights, and boost your #DataAnalytics career with Skillwave Training. Don't miss out, join us now and transform your future! 💪

🏴 Purchase any course or eBook today and save 25% with this coupon code: 2025CYBER

View our course catalog at skw-t.com/cw25
skillwave.training
Expand your knowledge of #DAX, M Code, #PowerQuery data transformation patterns, and more with our eBooks and other digital downloads. 📚

Save 25% on everything in our catalog, including eBook bundles, with code 2025CYBER – go to: skw-t.com/cw25-ebooks

#PowerBI #DataAnalytics #DataModeling
November 30, 2025 at 5:25 PM
skillwave.training
#PowerPivot in #Excel has incredible potential for #FinancialAnalytics, and @excelguru.ca will show you how to unlock it! Master the art of building financial statements, balance sheets, and more. 💲 📈
Enroll today with code 2025CYBER to save 25%: skw-t.com/cw25-bfs

#FinancialModeling #DataAnalytics
November 29, 2025 at 6:04 PM
skillwave.training
Imagine you have tiered pricing structure, where the cost of something is based on the number of units purchased. #PowerQuery can help you quickly determine the price/unit with this "Approximate Match" recipe.

Get the full set at skw-t.com/pqrecipes
🤫 Until Dec 5, use this code save 25%: 2025CYBER
Master Your Data in Excel & Power BI Approximate Match Recipe Prepare Source table Set data types Prepare Lookup table Rename [Match] column to match Source table Set data types Perform the match Reference the Source table Go to Home ->Append -> Lookup table Filter the [Match] column -> Sort Ascending Filter the [Key] column -> Sort Ascending Right click the [Return] column -> Fill -> Down Filter the [Key] column -> uncheck null For more data patters check out our courses at www.skillwave.training
November 28, 2025 at 8:43 PM
skillwave.training
Take your #DataAnalytics skills to the next level with #PowerBI for the Business Analyst. 🚀 Hands-on experience, self-paced learning, and expert guidance from Matt Allington. Register today and unleash the power of data. 👊
Enroll with code 2025CYBER to save 25%: skw-t.com/cw25-pbiba
#PowerQuery #DAX
November 28, 2025 at 5:19 PM
skillwave.training
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this Monkey Shorts, @excelguru.ca will show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...

#DataPreparation #DataAnalyticsTools #BusinessIntelligence
One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002
Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.
www.youtube.com
November 27, 2025 at 8:07 PM
skillwave.training
Great trick!
November 27, 2025 at 7:18 PM
skillwave.training
Ready to revolutionize your reporting process? 📉 Join our #SelfServiceBI Academy with @excelguru.ca to unlock the full potential of your #DataModeling and #DataAnalysis skills in #Excel and #PowerBI. Your data, your insights, your future! ✨
Apply code 2025CYBER to save 25%: skw-t.com/cw25-ssbi
November 27, 2025 at 5:07 PM
skillwave.training
Transform your data into actionable insights! 📊 Learn #DAX from the ground up with hands-on practice, video tutorials, and expert guidance from Matt Allington. Enroll in Supercharge #PowerBI Online today and level up your #DataAnalytics game. 🦸
Use code 2025CYBER to save 25%: skw-t.com/cw25-spbi
November 26, 2025 at 8:15 PM
skillwave.training
The new edition of our newsletter has just been sent, so time to check your inbox if you're a subscriber. 📬
Not subscribed? Sign up at skw-t.com/news for what's new in #Excel and #PowerBI, the latest expert content, and info on courses, events, and specials. You also get our #PowerQuery eBook! 🎁
News from the Data Monkey Brought to you by Excelguru + Skillwave (Image of a cyborg monkey in a superhero-type squat) November 26, 2025 - In This Issue: - PivotTable Auto Refresh Video - From the AKA Sessions - What's New in Power BI - Recent Meet-up Recording - Upcoming Courses and Conferences - Available Training Options We're excited to share that our annual Cyber Week Sale is now underway! Until midnight on Friday, December 5, you can save 25% on all new Skillwave course registrations and eBook purchases. All you have to do is apply this coupon code at checkout: 2025CYBER Ken is also offering a deal on his Monkey Tools Excel Add-in: - 20% off Annual Pro Licenses with code MONKEYANNUAL20 - 15% off Lifetime Pro Licenses with code MONKEYLIFE15 (NOTE: Offers valid November 24-December 5, 2025. The coupon codes can only be used towards new purchases; they cannot be applied to past purchases or to course/license renewals.)
November 26, 2025 at 5:22 PM
skillwave.training
In our last AKA session, an attendee asked why the #PowerBI report built by a consultant kept losing its table column headers whenever they scrolled down the table. Even the slicer vanished! 😠

@excelguru.ca hopped in and spotted the culprit: the canvas had been set to a massive custom size! 🧵
The Case of the Disappearing Headers A student asked why a Power BI report kept losing its table header columns when they scrolled down the table. The culprit? A massively set custom canvas size, so scrolling inside a visual turned into scrolling the entire oversized canvas! (Screenshot of the report's canvas settings showing custom settings of 1080 px high by 6000 px wide, with a note saying, "This must have been a deliberate choice... but maybe not the best one!) (Skillwave Training logo)
November 25, 2025 at 9:46 PM
skillwave.training
Data professionals, it's time to level up! 📈 Stop the repetitive #DataCleaning and start focusing on #DataAnalysis. Learn how to save time and boost your career with #PowerQuery. 💼

Enroll now and enter code 2025CYBER at checkout to save 25%. Go to skw-t.com/cw25-pqa

#Excel #PowerBI #DataAnalytics
November 25, 2025 at 5:30 PM
skillwave.training
Want your #Excel #PivotTable to refresh automatically—without clicking Refresh every time? 🔄
@excelguru.ca shows you the new PivotTable Auto Refresh feature (in the Beta Channel for Office 365) that keeps your reports accurate the moment your source data changes:
Stop Clicking Refresh! Auto-Refresh Your PivotTables in Excel (Beta Feature Preview)
This video shows a Beta Channel preview of Microsoft’s upcoming PivotTable Auto Refresh feature — explained and demonstrated by Excel MVP Ken Puls (Excelguru / Skillwave). You can have your Excel…
www.youtube.com
November 24, 2025 at 9:07 PM
skillwave.training
Learn from industry experts, gain practical insights, and boost your #DataAnalytics career with Skillwave Training. Don't miss out, join us now and transform your future! 💪

🏴 Purchase any course or eBook today and save 25% with this coupon code: 2025CYBER

View our course catalog at skw-t.com/cw25
November 24, 2025 at 2:03 PM
skillwave.training
📢 Keep your eyes peeled for details of our annual Cyber Week sale!

🏴 Starting tomorrow, you can save big on all our courses and eBooks. Check back here for updates! 😉

#BusinessIntelligence#DataVisualization #DataAnalytics #PowerBI #Excel #DAX #DimensionalModeling #PowerPivot #PowerQuery
(Skillwave Training logo) Cyber Week Sale Starts Tomorrow Save 25% on all our: - Premium Coached Training - On-demand Training - eBooks & Digital Downloads skillwave.training Valid November 24 - December 5, 2025
November 23, 2025 at 6:01 PM
skillwave.training
Looking to expand your knowledge of #DAX, M Code, #PowerQuery, and #PowerBI? Check out our eBook value bundles: skw-t.com/ebooks
📘The Power Query Bundle includes:
▪️Master Your Data with Excel and Power BI by @excelguru.ca and Miguel Escobar
▪️Power Query: Beyond the User Interface by Chandeep Chhabra
Power Query Book Bundle ▪️Master Your Data with Excel and Power BI by Ken Puls and Miguel Escobar ▪️Power Query: Beyond the User Interface by Chandeep Chhabra
November 21, 2025 at 5:16 PM
skillwave.training
In this Monkey Shorts episode, @excelguru.ca shows the first #PowerQuery setting he changes when he installs #Excel. 👊 www.youtube.com/watch?v=ZAY7...

#DataPreparation #DataAnalytics #BusinessIntelligence
Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
www.youtube.com
November 20, 2025 at 5:57 PM
skillwave.training
Ever had a #PowerQuery load fail after a new column shows up in your CSV file? An AKA attendee did and the fix was surprisingly simple. @excelguru.ca revealed that PQ sometimes locks the column count when you first import a file. When the data source later adds new fields, it breaks the connection.🧵
What do you do when Power Query says, “Column Not Found”? (Image of a man sitting in front of a laptop with his hands on his temples and a confused look on his face) (Skillwave Training logo)
November 19, 2025 at 5:20 PM
skillwave.training
Here, @excelguru.ca shows a real-life #DataAnalysis of median income by country, compared to the median income of the US. In it, he uses #Excel, #PowerQuery, #PowerPivot and #DAX and even show how his Monkey Tools add-in helps speed up development of certain tasks:
Median World Income vs US World Income
In this video, Ken shows how he did a real-life analysis of median income by country, compared to the median income of the United States. In it, he uses Excel, Power Query, Power Pivot and DAX…
www.youtube.com
November 18, 2025 at 6:04 PM
skillwave.training
See why students love our #PowerQuery course!✨
We'll help you unlock the true power of your data in #Excel and #PowerBI! Say goodbye to hours of manual #DataManipulation and hello to quick #DataInsights and informed decisions. Join our course now to make data work for you: skw-t.com/pqa
See what our students are saying! "It was very thorough. Great course, learned a ton!" TJ (5 stars) "I loved the practical examples and timing of lessons (5-15 minutes each). I can only recommend this course!" Lukas (5 stars) Power Query Academy skillwave.training (Skillwave Training logo)
November 17, 2025 at 6:26 PM
skillwave.training
In our latest AKA session, @excelguru.ca was asked how to handle sales items that shouldn’t count toward commissions in a #PowerBI report. 🤔
Rather than filtering out rows, he suggested adding a Y/N flag column in the data model and then use #DAX to calculate commissions only where flag = “Yes.”🧵
A More Dynamic Commission Report A student asked what do if you have sales items that shouldn’t count towards a team member’s commission earnings? Instead of filtering out rows in the report, Ken Puls suggested creating a column in the underlying data model to flag the item Yes/No and then add a simple DAX formula to the report so that only commissionable items are included: =CALCUALTE( [Sales $], Product[Commissionable] = "Yes" ) (Skillwave Training logo)
November 14, 2025 at 6:54 PM
skillwave.training
While Monkey Tools won't help you build a LAMBDA, it definitely makes it easy to inject them into your #Excel workbook. @excelguru.ca shows how to use this FREE feature to both store and inject LAMBDA functions into your workbooks - no macros, not notepad files:
www.youtube.com/watch?v=T5d0...
The FASTEST way to Store/Inject LAMBDA functions in Excel!
While Monkey Tools won't help you build a LAMBDA function, we definitely make it easier than anyone else to inject them into your workbook. Join Ken as he shows how to use this Free Monkey Tools…
www.youtube.com
November 13, 2025 at 6:03 PM
skillwave.training
The latest edition of "News from the Data Monkey" has just been sent! 🐵📃 Our twice-monthly newsletter includes what's new in #Excel and #PowerBI, features from our AKA sessions, the latest meet-up recording, and info on our courses, events, promotions, and more! Sign up today at skw-t.com/news
News from the Data Monkey Brought to you by Excelguru and Skillwave (Image of a cyborg monkey in a superhero-type crouch) November 12, 2025 In This Issue: - From the AKA Sessions - What's New in Excel - Recent Meet-up Recording - Upcoming Courses and Conferences - Available Training Options Ken had a great time in Bulgaria and Germany at the end of October, but is glad to be back home now. This month he's leading several training sessions for CPABC and private clients, as well as hosting the 'Ask Ken Anything' calls and welcoming a new batch of registrants for the Self Service BI and Excel Fundamentals Academies. Our team is also busy preparing for our annual Cyber Week sale - stay tuned for details starting the last week of November!
November 12, 2025 at 7:59 PM
skillwave.training
With 299 students trained and an average rating of 4.9 / 5 stars, see why our #SelfServiceBI Academy by @excelguru.ca is so popular! 😍

This hands-on training will teach you how to use #Excel, #PowerQuery, #PowerBI, #DAX, and #DimensionalModeling together. Join us today at skw-t.com/ssbi
Testimonial "Lots of examples, very knowledgeable instructor, comprehensive instructions" J.P. (5 stars) Self Service BI Academy (Caricature of Ken Puls) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave Training logo)
November 12, 2025 at 5:05 PM
skillwave.training
It's common to need to transform data from one “shape” to another before it can be used in #PowerBI or #Excel for #DataAnalysis, eg. left-hand data needs to look like the table on the right. 👉 In this classic article, Matt Allington shows you how to pivot text using #PowerQuery: buff.ly/3Ol967I
Screenshot of two worksheets: Left-hand worksheet has Column1 and Column2 with a pattern of 4 rows containing information about a specific employee. Right-hand worksheet has separate columns for Employee, Employee Number, Start Date, and Salary, with each row containing the information for an individual employee.
November 11, 2025 at 5:56 PM
skillwave.training
Are you an experienced #PowerBI user thinking of taking the PL-300 PBI #DataAnalyst exam from Microsoft? Matt Allington has you covered with this on-demand video training. Understand the depth and breadth of the exam, and see where you need to spend more time preparing. Go to skw-t.com/pl300prep
Microsoft PL-300 Exam Prep Give yourself the best chance of passing the exam the first time! Topics covered include: - Gather & transform data - Model & optimize data - DAX formulas & functions - Data visualization - Publish & share reports - Prepare for the exam PL-300 Exam Preparation for Power BI (Headshot of Matt Allington) Developed & delivered by Matt Allington https://skw-t.com/pl300prep (Skillwave Training logo)
November 10, 2025 at 5:35 PM