The Excel feature that quietly watches everything


You open the file.

The formula’s broken. The chart’s gone.

Cell colors? A rainbow mess.

You don’t know who did it. Doesn’t matter.

Excel’s Version History has your back.

It quietly keeps snapshots of your file, so you can rewind, review, and restore past versions.

Find out what changed, when, and roll back if needed.

Fix the mess. No drama. No blame.

👉 Here’s how to use it—fast.

(BTW, if you want to create a dashboard like the one on the right - before someone took a sledgehammer to it 🔨 - check out our Dashboard Practice Pack.)

🤓 Geeky News

🏃‍➡️ Get to Word faster

Starting in May, Word will pre-load itself quietly in the background as your computer boots. So when you’re ready to write, it’s already stretched and warmed up.

Microsoft is calling it Startup Boost.

It pauses the app until you actually open it, saving time without hogging resources.

Your PC will need at least 8GB of RAM and 5GB of free disk space.

And don’t worry - you can turn it off in Word settings if you’re not into stealthy apps lurking at startup.

Other Office apps will get the same upgrade soon. Stay tuned!

🧰 New quick launcher from PowerToys

If you love handy shortcuts, check out the new Command Palette in PowerToys.

It lets you open apps, folders, files, run system commands, search the web - all from one spot.

Just press Win + Alt + Space to launch it.

It’s similar to the existing Run tool (Alt + Space), but with a fresh design and support for WinGet, so you'll soon be able to install apps too.

Both tools work side by side for now, but Command Palette is the future.

Update PowerToys and give it a spin - it’s free and seriously useful.

I'm a big fan. If you haven't heard about it before, check out this video

🤔 Did You Know?

Double-click Format Painter to lock it in.

Seriously.

You don’t have to click the brush every single time you want to copy formatting across multiple cells.

Just double-click once, and it remembers.

Done? Hit Esc or click the brush again to release the lock.

You can use Excel for decades and still miss some of the small tricks that make everything easier.

👏 Power Stories

I picture Sariyya, late one evening, staring at a Power BI report thinking… “There has to be a better way.”

She knew her data. She knew her team.

But those tricky transformation steps and the whole world of Power Automate? That part felt just out of reach.

Instead of giving up or guessing her way through, she joined the Automate with Power Query and Power Automate course.

Now she's the one leading the way.

These are the moments that mean the most to me.

When someone finds a way forward. When it clicks.

That’s why I do what I do.

Well done, Sariyya. 👏

The most understandable and convenient course I have taken. I work with Power BI and felt gaps in my knowledge of query transformation, and I also wanted to learn how to automate work using Power Automate. This course came in handy. Now I can work more efficiently with colleagues and automate the sending and processing of files.
Sariyya Abdullayeva, Deputy Chief Economist

No newsletter next week - we're hitting a brief pause (so you can too 😉)

While we’re elbow-deep in Python in Excel land, you get a break from tech news.

Enjoy the quiet—big stuff coming soon.

Talk to you soon,

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

If you've ever had to spell out a number on an invoice (or vice versa, convert “seventy-five dollars” into digits) you know how painful it can be. It was always possible in Excel, but required either a macro, or a monster formula. Not for the faint of heart. Now, with Excel's newest function, it's suddenly ridiculously easy. Wanna see how it works? 🙋♀️ Ask me anything! I’m putting together an "Ask me Anything" type of YouTube video for October. Drop any questions 👉 here, and my team will sort...

video preview

I finally got my hands on Excel’s brand-new COPILOT() function. It brings the power of generative AI to your formulas. It’s only just rolling out to Insiders, so most people won’t see it yet. (Others won't see it because they don't have the Copilot license... 👀) Still, it already has the community buzzing. Some are calling it the “function that replaces all others” (spoiler: it doesn’t). Others say it’s pointless. As usual, the truth sits somewhere in between. In the right scenarios, it can...

You’ve probably seen the warnings (including from me): “Never use merged cells!” Is merging cells always bad? Like many things in Excel, the answer isn’t so black and white. There are situations where merging cells makes sense. And others where it completely wrecks your spreadsheet’s functionality. Here’s the simple rule I follow: ✔️ Top of the sheet for clean headers? Merge all you want. ❌ Middle of your data table? Absolutely not. (You can get the same effect with a smarter method... read...