Hey there,

Here’s an Excel challenge most people struggle with.

Let’s say you’re a schoolteacher from Albuquerque… 🧪🥼

You have a list of your students’ grades, and want to know who got an A in both Chemistry and Geography:

Here’s how to figure it out using the FILTER function.

1. In a new cell, start a =FILTER formula.

2. Array is the values you want returned. So select the range of data with the Students’ names.

3. For Include, select the Chemistry column, make it =”A”, and close brackets. Your formula should look like this:

Press Enter, and you’ll get a list of students who got “A” in Chemistry.

But we want a list of students with “A” in both Chemistry and Geography! Can we just add another condition to the Include argument, to include the Geography column?

No! This would result in an error, because the FILTER function doesn’t support adding multiple criteria in this form.

To include multiple criteria, we need to use an array formula with the multiplication operator (*).

Here's how:

4. Put your first argument inside brackets.

5. Then use an asterisk to multiply that first argument with a second argument that checks if the second column (Geography) is also equal to “A”. Add a final bracket, and you have this correct formula:

​

😆 A Comedy About… Accountants?​

If you’re an accountant or know one… you should know there’s a comedy show about and for accountants called PBC, and it’s hilarious.

It’s a mockumentary-style workplace comedy (like The Office or Parks & Rec) with celebrities like Danny Trejo and Kate Flannery, as well as internet sensations like Corporate Bro and Nick Colletti.

Accounting is a lot more exciting and creative than most people think, and PBS is sure to shift stereotypes and inspire more people to enter the industry. You get to see how an individual accountant can have a lasting impact, even in a typically slow-to-change industry.

​Click here to watch on YouTube!​

Thank you to PBC for sponsoring this issue of XelPlus Weekly 😊

🎬 How to Find Duplicates in Excel

My latest video is about finding duplicate entries in Excel data – a common task for any data analyst! I’ll show you 4 ways to do this, that’ll work in 99% of situations.

🤓 Geeky News

🤖 Windows 11 - A BIG Update
The Windows search bar will soon get AI-powered Bing capability, thanks to Microsoft’s strategic partnership with OpenAI. Another Win11 upgrade will be the Phone Link for iOS feature, which lets you get iPhone text and call notifications on a Windows PC.

📈 Power BI & PowerPoint - A Powerful Combination
PowerPoint integration with Power BI is now generally available! So you can easily add interactive Power BI data visualizations to your PowerPoint presentations, to make them more engaging and informative. To learn how to use this feature, check out my video.

✂️ Snipping Tool - Screen Recording Introduced
I recently got the screen recording feature in Windows’ Snipping Tool. It’s a super quick way of recording your screen and creating MP4 files. You can select which part of your screen you want to record before starting, and preview your recording before sharing or saving it.

💚 My Favorite Things

⏳Time Travelling - Back to Windows 2000
For all those Win11 detractors who’d like to turn back time, I have a solution... A Reddit user created a customization that transform Windows 11 into Windows 2000! Complete with old games, applications, and of course Clippy.

🚀 Power Stories

Thank you to James Griffin for replying to my last email, and sharing this lovely feedback. It made my day:

I love that last sentence!

Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇

See you next week,

Leila

Want more?

▶️ Subscribe on YouTube​

🖇️ Follow me on LinkedIn​

🥇 Join 300,000+ people in our courses​

📣 Want to sponsor XelPlus Weekly? Get in touch here.