I'd been using Excel for 10 years...


The files I used to have in my corporate job were pretty large. Like 40+ sheets. Some had more.

I used to dread opening one of these during a presentation. Someone would ask me to pull up a specific sheet. And I'd be scrolling... checking... scrolling...

It wasn't fun.

Then someone showed me a simple click to see all the tabs in one place. I'd been using Excel for 10 years by that time and had NO CLUE this existed.

That's just one of 4 methods I cover in this week's video, including one that makes your workbook look like an app. You'll be amazed how simple it is.

video previewโ€‹

๐Ÿ”ฝ Download the file to get inspired.

Turns out Excel can be pretty user-friendly when you want it to be.

โ€‹

๐Ÿ“ฒ Learn on the go (even offline)

Did you know you can watch XelPlus courses on your phone using the Teachable mobile app?

And here's the best part: you can download lessons and watch them completely offline.

Flights. Long commutes. Or like Aneta, one of our members, shuttling kids around to after-school activities.

How to get started:

  1. Open your app store and search for "Teachable online courses" (works on both iOS and Android)
  2. Download the app and log in with the email you used to enroll in the course
  3. Select XelPlus Academy by Leila Gharani and pick your course

Your progress syncs automatically across all your devices. Start a lesson on your computer, finish it on your phone.

โ€‹

๐Ÿค“ Geeky News

๐Ÿค– Agent Mode in Excel now on desktop (but not for us in the EU yet)

Microsoft just made Agent Mode generally available on Windows and Mac. It was already on Excel for the web since December, but now it's in the desktop app too. At least outside EU and UK.

What's new: you can now choose between OpenAI's GPT 5.2 and Anthropic's Claude Opus 4.5 models. Microsoft says different models handle different tasks better, so they're letting you pick. They've also added web search with source citations.

Unlike the "standard" Copilot experience (Agent Mode also requires a Copilot license), Agent Mode is supposed to be self-sufficient. You describe the desired end result, it figures out how to get there. No chatting, just doing.

My initial experiments (back when it was still in preview) didn't blow me away. Microsoft claims it's much more reliable now.

We'll have to see... I'm a Claude fan, so I'm curious to test that option when it finally rolls out here.

๐Ÿค– Anthropic published Claude's constitution (promises not to destroy humanity)

Speaking of... Anthropic just released Claude's constitution. It's the rule book for how their AI model should behave.

The big priorities: be helpful, be honest, be safe. Don't help anyone build bioweapons. Don't undermine human oversight. Pretty standard "please don't go rogue" stuff.

They also admit there's a gap between what they want Claude to do and what it actually does. Training is hard. They'll make mistakes and "hopefully correct them."

Well, that's... reassuring?

The constitution is released under Creative Commons, so anyone can use it. Check out the whole 80 pages if you're curious. Or ask Claude to summarize ๐Ÿ‘€

๐ŸŒˆ Google is killing Gmailify and POP email fetching

In non-AI-related news...

โ€‹Google's shutting down two email features this month: Gmailify and POP fetching.

Gmailify let you connect non-Gmail accounts (Yahoo, Outlook, AOL) and get Gmail's spam filtering, smart inbox sorting, and search. Not anymore.

You can still read non-Gmail accounts in the Gmail mobile app. But you lose the spam filtering and inbox organization that made Gmailify useful.

POP fetching pulled emails from other accounts directly into your Gmail inbox on desktop. The alternative is to set up automatic forwarding with your other email provider. It works, but it's an extra step.

โ€‹

๐Ÿ™Œ "They ask for my help now"

Big congrats to Francisco on completing Excel Essentials for the Real World.

Years of Excel experience... But like most of us, he learned by copying whatever solution someone showed him once. That became the way. Forever.

Francisco Eiras

Product Engineer

Excel is not new to me, but I thought that I missed some of the Excel fundamentals because when I started using it more than 30 years ago, we did not "have time" to learn the background; we went directly to the solution taught by someone who knew a little more than us. And that solution became the solution forever, even if there exist dozens of different ways to do it, some of them even better. With this course, I get the basis to explore new things.

I know some things more than my colleagues, and they are the ones who ask for my help/advice now.

30 years in, and he's still finding better ways. Well, same here. I'm still learning new things too.

See you next week,

Leila

โ€‹

When you're ready, here are some ways we can help:

๐ŸŽ“ Join 400,000+ members in our coursesโ€‹

๐Ÿ“บ Get free tutorials on YouTubeโ€‹

๐Ÿ‘ฅ Train your whole team with our courses. Team pricing and progress tracking - reply for details.


This newsletter contains affiliate links, which give us a small commission at no cost to you. 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

Your Power Query file works perfectly. On your machine. Then someone else tries to use it and suddenly nothing refreshes because the folder path points to your laptop. This is why people move files to SharePoint. Same folder, everyone can access it, no more path issues. Great. You'll just use the SharePoint Folder connector and... ๐Ÿ˜ต๐Ÿ’ซ Ok, which path it's supposed to be? Here's the catch: Power Query shows you a giant list of URLs instead of folders. Well, there is a better way. And it takes...

Performance review season is coming up. Your boss wants numbers. Growth numbers. Specifically, year-over-year growth. When you can quickly show revenue grew 17% YOY and EBIT jumped 23%, you're telling a story. You're showing you understand what moved. I put together a step-by-step guide on calculating YOY growth in Excel. It covers: The exact formula to use (simpler than you think) How to format it so it actually looks professional A conditional formatting trick so trends are obvious at a...

I kept closing Copilot Chat the second it popped up. Every time I logged into Microsoft 365, there it was: I just wanted to get to my apps. This new interface felt like one more thing in the way. Well, finally I gave in. Started experimenting to see which prompts could actually reduce friction. For example, I don't look forward to going through unread emails on Monday morning. Especially when I see 47 emails waiting for me. That's friction. I also waste a lot of time looking for files. I...