Skip to content
Let's Talk

No fluff. No wasted words. Just two quick, practical insights every week—one to help you get more out of Microsoft 365, one to keep you safer online. Each tip comes in a short, easy-to-follow video, handpicked by the Endsight team to help you work smarter and stay secure.

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

29 May, 2025

Table of Contents

Monthly Cybersecurity Fundamentals Training

  • 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.
Monthly Cybersecurity Fundamentals Training
Cybersecurity Office Hours

Resources

Previous Tip of the Weeks

Not sure if you should subscribe or not? Check out some samples to see if this newsletter is right for you!

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

05/29/2025

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

Get practical Microsoft 365 tips and cybersecurity insights every week with our short,..

Read More
Last Week's
[365 Tip of the Week] Microsoft Places + Surge in cybercrime

05/22/2025

[365 Tip of the Week] Microsoft Places + Surge in cybercrime

Weekly tips to optimize Microsoft 365 and boost cybersecurity. Short videos and practical advice to..

Read More
Two Week's Ago
Planner + Phone Camera

05/15/2025

Planner + Phone Camera

Discover how to stay productive with Microsoft Planner, protect your phone from hackers, and hear..

Read More

0 Comment

Sort by:

Aaron Kreps

Aaron Kreps

Aaron is a Customer Marketing Specialist at Endsight, focused on helping clients stay informed about the latest in IT and cybersecurity. He creates content, webinars, and resources to support clients and any organization in making confident technology decisions. With a clear and client-centric approach, Aaron ensures Endsight’s expertise is easily accessible and actionable.

Subscribe to 365 Tip of the Week

Subscribe now and start getting a little better every week! No charge. No spam. Unsubscribe anytime.