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.
2024 in review: celebrating progress and your success
|
We've had an eventful year - and an even busier week! Four of us on the team got together in Vienna to help me record the hardest video I've ever done. It's something I always wanted to be able to do (not just record the video but actually do the thing I show in it). I didn't expect it to be this difficult. But I'm excited to share it with you soon. Hopefully in the first half of the new year once it's edited. As we wrap up 2024, I wanted to share some highlights - many of which came straight from your suggestions. This year, we released 2 new courses: We also tried something new. We created 2 practice packs to let you flex your Excel muscles: In this time, we issued over 1,500 certificates and badges to students who completed our courses. We're super proud of your commitment to continuous learning and development. 👏 This year I also had the privilege to:
For those who missed the webinar (and the replay), we’re planning another session soon - possibly next month. Stay tuned! We're now deep into planning for next year. It will obviously depend on your input. So if you haven't taken last week's survey, please tell us your ideas for XelPlus for next year. 🤓 Geeky NewsAn assortment of Excel gifts from Microsoft, with some Insiders features moving to general availability in December. ❇️ Focus CellsFirst announced just in October, Focus Cells is now rolling out to the Current Channel. This feature highlights the row and column of the active cell. This helps you find the exact cell address of your current position. You can enable it from the View tab or use the shortcut: Alt, followed by W, E, and F pressed in sequence. (Here's hoping for an easier shortcut soon). If you toggle on "Show Auto-Highlight", Focus Cell comes up automatically when you use the Find feature (Ctrl+F). Currently, it doesn't work when Freeze Cells is on, but there's a fix coming early next year. 🔃 Stale Value FormattingThis feature was stuck in Insiders for longer but it's finally rolling out to more users. What it does? By default, Excel recalculates all formulas automatically. But if you find your file slowing down, you may switch to manual (Formulas > Calculation Options). That’s exactly what I used to do with the big finance files I worked on in the past. The problem was that I sometimes forgot to press the recalculate button - and that got me in trouble. The point of Stale Value Formatting is to avoid that. If you change a value, but don't recalculate, Excel gives you a visual cue - like this: This crossed-out formatting highlights the stale - or incorrect - values. Press F9 (or Formulas > Calculate Now) to recalculate. The formatting disappears as the formulas update to show the new values. 📝 Create Forms directly from Excel DesktopIf you have Excel for Microsoft 365, you might have noticed a new feature on the Insert tab: Forms. Excel for the web has had it for a while but after the improvements to Forms data sync introduced this year, we now get it in Excel Desktop. When you select "New Form", the Forms opens in a new window with a blank form. You can draft with Copilot (if your organization has the Copilot license) or choose from the available templates. Meanwhile, a linked table appears in the workbook. It will automatically update as you edit the form or receive responses. You can also create a new form from OneDrive, SharePoint, or a Teams channel. 🎁 Gift a CourseLooking for a gift that needs no batteries, won’t get stuck in shipping, and says, "I care about your future"? A course is perfect for anyone who wants to level up their data skills and impress their boss (or themselves). Here's how it works:
Boom! You’ve just given them the gift of growth - and maybe even a future promotion. 🎉 👏 Power StoriesCongrats to Yakubu! I'm sure confidence in Excel will go hand in hand with your professional development. Wishing you breakthroughs and career milestones ahead. All the best to the entire XelPlus community! To your continued success in 2025! See you in the New Year, 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.
When I worked in finance, the reports I had to build almost always came from more than one sheet. A lot of copy-pasting. These days one formula can do that for you. It's called VSTACK. It stacks your sheets into one list. It stays live, works in Excel Online, and anyone who opens the file knows exactly what's happening. Most people who use VSTACK, use it to glue two ranges together, and think that's it. But that's barely scratching the surface. I put together my top 6 VSTACK tips in this new...
The most common way people mess up their own spreadsheets is a button sitting right there on the Home tab. Merge & Center. It's one of the first buttons anyone learns in Excel, and it does exactly what it says: centers a title, makes a header look tidy. The trouble starts the moment someone uses it inside the data instead of just the header row. Try to sort... yep, it doesn't work. Try to sum a column with a merged cell sitting in the middle of it. Column E, for example: Exactly. You'd have...
What do you do when your data goes wide? Picture a sales table with one row per rep, but then Sales_Jan, Units_Jan, Sales_Feb, Units_Feb, and so on, all the way to December. It just keeps growing wider with every month you add. Try to filter by month, or build a pivot table around it, and you're stuck. Month isn't a value in this table. It's baked into the column headers. You need a way to turn the wide into long so that it's ready for analysis. And there's a Python function that does exactly...