A chance to meet and geek out


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!

  • 📅 When? February 4-6, 2025
  • 📍 Where? Soho Place Theatre, London (UK)

Get 30% off with the early bird discount.
And if you use my code LEILA at checkout, you’ll save an additional 20%!

(The early bird discount is automatically applied. To get the additional 20%, continue to checkout and enter the code LEILA in the Order Summary before placing your order.)

📊 A Cool Chart Trick

At 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:

  1. Choose a simple image that's hosted online.
  2. Use the IMAGE formula to set the image size based on your data.

Example:

=IMAGE(URL_source,,3, [height], [width])

(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 Austria

I'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 tablet

Microsoft 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 Notes

The 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 ease

Google 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 Stories

Speaking 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!

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.

Read more from Leila Gharani - XelPlus

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...

interactive chart with measures changing with slicer selection

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...

If you’re like me, you’ve probably faced this problem before: You open up a dataset, and it’s filled with blank rows. Ugh! Cleaning this data is like ironing a crumpled suit you found in the back of that long-neglected closet. (I’m not a fan of ironing - I always end up with creases in the wrong places. And honestly, if I try deleting hundreds of blank rows manually, I’d probably delete something important!) But don’t worry, fixing it is way easier than it seems. In today's Between the...