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.
These 8 Excel features got overlooked
|
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? Either way, maybe forward this to that colleague who could use it. (Comes with demo file and practice exercises they can work through.) ๐๏ธ Quick heads up: Black Friday's around the corner. We're putting together some great offers to help you invest in your skills without breaking the bank. More on that soon. Speaking of learning opportunities... ๐ค Geeky News๐งช Formula by Example finally in DesktopFlash Fill is a cool feature. But it has a downside - it's static. It doesn't adapt when the data changes. โFormula by Example works kind of like Flash Fill - you provide the pattern and it autocompletes - but underneath it generates a dynamic formula. This means the result will update with the data. It's already been available in Excel for the Web, but I only take a real interest once it comes to Desktop. And it just has. Available now in the Current Channel. It's AI-powered, so it requires a Copilot subscription. It only works inside tables and generally needs more examples than Flash Fill. Unlike Flash Fill, it handles numerical calculations. But it won't work in some scenarios that are no problem for Flash Fill. In others, the formula it generates is unnecessarily complex or doesn't make sense. Which I've come to expect from AI. Still, the convenience of Flash Fill with the dynamic recalculation of a formula is a direction I can get behind. It will probably - hopefully - get better. ๐ช New Windows Start MenuWindows 11 is getting a new start menu. It's supposed to address the most common complaints about the current version and offer greater customization. They're bringing back the scrollable list of all apps (without the extra click on "All"). You also get to decide how they're displayed. Default is grouping by Category but you can change it to List view (a standard alphabetic list) or Grid view (alphabetic, but the apps are arranged horizontally). Start menu now dynamically adjusts to the screen size and resolution. It's an optional update included in the 25H2 build, which should roll out in November. By the way, we're creating a mini Windows Productivity course as a bonus give-away for our special Black Friday bundles. Keep an eye out for that. ๐ค Did You Know?Did you like the trick from the video to quickly send your Excel file as an attachment? You can do the same in PowerPoint. Check it out here: ๐ฝ๏ธ Email Your Presentation as PDF with 1 Clickโ ๐ Why go back to basics when you're already good?Congrats to Sina on starting the Black Belt Bundle with Excel Essentials. Turns out the things you think you know? There's usually more there. Going back to the foundations shows you what you've been missing. The tricks you've overlooked. The shortcuts that were always there. 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.
Excel remembers things you teach it. That's not AI. It's a Custom List. And it's been hiding in Excel Options the whole time. That's how you get to automatically fill down months or days of the week. And you can build your own: team names, department codes, project phases - anything you type over and over. Excel learns the order too. So "Mon, Tue, Wed..." or your custom categories fill in automatically. The list lives on your device, not in the file. Set it up once. Use it in every workbook,...
You know that feeling when you're staring at two lists in Excel, trying to spot what's missing? Maybe a product catalog. A list of invoices versus payments. Or a guest list like the below: Whatever it is... checking which one is on the first list but not on the second is.... very slow. And you will miss something. There's a faster way. One conditional formatting rule, and Excel flags every mismatch for you. The second something changes, the highlighting updates too. About a minute to watch....
Pie charts get a bad rep. And honestly? Fair. I'm not a total hater. Two or three slices and a pie chart can tell a perfectly good story. But here's what actually happens in that meeting room when you've got 8+ slices on screen. People glance at the legend, look back at the chart... and have absolutely no idea what they're looking at. They won't say that, of course. Instead, the room either moves on a little too quickly or starts asking questions the chart should have already answered. Either...