[365 Tip of the Week] Excel + Shadow IT & Copilot Tuning

Written by Aaron Kreps | May 29, 2025 5:00:00 PM

  • XLOOKUP in Excel:  Learn how to find data efficiently, even when searching across multiple conditions.

     

  • What is Shadow IT?:  Understand the risks of unauthorized apps and how to avoid security pitfalls.

     

  • Tuning Microsoft Copilot: See how to adjust Copilot securely without needing a coding or data science background.

 

Microsoft 365

Today’s 365 tip gives you a sharp overview of XLOOKUP, the powerful formula that helps you pull data fast. But we’re not stopping at the basics — this tip also teaches you how to use XLOOKUP across multiple criteria to pinpoint exactly what you’re searching for. It’s like giving your spreadsheets a GPS!

 

Title: Excel Tips XLOOKUP Multiple Criteria

Viewing Time: about 3 minutes

 

 

YouTube Video Description: In this video we cover how to use XLOOKUP to return values using multiple criteria to search. 

 

Cybersecurity

While we’re on the topic of navigating smart, let’s talk about shadow IT — when employees download or use unauthorized apps or tools outside the IT team’s knowledge. Even with the best intentions, shadow IT can create big risks. That’s why it’s critical to check in with your IT provider or team before bringing any outside tech onto your work device. This short video dives into what shadow IT is and how to protect your organization from its hidden dangers.

 

Title: What is Shadow IT?

Viewing Time: under 4 Minutes

 

YouTube Video Description: Do you know what Shadow IT is? Watch this video where Phillip Long talks about Shadow IT and why every business owner must have it on their radar. 

 

AI

Tuning is often a long tedious process requiring deep knowledge in data science. With Copilot, you can tune Copilot securely without any coding or data science background. Learn how to tune Copilot with this video!

 

Title: Copilot Tuning

Viewing Time: about 2 Minutes

 

YouTube Video Description: With Copilot Tuning organizations can now use their own company knowledge to securely train models and create agents that perform domain-specific tasks with a high degree of accuracy – no coding required.
View full post