Pinned Tweet
Skillwave Training@skillwave_
Apr 13
Want to save yourself hours of time and manual effort preparing your data in #Excel or #PowerBI? Start to master #DataCleaning 🧼 and transformation so you can automate your #BusinessIntelligence with our FREE #PowerQuery Fundamentals course! Register at skw-t.com/pqfun
0
0
0
89
Skillwave Training@skillwave_
Nov 6
Students love our FREE #PowerQuery intro course! 💖
Power Query allows you to gather and transform data for building refresh-able #BusinessIntelligence solutions. Learn the fundamentals in #Excel and #PowerBI today at skw-t.com/pqfun

#DataPreparation #DataAnalytics
See what our students are saying! Power Query Fundamentals from Excel and Power BI "[The course was] basic, short, and simple to understand." M.S. (5 stars) "I liked the clear videos and explanations, and workable demos to complete alongside the videos." D.C. (5 stars) skillwave.training (Skillwave Training logo)
0
0
0
43
Skillwave Training@skillwave_
Nov 5
On the first Monkey Shorts episode, @kpuls showed the first #PowerQuery setting he changes when he installs #Excel - the query load destination. 🐵🩳 youtube.com/watch?v=ZAY7q_…

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools
0
0
0
59
Skillwave Training@skillwave_
Nov 4
Stop trying to figure it all out on your own - we've got you covered! 👊 Join Skillwave today and unlock the full potential of #PowerBI, #PowerQuery, #PowerPivot, and #Excel.
View our #DataAnalytics and #BusinessIntelligence courses at skw-t.com/courses
Struggling with learning on your own? (Image of a woman sitting in front of a laptop with her head in her hands and despondent look on her face.) (Skillwave Training logo)
0
0
1
43
Skillwave Training@skillwave_
Nov 3
Have you ever refreshed a #PowerQuery table and thought… “Wait — who moved my rows?” 🤨
In this video, @kpuls walks through a surprising behavior in #Excel if Power Query tables are refreshed when multiple tables are placed on the same worksheet: youtube.com/watch?v=8Lf17w…
0
0
0
58
Skillwave Training@skillwave_
Nov 2
After playing around with #Copilot's canvas in #Excel during our last AKA session, @kpuls' takeaway was #ArtificialIntelligence can get you most of the way fast, but you still own the validation. You can't trace where a number came from and adjustments must be done via prompts.
Can Copilot Build a Dashboard? In our last ‘Ask Ken Anything’ call, Ken tried Copilot's interactive canvas in Excel. While the dashboard was impressive, the cleaned data still had to exist first. (Screenshot of the dashboard built with Copilot using Ken’s Litter Box Activity dataset) (Skillwave Training logo)
0
0
1
68
Skillwave Training@skillwave_
Oct 30
Don't forget: daylight savings ends in many parts of N. America on Sunday, November 1. ☀️ Luckily, our #PowerQuery recipe for converting a UTC DateTime to a Local DateTime is daylight savings aware. Get the full collection: skw-t.com/pqrecipes

