Trying to filter multiple pivot tables in Excel at the same time—without losing your sanity? You’re not the only one. In this quick tutorial, I’ll show you how to use a slicer (a.k.a. Excel’s way of making filters way less painful) to sync filters across pivot tables automatically. No more toggling each one like it's 2003. Whether you're building dashboards for coworkers, clients, or your own peace of mind, this trick will save time and frustration. Perfect for anyone who's ever screamed, "Why won’t these pivot tables just talk to each other?!"
Tuesday, June 10, 2025
Monday, June 9, 2025
How to Delete Specific Characters in Power Query
Learn how to clean text data in Power Query using Text.Select and Text.Remove—no coding required. In this step-by-step Power Query tutorial, you’ll discover how to remove unwanted characters from text columns in Excel or Power BI. Whether you're dealing with extra spaces, special symbols, or strange characters from messy data imports, this video shows you how to clean it all up fast. We’ll cover how to use Text.Select and Text.Remove functions to streamline your data cleaning process and keep your queries running smoothly. Open Power Query and follow along—your spreadsheets will thank you.
Sunday, June 8, 2025
Excel + M365 Copilot: First Impressions You NEED to See
Curious about how Microsoft 365 Copilot works in Excel? Here's what really happens when AI meets spreadsheets. In this video, I share my first hands-on experience using Copilot in Excel, exploring how it handles tasks like generating formulas, analyzing data, and suggesting insights—all with just a few prompts. It's not exactly magic, but it does make some of Excel’s most tedious tasks way easier. I’ll break down what worked, what felt clunky, and the moments that actually impressed me. If you’ve been wondering whether Copilot in Excel is worth using for real-world tasks or just another shiny feature you’ll ignore, this one’s for you.
Subscribe to:
Posts (Atom)