Pages

▼
Wednesday, July 2, 2025

Power Query Row Count Tricks You Should Know

›
https://youtu.be/t2WAw7l9EQw Power Query has more row-counting tricks than your team has unread Slack threads—and that’s saying something. W...
Monday, June 30, 2025

How to Use REGEX in Excel (Complete Guide for Smarter Data!)

›
https://youtu.be/sogoDpuf4Kw Think REGEX in Excel is only for tech wizards or keyboard jedis? Yeah, no. If you've ever had to wrestle wi...
Tuesday, June 10, 2025

Control Multiple Pivot Tables with One Slicer in Excel

›
https://youtu.be/b7hGDNyMWgw Trying to filter multiple pivot tables in Excel at the same time—without losing your sanity? You’re not the onl...
Monday, June 9, 2025

How to Delete Specific Characters in Power Query

›
https://youtu.be/W5q7D_sMoyo Learn how to clean text data in Power Query using Text.Select and Text.Remove—no coding required. In this step-...
Sunday, June 8, 2025

Excel + M365 Copilot: First Impressions You NEED to See

›
https://youtu.be/LOHjjC3Mnak Curious about how Microsoft 365 Copilot works in Excel? Here's what really happens when AI meets spreadshee...
Thursday, May 22, 2025

Stop Using INDEX MATCH! Try This Two-Way XLOOKUP Trick Instead

›
https://youtu.be/TkncclDZliM Want to do two-way lookups in Excel without getting tangled in helper columns or INDEX MATCH gymnastics? In th...
Tuesday, May 20, 2025

Use This Excel Percent Trick to Save Time (PERCENTOF Guide)

›
https://youtu.be/5lpkoOtOCdk Tired of calculating percentages in Excel like it's still 2004? In this quick tutorial, you'll master t...