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

Performance review season is coming up. Your boss wants numbers. Growth numbers. Specifically, year-over-year growth. When you can quickly show revenue grew 17% YOY and EBIT jumped 23%, you're telling a story. You're showing you understand what moved. I put together a step-by-step guide on calculating YOY growth in Excel. It covers: The exact formula to use (simpler than you think) How to format it so it actually looks professional A conditional formatting trick so trends are obvious at a...

I kept closing Copilot Chat the second it popped up. Every time I logged into Microsoft 365, there it was: I just wanted to get to my apps. This new interface felt like one more thing in the way. Well, finally I gave in. Started experimenting to see which prompts could actually reduce friction. For example, I don't look forward to going through unread emails on Monday morning. Especially when I see 47 emails waiting for me. That's friction. I also waste a lot of time looking for files. I...

You know that chart exists. You made it. It's in this workbook somewhere. Sheet14? 16? Who named these sheets anyway? Excel has a Navigator for this. Most people still don't know it's there. View > Navigation. It opens a pane on the side with a list of all your tabs. You can easily jump between them. Expand any tab, and you'll see an overview of all the contents in the sheet. All your tables, pivot tables, charts, slicers, and any other objects, like shapes and pictures. Use the search box to...