Renaming files doesn't have to be painful


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.
No complicated setup.

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.

“Why is revenue down?”

You spend weeks building a Power BI dashboard.

It’s clean, governed, and approved, yet this is still the first question you get.

Most dashboards show what happened.

Very few explain why or what to do next.

That’s where data storytelling comes in.

With Zebra BI, you can add commentary directly inside Power BI to turn dashboards from monitoring tools into decision-making tools.

Precise comments linked to the right data point help you:

  • add context,
  • preserve knowledge over time,
  • and eliminate the need for PowerPoint explanations or follow-up emails.

If you want to see how modern teams turn dashboards into decisions, watch the video and download the Power BI template examples here.


Many thanks to Zebra BI for sponsoring this newsletter.

🤓 Geeky News

🌳 Windows 11 finally getting new emoji

In 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 users

Well, 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 now

Microsoft 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 Trap

Recently 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 You

Ruth 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!


See you next week,

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!

Leila Gharani - XelPlus

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.

Read more from Leila Gharani - XelPlus

You import a CSV in Power Query... Dates have errors. Numbers won't calculate. What just happened? Here's what's usually happening. Your computer is reading the file with your regional settings. So if your CSV uses commas as decimal separators (like 1,5) but your system expects dots (like 1.5), Power Query gets confused. Same with dates. Is 04/05/2025 April 5th or May 4th? Depends on where you are. The fix: Change Type Using Locale. But here's the part that trips people up - order matters....

Let's say you're waiting for colleagues to submit the latest data. You need to check if the files came in. And if the data is complete. So you start opening files one by one. It's tedious. And completely avoidable. When Microsoft released the new IMPORTCSV function, I wasn't ready to throw Power Query out the window. It still handles far more sources and does things this new function simply can't. But it got me thinking. What if you could peek at a CSV without fully loading it? Just enough to...

Excel's chart formatting menu is dangerous. Not because it's bad. Because it gives you too many options. And some of them have no place in a professional report. Take this social media trend: pasting images directly into your chart bars. Looks creative. Gets lots of views on YouTube. But would you put that in front of your manager? In just a few extra clicks, the same data can look like this: Same logos. Matching brand colors. Just used with intention. 👉 Watch: How to build this chart in just...