|
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 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 BlueRemember 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:
Have you tried any of these yet? 🧑✈️ More intuitive Copilot in ExcelCopilot 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:
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:
🤔 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 insightsA 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! |
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.
Recently, I spent an hour testing something. I copied data from a PDF into Excel. You might already know what happens when you do that manually: everything from the row jams into one cell. Complete mess. So I opened Copilot in Excel and asked it to split the data for me. It immediately went to formulas. Simple ones first, then increasingly complex combinations. I tested each one. None of them split the values correctly. Here's what I should have done: skipped the manual copy entirely and used...
Someone just joined your team. They got a quick walkthrough from IT. Maybe from you. Now they're staring at a spreadsheet trying not to look lost. You see, there are a few very simple features that would make the life of an Excel newbie a whole lot easier. I cover 8 of them in this video: #1 was shocking when I discovered it. And #7 saved me days when we had to update all our group reporting files after a rebrand. If you already know your way around Excel, be honest: did you know all 8?...
You've built this cool visual using formulas. Dynamic, clean, exactly what the dashboard needs. For example, a waffle chart Now you want to add it to the main dashboard sheet. But there's a problem. If people start clicking around, they might accidentally delete a formula. Or overwrite a cell. And now your carefully crafted visual is broken. You could protect the sheet. Enter password every time you need to make changes. Or you could get creative. Take a snapshot instead. Linked Picture and...