|
Uh-oh. Embarrassing typo in the file name. And there's 50 of them. 🫨 Individual contracts about to go out to clients. You could rename them one by one. Or you could fix the whole mess in five seconds using something already built into Windows. No downloads. Just PowerShell. 👉 I show you exactly how here. (BTW, if PowerShell doesn't pop up after typing the name in Explorer, try powershell.exe.) And if typing commands makes you nervous, there’s a drag-and-drop option built into Windows 11 too. 👉 I walk through that version here (including how to rename files using a custom mapping — not just “add prefix” or “find & replace”). Next time you’re staring at a folder full of IMG_1234.jpg files… You’ll know better. PowerShell, Power Automate, PowerToys... sensing a pattern? 😉 Before its Copilot obsession, Microsoft was all about Power. 🤓 Geeky News🌳 Windows 11 finally getting new emojiIn the biggest news of the week: Microsoft might finally have Emoji 16.0 support. New emoji get added through the Unicode Consortium. They release updated standards that tech companies then adopt. Unicode 16 came out in September 2024. Apple added these back in March 2025. Android's had them for a while. Windows is just now getting around to it, starting with Insiders. The new set includes Leafless Tree, Shovel, Splatter, and Face with Bags Under Eyes. So if you've been waiting with bated breath for that leafless tree, the wait will soon be over. 🤞 To check if it's there, open the Emoji picker: Win + . (that's Windows key and dot). 🛍️ ChatGPT adds ads for free usersWell, it was a long time coming. OpenAI just announced they're rolling out advertisements to free ChatGPT accounts as well as to the cheapest paid tier (Go). Running AI datacenters costs money. And OpenAI needs revenue. According to OpenAI, the ads won't appear in your chat responses themselves. They'll show up in separate boxes labeled "Sponsored" after ChatGPT answers your question. OpenAI also says ads won't influence the answers you get, and your conversations stay private from advertisers. If you're on ChatGPT Plus, Pro, or any of the business/education plans, you won't see ads. Anthropic's Claude and Copilot are not following suit. For now. 🤖 Copilot cares about your screen time nowMicrosoft appears to have added a new feature to Copilot: it reminds you to take a break. After a few hours of heavy use, a notification pops up saying "Time for a break? Copilot is an AI, but you're not. It might feel nice to take a breather." Meanwhile, they keep rolling out new Copilot features: pinned chats, long-term memory, study mode, group chat summaries, and a limit increase for pasting text. They're also testing Copilot during Windows 11 setup. While your computer installs updates, you can try the full chat interface. No Microsoft account needed. So yeah, Microsoft really wants you to use Copilot. 🤔 The Fake Productivity TrapRecently I've been thinking about how AI can actually waste your time if you're not careful. You ask for help. It gives an answer. Doesn't work. You tweak the prompt. Try again. An hour later, you've gotten nowhere. I see two scenarios where AI actually helps instead of just spinning your wheels. 👉 Watch: How to use AI without falling into the trap 🙌 What Three Courses Gets YouRuth just finished her third XelPlus course. The Pricing Manager started with "regular" Excel, moved to Power Pivot, now building full Power BI reports. Notice the progression. Each skill builds on the last one. Regular Excel analysis. Then data models and DAX in Excel. Now Power BI with beautiful visuals and user-friendly reports that depend on those DAX formulas. One year. Three courses. Complete transformation in how she works with data. Congratulations, Ruth! Leila When you're ready, here are some ways we can help: 🎓 Join 400,000+ members in our courses 📺 Get free tutorials on YouTube 👥 Train your whole team with our courses. Team pricing and progress tracking - reply for details. This newsletter contains affiliate links, which give us a small commission at no cost to you. Thank you for your support! |
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
Shared Excel files are great until your whole team needs to work on it at once. You filter for your tasks. Your colleague filters for theirs. Now your filter's gone. You filter again. They filter again. 😤 It's like fighting over the TV remote, except it's a spreadsheet so more annoying. The fix: Sheet View. Go to View tab > Sheet View > New. You'll notice the column and row headers change to black. Give it a name. This way you can reuse it later. Just type over the "Temporary View". Now...
The files I used to have in my corporate job were pretty large. Like 40+ sheets. Some had more. I used to dread opening one of these during a presentation. Someone would ask me to pull up a specific sheet. And I'd be scrolling... checking... scrolling... It wasn't fun. Then someone showed me a simple click to see all the tabs in one place. I'd been using Excel for 10 years by that time and had NO CLUE this existed. That's just one of 4 methods I cover in this week's video, including one that...
Your Power Query file works perfectly. On your machine. Then someone else tries to use it and suddenly nothing refreshes because the folder path points to your laptop. This is why people move files to SharePoint. Same folder, everyone can access it, no more path issues. Great. You'll just use the SharePoint Folder connector and... 😵💫 Ok, which path it's supposed to be? Here's the catch: Power Query shows you a giant list of URLs instead of folders. Well, there is a better way. And it takes...