Copy-paste is messy. Combine data smarter.


Copy-paste isn't a strategy.

When your data is spread across multiple sheets, keeping it all in sync gets messy fast.

Excel’s VSTACK gives you a smarter way. It lets you pull everything into one clean table with a single function.

No macros. No Power Query. Just a formula.

Add FILTER or SORT on top (or the new trimrefs), and suddenly you have a setup built to scale.

▶️ Watch the tutorial on our blog

📄 Download the practice file

The video takes me back 😉 I had fun playing both roles.

And yes, I still like to challenge our editor (he claims spreadsheets alone aren’t “entertaining enough”… strange, I know 🤷).

🤓 Geeky News

💀 Black is the new Blue

Remember this? (*shudder*)

After nearly 40 years, the infamous Blue Screen of Death is turning black.

Windows 11 is rolling out a simplified Black Screen of Death. No sad face, no QR code. Just the stop code and faulty driver info, so IT pros (and brave users) can fix issues faster.

This update also brings Quick Machine Recovery, designed to help your PC bounce back after a crash.

Aesthetic glow-up and better resilience? We’ll take it.

💬 Threads come to Teams (finally!)

(No, not the social media site.)

Teams is rolling out threaded replies in channels - currently in public preview.

Now you can reply directly to a message without derailing the whole conversation.

Threads keep context together, and a new “Followed Threads” view helps you track the ones that matter, all in one place.

Also in public preview:

  • React to messages with multiple emojis (for those whose emotions can't be captured in a single image 😉🙊)
  • Trigger workflows using emoji reactions (e.g., escalate a ticket with ❗️)
  • Customize your keyboard shortcuts
  • Improved slash commands like /goto and /gif

Have you tried any of these yet?

🧑‍✈️ More intuitive Copilot in Excel

Copilot just got better at reading your mind (well… almost).

It can now figure out which table or range you mean, based on your words, not just where your cursor is.

Try asking:

  • “Analyze the ice cream prices”
  • “Sort the table on the top right”
  • “Explain the formula in G7”

It also shows a subtle outline around the data it’s using, so you always know what it’s working with.

Oh, and also, in Excel for the Web:

You can now type “=” anywhere and just say what formula you want. Copilot will write it for you, right from the grid.

💚 Did You Know?

These are exciting updates, but if you felt Copilot has been too pushy lately, you can now shut it up.

I'm talking about the "Start with Copilot" pop-up you get whenever you open a new workbook (in Excel Desktop).

It’s meant to guide new users… but if you already know your way around a spreadsheet, it can feel like an annoying speed bump.

So, if it feels more intrusive than helpful, here’s how to turn it off:

  1. Go to File > Options > Copilot
  2. ✅ Check "Turn off auto-start for Copilot"

🤔 What are your thoughts?

Does Copilot help you get more done, or get in your way?

I imagine the Noob character loves it (it doesn't shout at her like the Pro does! 🫢)

And the Pro grumbles about Copilot (but sneakily uses ChatGPT on the side 🤭)

👏 From Excel limits to Power BI insights

A big congrats to Alec for finishing the Fast Track to Power BI course! 👏

Love seeing posts like his.

He realized Excel can only take you so far. And instead of stopping there, he took the next step.

That’s what it’s about: Staying curious. Leveling up.

Using tech to make work better (and easier). Well done, Alec!

See you next week,

Leila

Want more?

▶️ Subscribe on YouTube

🖇️ Follow us on LinkedIn

🥇 Join 400,000+ students in our courses

📣 Want to sponsor Between the Sheets? Get in touch here.

📨 If you were forwarded this message, you can get the free weekly email here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. 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

A German Controller Magazine recently said certain time series analysis techniques are "not realistically feasible with Excel." I read that and thought: challenge accepted. So that's what I opened with at the Global Excel Summit in London on Tuesday this past week. Three techniques. Python's data science libraries. Done right inside Excel, live on stage. (And no, the cape on the table isn’t mine. IYKYK) Because Python is in Excel now. The limits people keep assuming are there... a lot of them...

Some tasks shouldn't still exist in 2026. Manually emailing PDF reports at end of month is one of them... but they do. Here's the drill: Open Excel. Save a few sheets as PDF. Email to Manager A. Save others as PDF. Email to Manager B. Repeat. I used to have a VBA macro that did that for me. It was great. Until companies started blocking macros. Until Excel Online became a thing. Now there's a solution built into Excel that works on desktop and the web. You decide who gets which sheets. The...

There's a person on almost every team that everyone respects technically. And nobody wants to work with. Maybe you've sat in a meeting with them and left feeling a little smaller than when you walked in. Early in my career, I think I was sometimes that person. You see, I went by the advice "work hard and you'll be noticed" for years. Turned out to be the worst advice I ever got. What I missed for a long time: doing my job well was expected. That's why I was hired. But it wasn't what was going...