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:

• try your hand at video editing with Clipchamp
• back up your Kindle library
• Missed Thursday's Webinar? Join us Tuesday!

​

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:

1. Go to the Formulas tab.
2. Click Watch Window (it’s in the Formula Auditing group).
3. Click Add Watch, select the cell(s) you want to monitor, and hit Add.

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:

• Ctrl+[ selects all cells with precedents (within the sheet)
• Ctrl+] selects all cells with dependents (within he sheet)

Hit reply and let me know: what’s the most confusing formula problem you’ve ever had?

​

💚 Webinar Highlights

It'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 editor

Clipchamp 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 Teams

Together 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:

1. Select View > Together mode in the meeting toolbar.
2. Under Everyone in the meeting toolbar, you can Change scene and Assign seats.
3. Once you're happy with the setup, select Everyone to send all participants to Together mode.

📚 Back up your Kindle library while you can

Amazon 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 Stories

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