#Excel #PowerBI #DataAnalytics
(Skillwave Training logo) Image of a cyborg monkey leaping into the air, cheering with its fist raised. A thought bubble next to the monkey says: "Let’s see, it’s fall back, spring ahead... YES, an extra hour of sleep this weekend!"(Skillwave Training logo) Power Query Recipe Card 60.910 Convert UTC DateTime to local DateTime Step 1: Add a UTC time zone (if your data has time zones, skip to Step 2) Right click the [Original] column -> Change Type -> DateTime Go to Add Column -> Custom Column Name: DateTimeLocal Formula: DateTime.AddZone([Original],0) Right click the [Original] column -> Remove Column Step 2: Convert the [DateTimeLocal] column to your local time zone Select the [DateTimeLocal] column -> Transform -> Time -> Local Time Right click the [DateTimeLocal] column -> Change Type -> <Date or DateTime as desired> NOTE: This recipe is Daylight Savings Time aware! If you do not want this volatility in your transformation, see Recipe 60.920 to lock in a time zone.
0
0
1
62
Skillwave Training@skillwave_
Oct 29
While Monkey Tools won't help you build a LAMBDA function, it definitely makes it easy to inject them into your #Excel workbook. 👏 @kpuls shows how to use this FREE Monkey Tools feature to both store and inject LAMBDA functions into your workbooks: youtube.com/watch?v=T5d0yU…
0
0
0
45
Skillwave Training@skillwave_
Oct 28
Here, @kpuls does a real-world demo of the 9 #PowerQuery join types. 🤝 We'll walk through how each join behaves when matching data across multiple columns without needing to manually create a combined key: youtube.com/watch?v=Cn-3QH…
💡 This works the same in #Excel and #PowerBI.
0
0
0
88
Skillwave Training@skillwave_
Oct 27
The latest edition of our newsletter is hitting inboxes now! 📨
If you'd like to stay up-to-date on the latest content from our experts, what’s new in #Excel and #PowerBI, info on courses, events, promos, a FREE #PowerQuery eBook, and more, subscribe 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 style crouch) October 27, 2026 In This Issue: - From the AKA Sessions - New video blog on loading web-hosted CSV files into Excel - What's New in Power BI - Latest Meet-up Recording and Next Event Information - Upcoming Courses and Conferences - Monkey Tools Updates - Available Training Options Ken had an awesome time last week in Sofia for this year's installment of Bulgaria Excel Days - Workshop Edition. There's nothing better than teaching a live, in person course, and hanging out with friends old and new. Now he just has to catch on everything waiting here for him back in the office!(M)agic Tricks for Data Wizards (Icon of a laptop with a magic wand on the screen and a wizard's hat draped over the top right corner) Tips & Tricks for Power Query in Excel and Power BI (Microsoft Excel and Power BI icons)
0
0
1
61
Skillwave Training@skillwave_
Oct 26
See what people love about our #Dimensional Modeling for the #Excel and #PowerBI Pro course! ⭐⭐⭐⭐⭐
We'll show you how to work with your #DataModel the right way, building solid and scalable #BusinessIntelligence solutions. Join us today at skw-t.com/modeling
Testimonial: "I love the speed, topics and the fact we learned and then [get a] demo." R.A. (5 stars) Dimensional Modeling for the Excel and Power BI Pro (Microsoft Excel and Power BI icons) Both the Excel and Power BI versions of the course are included with registration! (Skillwave Training logo)
0
0
1
53
Skillwave Training@skillwave_
Oct 22
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? Wonder no more! In this video, @kpuls will show you how he added the "Detect Data Types" button to the Power Query QAT. 🛠
youtube.com/watch?v=fcdCw_…
0
0
0
80
Skillwave Training@skillwave_
Oct 21
We recently had a corporate client apply for the BC Employer Training Grant through @WorkBC, to help cover the cost of some team training. 💵 It's available to organizations of all sizes and you could get up to $300,000! Check out the program details at skw-t.com/bctraining
Is your company based in British Columbia? (Government of British Columbia and WorkBC logos) (Image of a woman holding a folder in one hand and reaching out to shake someone's hand with the other) Your company can receive up to $300,000 for skills training from the BC Government! (Microsoft Power BI and Excel icons) The BC Employer Training Grant provides funding to small, medium and large enterprises to support skills training. And both the on-demand and private courses we offer at Skillwave could qualify! Learn more about the program: https://skw-t.com/bctraining View our course catalog at skillwave.training (Skillwave Training logo)
0
1
3
175
Skillwave Training@skillwave_
Oct 20
Learn how to load CSV files from the web into #Excel using #PowerQuery. 🌐 In this new video, @kpuls shows 2 ways:
🟩Using the specific From Text/CSV connector, or
🟩Using the more general From Web connector.
Plus, you can then refresh with a single click!
youtube.com/watch?v=ISWzBU…
0
0
1
88
Skillwave Training@skillwave_
Oct 19
#PowerQuery allows you to master you data in #PowerBI and #Excel, so you can automate your #DataCleaning 🧹 and #BusinessIntelligence processes.💪 Join the ultimate Power Query course today at skw-t.com/pqacademy

#DataTransformation #DataAnalyticsTraining #FinancialAnalysis
Now you can master data cleaning and transformation (Database icon with a sweeping broom on top) (Skillwave Training logo)
0
0
1
72
Skillwave Training@skillwave_
Oct 16
Yesterday we shared a video on how to compare values based on the prior row's data. This #PowerQuery recipe card outlines the steps that @kpuls demonstrated. 👩‍🍳Get the full Power Query Recipe collection at skw-t.com/pqrecipes

#Excel #PowerBI #DataAnalytics #DataPreparation
Master Your Data in Excel & Power BI Pattern Difficulty: Lo Code Extract to New Column Based on Data in Next Row Recipe Preparation: Perform any possible preliminary cleanup Add [Index] column: Add Columns -> Index Column -> From 0 Add [Index.1] column: Add Columns -> Index Column -> From 1 Extract Data Into New Column: Go to Home -> Merge Queries As New -> Merge against itself Match [Index.1] (top) against [Index] (bottom) Expand the [Compare] column only, creating [Compare.1] Sort by the [Index] column (ascending) Create a Conditional Column: =if [Compare.1]= "pattern" then [Target] else null Right click the new column -> Fill -> up/down (as needed) Filter the [Compare.1] column to remove the pattern Remove the [Index], [Index.1] and [Compare.1] columns Finish cleanup (Screenshot of the Target and Compare columns in the Power Query Editor, with the Index cells highlighted to show the pattern to use in the Conditional Column formula.)
0
0
1
76
Skillwave Training@skillwave_
Oct 15
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. 🔢 In this Monkey Shorts, @kpuls demos a super-cool black magic technique that allows you to do exactly that. 😈
youtube.com/watch?v=zdNYiY…
#Excel #PowerBI #DataAnalytics
0
0
1
105
Skillwave Training retweeted
Jon Schwabish@jschwabish
Oct 14
My Favorite Graphs: Driving Safety, In Fits and Starts

New podcast episode where I talk about one of my favorites, this one from @hfairfield in 2012

podcasts.apple.com/us/podcast/my-…
0
1
1
411
Skillwave Training@skillwave_
Oct 14
A student replaced Not A Number values using #PowerQuery but the query still showed errors. @kpuls' fix? Replace NaN as text AFTER promoting headers but BEFORE setting data types. If it's already been converted, change the column to text, replace the values, then convert it back.
Taming NaN Values in Your Source Data (Image of a woman sitting at a table working intently on a laptop) (Skillwave Training logo)
0
0
0
60
Skillwave Training@skillwave_
Oct 13
Yesterday was Thanksgiving for our team in Canada, and we've woken up from our turkey coma enough to send out the latest newsletter. 🦃
Sign up at skw-t.com/news for info on what's new in #Excel and #PowerBI, courses, events, specials, a free #PowerQuery eBook, and more!
News From the Data Monkey Brought to you by Excelguru and Skillwave October 13, 2026 In This Issue: - From the AKA Sessions - New video blog on understanding and fixing blanks in PivotTables - What's New in Excel - Latest Meet-up Recording and Next Event Information - Upcoming Courses and Conferences - Monkey Tools Updates - Available Training Options Yesterday was Thanksgiving here in Canada, and we just wanted to take a moment to say "thank you" to all of our newsletter subscribers, students, meet-up participants, and those who follow us on social media. YOU are the reason we do what we do, and we absolutely love the Excel and Power BI community! Every course enrollment, event registration, newsletter subscription, and like or comment on our social channels mean the world to us. Thank you for being a part of it!(M)agic Tricks for Data Wizards (Icon of a laptop with a magic wand on the screen and a wizard's hat draped over the top right corner) Tips and Tricks for Power Query in Excel and Power BI by Ken Puls and Miguel Escobar
0
0
1
98
Skillwave Training@skillwave_
Oct 12
🕒Time intelligence is the name for patterns that can be used to solve time comparison problems, such as current VS previous month's sales. 📈 If you do time-based comparisons using #DAX, #Excel #PowerPivot, and/or #PowerBI, this article is for you: exceleratorbi.com.au/dax-time-intel…
Screenshot of a PivotTable showing the Total Sales, Sales Prior Year, Change vs Prior Year, and % Change vs Prior Year for each of the 12 months of the selected year. Formatting has also been applied to help highlight increases vs decreases for each month.
0
0
0
53
Load more