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.
Stop scrolling! Excel hack you need to see
|
You’re on a deadline, staring at an Excel sheet, and something isn’t adding up. Somewhere in the endless grid of numbers, a formula is off - but where? Luckily, Excel has built-in tools to reveal those elusive connections between cells. You can track key numbers and understand your formulas at a glance. Also in Between the Sheets today:
Keep Important Numbers In Sight! 👀Ever find yourself constantly scrolling back and forth in a big Excel file just to check a few important numbers? There's a better way! Meet the Watch Window - it keeps important cells visible no matter where you are in your workbook. Here’s how to set it up:
Now, your selected cells stay visible in a floating window that always stays on top. Even when you switch sheets. No more hunting for that one number. Just focus on your work, and let the Watch Window do the watching. You can see what happens when you change your assumptions. Make changes to the inputs and observe how the formulas update in real time. That's super handy. Why not check out the other Formula Auditing tools while you're there. They can save you a ton of troubleshooting time. Use the tracing options to understand which cells feed into which formula. 🔵 Trace Precedents → Shows which cells affect the selected formula. Perfect for understanding where numbers come from. 🔴 Trace Dependents → Shows which formulas use the selected cell. Great for checking what will break if you change a number. When you enable them, Excel draws arrows to reveal the connections.
🔙 Remove Arrows → Clears those tracing arrows when you're done. Bonus Tip: You can also use shortcuts:
Hit reply and let me know: what’s the most confusing formula problem you’ve ever had? 💚 Webinar HighlightsIt's been great hosting another webinar last Thursday. Thanks to everyone who participated. It was great seeing your excitement about the new tools and what they can do. If you missed it, you have a chance to catch the next one on Tuesday, February 25th, 6 PM CET. You'll learn the strategies and tools you'll need to save at least 10 hours per week in Excel - and no it's not an exaggeration.
Why not share the signup link with someone who you think will benefit? 😊 🤓 Geeky News🎞️ Improvements to the Clipchamp video editorClipchamp is a free video editing program included with Windows. It's currently rolling out some highly requested updates. They include updates to the interface, making it more streamlined and beginner-friendly, as well as offering dark mode. (It's all the rage these days, I hear 😉) The editing workflow has also been improved. You can now group assets, such as music, text, visuals, and group them into one track. Editing the timeline is more precise with the addition of timestamps. They've also added AI captions. If you want to try your hand at video editing, give it a go and let us know how it went. 👥 Changes to Together mode in TeamsTogether mode brings all the participants of a Teams call into the same virtual space. With the latest changes (currently in Preview), there's less risk you'll enable it by accident. The setup is now multi-step:
📚 Back up your Kindle library while you canAmazon is removing the ability to download your Kindle books to your computer. Until now, you could back up your collection (book by book) using the "Download & transfer via USB" feature that's going away on February 26th. This gave you the opportunity to convert the books to a different format if you switched to a different reader. From next Wednesday on, you'll only be able to access your Amazon eBooks on Kindle devices and apps. 👏 Power StoriesCongrats to Michel for earning his Power BI badge. 🎉 Power BI is the end-to-end data analysis tool. Sure, creating visuals may be the most enjoyable part of the process. But you won't have good visualizations without good data. With Power BI, you get to clean and model the data properly before you start reporting on it. Michel now has the skills needed to create an insightful report. And I'm glad he finds it satisfying. 😁 Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇 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.
When I worked in finance, the reports I had to build almost always came from more than one sheet. A lot of copy-pasting. These days one formula can do that for you. It's called VSTACK. It stacks your sheets into one list. It stays live, works in Excel Online, and anyone who opens the file knows exactly what's happening. Most people who use VSTACK, use it to glue two ranges together, and think that's it. But that's barely scratching the surface. I put together my top 6 VSTACK tips in this new...
The most common way people mess up their own spreadsheets is a button sitting right there on the Home tab. Merge & Center. It's one of the first buttons anyone learns in Excel, and it does exactly what it says: centers a title, makes a header look tidy. The trouble starts the moment someone uses it inside the data instead of just the header row. Try to sort... yep, it doesn't work. Try to sum a column with a merged cell sitting in the middle of it. Column E, for example: Exactly. You'd have...
What do you do when your data goes wide? Picture a sales table with one row per rep, but then Sales_Jan, Units_Jan, Sales_Feb, Units_Feb, and so on, all the way to December. It just keeps growing wider with every month you add. Try to filter by month, or build a pivot table around it, and you're stuck. Month isn't a value in this table. It's baked into the column headers. You need a way to turn the wide into long so that it's ready for analysis. And there's a Python function that does exactly...