I’ve got exciting news! In February 2025, I’ll be back at the Excel Summit in London, and I’d love for you to join me. Last year, being there in person was something else. The sessions were great, but what I loved most was meeting people face-to-face. That’s what made it unforgettable. The energy, the connections - you just don’t get that online. I’m really excited to experience it all again, and I hope to see you there!
📊 A Cool Chart TrickAt last year's Summit, my Excel MVP friend, Chandoo, shared a great chart trick that I think you'll like! He showed us how we can use the IMAGE function to create a type of chart. Let’s say you’re comparing website traffic on different days. Instead of using plain numbers, you can display images that change size based on the data. It’s a quick way to make your charts stand out. Here’s how to do it:
Example:
(replace [height] and [width] with the values) And that’s it! The images will automatically resize depending on the values, giving you an easy visual comparison of your data. It’s a creative twist that makes your charts more engaging and easier to read. Find out more about the IMAGE function - now generally available to all Microsoft 365 users - in our blog post. (It also covers how to insert images inside cells from the Excel menu). Upcoming Event in AustriaI'll be speaking at Controlling Insights Steyr on November 22nd. There will be sessions on sustainability practices, Europe's geopolitical situation and AI tools for controllers (that's my session). If you're working in controlling & finance in Austria, this is a great opportunity to learn and network. You can read more about the event here. Hope to see you there! 🤓 Geeky News💻 Stream Windows to your phone or tabletMicrosoft has launched the Windows App for Windows, macOS, iOS, iPadOS, and web browsers. A public preview is available for Android users. The app combines Windows services like Windows 365, Azure Virtual Desktop, and Remote Desktop. It offers a consistent experience across devices. It supports a multi-monitor setup and allows users to customize their home screens. It’s especially useful for remote work, offering a security and productivity boost. 📝 Updates to the new Sticky NotesThe new Sticky Notes app has had some useful enhancements. This one made me really happy! What annoyed me the most about the old Sticky Notes is that it didn't stay on the screen when I worked in another app. But now finally we can pin 📌 a note and it's always ON TOP! This lets you work in another window without losing access to your note. To pin your note, click on "pop out your note" and then select the pin icon. The old Sticky Notes are still available. If you want to try the new features, look for the yellow and pink icon. 🙃 🌈 Tabs to navigate through a Google Doc with easeGoogle Docs is adding tabs to help organize longer documents. Users can access tabs by clicking the bullet-point icon in the top-left corner. The "Show tabs & outlines" feature opens a side panel with the structure of the document. There, you can add and manage multiple tabs and subtabs. It supports up to three levels of nested subtabs, which can be customized with labels and emojis. Tabs make it easy to jump between sections without needing separate files. Editors can rename, duplicate, move or delete tabs. Others can view them in suggestion mode. Users can also share links to specific tabs. 👏 Power StoriesSpeaking of chart wizards, it was a pleasure to meet Carlos Barboza in London earlier this year. His session at GES 2024 was fantastic. He came as a fan, with a suitcase full of Excel textbooks for the many Excel gurus present to sign. Meanwhile, he's a well-deserving MVP in his own right. It was a nice surprise to have him enroll in my Business Charts in Excel course. He's already a data viz master. Do I have anything new to teach him? I'll let him explain: Thanks, Carlos, for the lovely feedback. Looking forward to seeing you again in London next year! There's always more to learn. You can discover new approaches, untreaded paths, shortcuts and tricks. I learn from other instructors, from fellow MVPs, and from my students. Keep an open mind and keep learning. And the Global Excel Summit is a great opportunity to do just that. 😉 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! |
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.
My video on Copilot in Excel sparked a lively discussion in the comments. The concerns that kept popping up were: "is it going to make me redundant?" and "is it still worth learning Excel?" My take: No and yes (especially if you want the first answer to be no). AI tools like Copilot lower the barrier to entry. For Excel newbies, it's easier to describe what they want to happen than knowing where to click. But Copilot doesn't just do stuff for you. It can also be a learning tool. Ask it to...
I'll be honest. I wasn't impressed with Copilot when it first came out. It was pretty limited. Specially in Excel. But after the recent updates, things changed. On the agenda today: examples where Copilot in Excel excels a whole new Teams experience more AI features in MS Paint 🎬 The best of Copilot in Excel Not that long ago, when I tried to use Copilot in Excel, it refused to cooperate. It wasn't a one time thing. It was constantly having trouble of some sort. But since then, it has moved...
I just love seeing all the cool ways you’re using the techniques from our courses. Watching you bring these ideas to life is what makes teaching so exciting for me! So, this week, I’m sharing a few tips and updates I think you’ll really enjoy: A simple DAX trick for interactive dashboards 📊 Handy updates to Excel’s mobile app 📱 And yes, Excel even showing up in a crime novel! 🔍 📊 Make Your Dashboards Interactive with This Slicer Trick Ever wish you could fit more KPIs (like profit, cost, or...