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

The good thing about Excel is formulas update automatically. Change an input, the output adjusts. Ok. You know that. But what if you want the output to be a specific number. What should the input be? Let's say, your boss is standing right by your shoulder, staring at your spreadsheet. "We need to reach $2,500 in revenue this month. How many units do we need to sell?" You could keep tweaking the units cell until you get close. Guess, check, guess again. Pleasant enough if you're alone. Not so...

Most people open ChatGPT, drop in an Excel file, and type two words. Analyze this. What comes back looks good. The numbers, the insights, the tidy summary. But how do you actually know if it's right? Last week I put ChatGPT through a proper test. A messy, multi-sheet sales file with codes, lookups, and calculations it had to figure out on its own. Then I verified the results myself with a data model in Excel. There's a specific workflow that makes the difference between trusting AI blindly...

I always build my formulas the same way. I include extra rows below my data, just in case someone adds more next month. And every time, I get a column with zeros. A blank row that should be invisible suddenly shows up as zero in the spilled list. Annoying, but there are ways around it. My go-to was to wrap in a FILTER. Recently it got a lot simpler. One function. Or even better, one character. Add a dot before or after the colon in your range, like A2:.A100, and Excel quietly drops the blank...