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.
Excel just turned 40 (here's what I actually use)
|
So Excel turned 40 this week! Officially middle-aged. But no mid-life crisis here. In fact, it's getting better with age. I had a thought as I was walking to work on Wednesday: What are the top 10 features I actually used in the past 40 days? Not my favorites. But ones I ended up using the most. Here's my list: 1. Power Query Ten years ago, only TWO of these would be on my list! You know what's crazier though? Most people I talk to don't even know Excel has half these features. Meanwhile, I can't imagine doing my work without them. I have YouTube videos on all of these if you want to learn the basics. But if you're serious about mastering them, our XelPlus courses go way deeper. What would be on your list? โ Speaking of what's new in Excel... โ ๐ค Agent ModeBig birthday, big release. Microsoft just introduced Agent Mode for Excel and Word. It's the latest AI feature that promises to leave regular Copilot in the dust. They're calling it "vibe working" (yeah, even though "vibe coding" has gotten a pretty bad rep lately). Agent Mode takes complex Excel tasks and breaks them down step-by-step. Start with a simple prompt and watch it work in real time: building financial reports, running analyses, creating loan calculators... It beats Copilot in accuracy but still trails human analysts. My take: Cool tool. But someone still needs to check the work, own the results, and explain it to the boss when things go sideways. AI's great at doing. Not so great at being accountable. Available now for Microsoft 365 Copilot licensed users and Microsoft 365 Personal or Family subscribers. Works in Excel and Word on the web (desktop coming soon). To try it, install the Excel Labs add-in and choose Agent Mode (Frontier). I'm taking it for a spin to see if it has potential to make it to my top 10. I'll report back. โ ๐ซ Pivot Tables now #SPILLEven the oldest features on my list are getting fresh updates. If you use Pivot Tables, you probably know that annoying popup when something blocks the expansion. Now, Excel is replacing the popup with an in-cell #SPILL! error, just like in FILTER or SORT functions. Your Pivot Table collapses into the first cell showing the error. Clear the blockage when you're ready. No popup interrupting your flow. Now rolling out to Insiders on the Beta channel. This change should improve the Auto-refresh experience, which was introduced back in July. โ ๐ Excel Summit 2026 - Early Bird tickets now on sale!Want to know where I go to actually learn what's new in Excel and connect with people who geek out about it as much as I do? Global Excel Summit. The 2026 website just launched. First speakers are announced. And I'll have the pleasure of opening the conference again next year! Same venue (Soho Place Theatre in London), better timing. They swapped freezing February for hopefully warmer May. ๐๏ธ 19-20 May 2026 (conference) ๐๏ธ 18, 20, 21 May 2026 (masterclasses) If spending a few days in London with fellow Excel experts sounds like your kind of thing, early bird tickets are live now. Online passes available too. Use code LEILA at checkout for 20% off on top of the Early Bird discount. (The discount code box shows up at the last step. Click "Continue to Checkout" twice, then enter LEILA in the Order Summary.) โ ๐ The Excel Birthday MusicalHow do you properly celebrate Excel's birthday? Why, with a musical number, of course ๐ When Giles Male from Full Stack Modeller asked me to fly to the UK for this, I was like: what? what is this? what do you mean? He said: Don't worry. So I didn't.... until I heard the lyrics. ๐ (At least I didn't have to sing them, you'll be relieved to know ๐) Yeah, we all have serious jobs. But you gotta have some fun sometimes, right? Speaking of serious work... โ ๐ Excel doesn't have to be scaryWhen I started using Excel in 2000, I was completely overwhelmed. I know exactly how it feels to stare at a tool and have no idea where to start. So when I read this note from Amir, I got it: Excel can do a LOT. Which is exactly why it feels overwhelming. It helps when you know what to ignore and what to focus on. That's what the Excel Essentials Bundle is built for. 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.
Recently, I spent an hour testing something. I copied data from a PDF into Excel. You might already know what happens when you do that manually: everything from the row jams into one cell. Complete mess. So I opened Copilot in Excel and asked it to split the data for me. It immediately went to formulas. Simple ones first, then increasingly complex combinations. I tested each one. None of them split the values correctly. Here's what I should have done: skipped the manual copy entirely and used...
Someone just joined your team. They got a quick walkthrough from IT. Maybe from you. Now they're staring at a spreadsheet trying not to look lost. You see, there are a few very simple features that would make the life of an Excel newbie a whole lot easier. I cover 8 of them in this video: #1 was shocking when I discovered it. And #7 saved me days when we had to update all our group reporting files after a rebrand. If you already know your way around Excel, be honest: did you know all 8?...
You've built this cool visual using formulas. Dynamic, clean, exactly what the dashboard needs. For example, a waffle chart Now you want to add it to the main dashboard sheet. But there's a problem. If people start clicking around, they might accidentally delete a formula. Or overwrite a cell. And now your carefully crafted visual is broken. You could protect the sheet. Enter password every time you need to make changes. Or you could get creative. Take a snapshot instead. Linked Picture and...