Skip to content

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

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
Tip of the Week: Teams Updates, SMB Security, and ChatGPT Projects

08/07/2025

Tip of the Week: Teams Updates, SMB Security, and ChatGPT Projects

Eight new Microsoft Teams features, why cybersecurity matters for small businesses, and learn how..

Last Week's
365 Tip of the Week! Excel Visuals, SharePoint Security, and AI Agents

07/31/2025

365 Tip of the Week! Excel Visuals, SharePoint Security, and AI Agents

Visually enhance Excel sheets, recent SharePoint app breach, and explore how AI Agents can..

Two Week's Ago
Tip of the Week: Teams Timer, Windows 10 Security, and Copilot

07/24/2025

Tip of the Week: Teams Timer, Windows 10 Security, and Copilot

Office 365 Business Tips! Add a timer to Microsoft Teams, security risks of Windows 10’s..

0 Comment

Sort by:

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.