|
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.
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...
Someone asked me recently about automation tricks in Excel. Fair question. Everyone's talking about AI agents right now. Microsoft's pushing them hard, every tech company's got one. But here's what they don't mention in the demos: AI agents cost extra. They work maybe half the time. You're basically hoping they get it right. Meanwhile, you already have a tool that does exactly what you tell it to. Every single time. Power Automate. You've probably got access already (comes with most Microsoft...
AI is everywhere. And I mean everywhere. Your email tool has it. Your spreadsheet has it. Even your coffee maker is probably marketing itself as "AI-powered" these days. The pitch is always the same: "This will do your work for you." "Build fully functional apps without knowing how to code." "10x your productivity." And yeah, sometimes AI actually delivers. It's genuinely impressive when it does. But here's what I've noticed: when it works, the work doesn't disappear. It just changes. You go...