Let the user decide


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 sales) in a single chart without overcrowding it?

With Power Pivot and a clever slicer trick, you can let users pick the KPI they want to see.

This avoids cluttering up your dashboard.

Here’s how to set it up:

  1. Add your data to the data model.
  2. Create measures for each KPI.
  3. Create a table for the slicer.
  4. Include guardrails to prevent errors.
  5. Write the DAX measure that switches the KPI view based on slicer selection.

Then, add your chart and format it to match your dashboard! This keeps everything clean and interactive.

Want a detailed guide? Check out our step-by-step tutorial and download the example file to follow along.

Nabanita recently tried this trick to showcase her Power Pivot skills, and her dashboard looked amazing!

She even tagged me on LinkedIn so I could see her final project. ❤️

🤓 Geeky News

📱 Updated behavior of Microsoft 365 mobile apps

Do you sometimes use Excel on your phone?

Microsoft is changing how Excel, PowerPoint, and Word files open on mobile devices.

Before, files opened in the Microsoft 365 app when accessed through Outlook, OneDrive, or Teams.

Now, they will open in the standalone Office apps if you have them installed.

This change helps users who need to open multiple files side-by-side.

Businesses can still manage which apps employees use.

🔒 Sheet Protection in Excel on iPad

Good news if you're using Excel on iPad. It now supports sheet protection.

You can enable, pause, and resume protection. You can also manage settings, change the password, as well as allow or remove edit ranges.

That's handy if you need to access and modify protected sheets on the go.

🍎 Apple Handoff for Office apps

To wrap up the Apple-related news...

Microsoft now supports Apple’s Handoff for Word, Excel, and PowerPoint.

You can switch between Apple devices, like iPhone to iPad or Mac, while keeping your file open.

Ensure both devices have the apps installed. The file must be in OneDrive or SharePoint. Turn on Bluetooth and Wi-Fi, and activate Handoff in Settings.

When switching, a notification will appear, and the same file will open without making a copy.

💚 Excel used for crime(-solving) 😱

If you can't get enough Excel in your work life, why not introduce it to your leisure reading 😉

Check out this compilation of references to Excel in contemporary crime fiction.

After all, it's a truly universal tool.

There's been another one, Frank realized. He dutifully did his research, then added another name to his Excel spreadsheet.
He was up to five now.
Life of Secrets: A Suspenseful FBI Crime Thriller Novel, D. F. Hart

👏 Power Stories

Big shoutout to Norgelio! 🎉 Your dedication to mastering Excel Power Pivot & DAX is inspiring!

Going through the course twice and applying everything at work shows serious commitment.

That's how you make sure those skills stick.

Congratulations on your well-deserved success! Excited to see where your new skills take you next.

Do you have a success story using your XelPlus skills? I’d love to hear it! Just hit reply to share, and your journey could be the inspiration other students need. 😇

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

Global Excel Summit Early Bird tickets available banner

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

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