Ken Puls, FCPA, MS MVP
@excelguru.ca
I teach people how to use Excel (https://skillwave.training), host an Excel website (https://excelguru.ca), build software (https://monkeytools.ca) and enjoy watching football (aka soccer).
Real world challenges, practical solutions. That’s the benefit of our AKA sessions! Enroll in our #SelfServiceBI (skw-t.com/ssbi) or #Excel Fundamentals (skw-t.com/excelfun) Academy, or or purchase just the AKA access (skw-t.com/aka) and join live sessions for help with your own scenarios. 3/3
Self Service BI Academy
Prepare to change your company's reporting game forever! In the Self Service BI Academy, Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI…
skw-t.com
November 10, 2025 at 5:22 PM
Real world challenges, practical solutions. That’s the benefit of our AKA sessions! Enroll in our #SelfServiceBI (skw-t.com/ssbi) or #Excel Fundamentals (skw-t.com/excelfun) Academy, or or purchase just the AKA access (skw-t.com/aka) and join live sessions for help with your own scenarios. 3/3
Watching those empty rows vanish instantly in the PivotTable was one of those deeply satisfying #Excel moments we all crave.
The crowd reaction? “Wait – why didn’t I know that trick before?”
👏 Takeaway: Sometimes the smallest DAX tweak delivers the biggest clarity in your reports. 2/3
The crowd reaction? “Wait – why didn’t I know that trick before?”
👏 Takeaway: Sometimes the smallest DAX tweak delivers the biggest clarity in your reports. 2/3
November 10, 2025 at 5:22 PM
Watching those empty rows vanish instantly in the PivotTable was one of those deeply satisfying #Excel moments we all crave.
The crowd reaction? “Wait – why didn’t I know that trick before?”
👏 Takeaway: Sometimes the smallest DAX tweak delivers the biggest clarity in your reports. 2/3
The crowd reaction? “Wait – why didn’t I know that trick before?”
👏 Takeaway: Sometimes the smallest DAX tweak delivers the biggest clarity in your reports. 2/3
Agreed, our user group has been overrun as well. 😠
November 4, 2025 at 7:23 PM
Agreed, our user group has been overrun as well. 😠
💡 Lesson learned: If your reports start with repetitive cleanup, Power Query is your best friend - and our AKA sessions are the fastest way to figure out how to apply it to your own real-world scenarios! Join my academies at @Skillwave.Training, or get just the AKA access a skw-t.com/aka
Ask Ken Anything
Get more than just a course – get access to an expert who will help you build real world solutions. The Ask Ken Anything (AKA) sessions are live, interactive coaching calls that are held twice each…
skw-t.com
November 4, 2025 at 5:06 PM
💡 Lesson learned: If your reports start with repetitive cleanup, Power Query is your best friend - and our AKA sessions are the fastest way to figure out how to apply it to your own real-world scenarios! Join my academies at @Skillwave.Training, or get just the AKA access a skw-t.com/aka
Watching her realize she’d never have to “copy-paste and clean” again was pure magic! #DataPreparation #DataCleanup
The best part? Other students jumped in with their own automation tips, showing just how collaborative the @Skillwave.Training community really is. 🤝
The best part? Other students jumped in with their own automation tips, showing just how collaborative the @Skillwave.Training community really is. 🤝
November 4, 2025 at 5:06 PM
Watching her realize she’d never have to “copy-paste and clean” again was pure magic! #DataPreparation #DataCleanup
The best part? Other students jumped in with their own automation tips, showing just how collaborative the @Skillwave.Training community really is. 🤝
The best part? Other students jumped in with their own automation tips, showing just how collaborative the @Skillwave.Training community really is. 🤝
Damn... I'd forgotten you wrote that. I'm going to pass that on to the Excel team as I would LOVE to see that native with PivotTables - particularly if it would still resolve values when the PT is in a #SPILL! state..
November 3, 2025 at 7:19 PM
Damn... I'd forgotten you wrote that. I'm going to pass that on to the Excel team as I would LOVE to see that native with PivotTables - particularly if it would still resolve values when the PT is in a #SPILL! state..